Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
faq:migration-toolkit:fk-convert [2019/06/12 08:54]
administrator
faq:migration-toolkit:fk-convert [2019/07/19 12:40]
darya.prikhodkina
Line 1: Line 1:
-====== How to ensure ​that Foreign ​key is converted successfully ​from MySQL to MSSQL Server ======+====== How to Ensure ​that Foreign ​Key is Converted Successfully ​from MySQL to Microsoft SQL Server ======
  
 Foreign keys in MySQL and in MSSQL has the same structure. Foreign keys in MySQL and in MSSQL has the same structure.
-Structure of the Foreign key in the MSSQL:+Structure of the Foreign key in MSSQL:
     [ FOREIGN KEY ]      [ FOREIGN KEY ] 
         REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ]          REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ] 
Line 8: Line 8:
         [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]          [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] 
    
-Structure of the Foreign key in the MySQL:+Structure of the Foreign key in MySQL:
     FOREIGN KEY [id] (index_col_name,​ ...)     FOREIGN KEY [id] (index_col_name,​ ...)
         REFERENCES tbl_name (index_col_name,​ ...)         REFERENCES tbl_name (index_col_name,​ ...)
Line 14: Line 14:
         [ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION}]         [ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
  
-The only difference is RESTRICT word in MySQL database, that has no equivalent in MSSQL database. +The only difference is RESTRICT word in MySQL, that has no equivalent in MSSQL database. 
-But in MySQLforeign key constraints are checked immediately,​ so NO ACTION and RESTRICT are the same.  +But in MySQL foreign key constraints are checked immediately,​ so NO ACTION and RESTRICT are the same.  
-So during ​import ​there is no errors should arise. To check if conversion of the actions of the Foreign keys was successful ​you should ​check it in the database.  ​+During ​import no errors should arise. To check if conversion of the actions of Foreign keys was successful, please ​check the database.  ​