Geek asks and answers

MySQL & # 8594; SQL Server Migration Assistant with LARGE table issue

I am trying to migrate my old MySQL database of my company to SQL Server 2008.

I use SQL Server Migration Assistant for MySQL software and everything works fine except for large tables (some of which contain about 150 million + rows). He creates a circuit, etc., and when I select the data transfer that I receive, he remains at the level Migrating myTable > myTable with 0 of 159216578 rows processed- he remains this way for about 1-2 hours, then it crashes and says that he could not create the error file.

Are there any things / settings that I can change to make this work? Is there a better way (I have access to the file .frm, .MYD, .MYIif there is anything that I can do so) - I'm open to anything as long as I bear the table.

Thank!!

+5
source share
1 answer

I think you want to export about 10 milion rows at a time (depending on the MySQL hardware) using something in the WHERE clause that will allow you to split the data (ID, date, etc.).

SELECT * FROM Table1 WHERE ID BETWEEN x and y INTO OUTFILE 'C:\temp\data.csv';

You can use the SQL Server Import / Export Wizard to get it in MSSQL.

0
source

More articles:


All Articles