How to Migrate MSSQL Server 2008 Database to MySQL?
-
Saturday, November 10, 2012 2:00 PM
Hii,
I want to convet MS SQL databasse to MySQL. I am using MySQL Workbench. The only problem i am facing is MS SQL Server Uniqueidentifier datatype. Error i receive when migrating is "Default value newid() is not supported.".
In many table Uniqueidentifier is a Primary and Foreign key. Is this possible the primary and foreign keys remain relational during migration.
What are best ways to do above migration.
Thanks
- Edited by Rana Anees Saturday, November 10, 2012 2:10 PM
All Replies
-
Tuesday, November 13, 2012 6:36 AMModerator
Hi Rana Anees,
You can use function UUID() in My SQL instead of NEWID() function, please see: http://forums.sugarcrm.com/f6/developed-auto-generate-ids-guids-within-mysql-2895/
You can use SSIS to move data to MySQL database: http://blogs.msdn.com/b/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx
And you can also use MySQL Migration Toolkit: http://www.convert-in.com/sqlkit.htm
Since the issue is most related to MySQL, you can post you question to MySQL forum: http://forums.mysql.com/
Thanks,
EileenEileen Zhao
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Wednesday, November 21, 2012 1:01 AM
.png)
