[Ilugc] RE: convert database from MySQL to MS SQL
- From: prem@xxxxxxxxxxxxxxxx (Prem Kurian Philip)
- Date: Thu Oct 18 11:16:32 2007
i need to convert my database from MySQL to MS SQL .
i have idea about to convert from MS SQL to MySQL using perl
script this has been predefine in the mysql server .
any converter is available in Linux for solve this issue .
any one can tell to solve this issue
You can do this in two stages.
Step 1:
You can use a tool like PhpMyAdmin (or Toad for MySQL) and connect to your
MySQL database and then generate a SQL dump.
Once you have this dump, you can edit the file using a text editor and
make some minor changes in the DDL (create tables statements) to handle
the case of autoincrement fields. MySQL and MSSQL deals with autoincrement
fields a little differently. MS SQL uses something called Identities.
http://www.databasejournal.com/features/mssql/article.php/3307541
Once you have edited this text fields, you can use tools such as Toad on
windows to setup the tables on MS SQL.
Toad for MySQL:
http://www.quest.com/toad-for-mysql/
Regards,
PK
Other related posts: