MySQL Forums
Forum List  »  Microsoft SQL Server

Migrate MSSQL Database (10+GB database size) to MySQL community
Posted by: Shamshad Ali
Date: July 21, 2022 01:03AM

I'm trying to migrate MSSQL database to MySQL, using Workbench 8.0.29, but it seems it won't migrate all tables' all rows. Few tables have limitation with row size 65,535 and few having billions of records which it won't migrate at all. Is there any way to easily manage this migration?
Also auto_increment is not updated during migration. What is the best way to migrate with auto_increment too?

I have gone through multiple google suggestions but they are not satisfactorily providing solution.
Please share if one has practically done migration successfully, and had any proper documentation/tool available. We have several large databases in queue. Also debate if migration is a better step or what?

Regards.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.