Re: Migration of mySQL database fails
Posted by: Zoe Ouyang
Date: January 31, 2006 05:11PM

Have you found a solution to this problem?

I'm having the exact same problem here as well.

I'm migrating a huge table from an MS SQL database to MySQL database using Migration Toolkit version 1.0.22rc. The table consists of 200,000,000+ rows with row length being 150+ averagely. And the migration process would stop due to the error after about 120,000 rows got transfered. And the error message given as following:

The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java heap space

Any help will be greatly appreciated. Thanks!

Options: ReplyQuote


Subject
Written By
Posted
K N
January 21, 2006 10:17AM
Re: Migration of mySQL database fails
January 31, 2006 05:11PM


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.