Re: Needed: An Efficient, reliable and smart way to copy data from one DB to another

Ted Byers wrote:
> "Hal Rosser" <hmrosser@xxxxxxxxxxxxx> wrote in message
> news:plbhf.9624$KP1.1427@xxxxxxxxxxxxxxxxxxxxxxxxx
>> [snip]
>> There's an easier way -
>> create a DSN for your SQL database
>> Then right-click the table in Access and choose 'Export'
>> You can export the whole table easily that way.
>> I used this method to export tables from Access to mySQL, so I'm sure it
>> will also work to MS-SQL.
>>
>>
> There is a much easier way. I visited the MySQL site today and found they
> have a new migration tool. I used it to transfer the data in a matter of
> minutes. Now I'd like to see the source code for that tool so I can see how
> they did it so quckly.
>
> Cheers,
>
> Ted
>

Ted,

As a followup, the code in question is at
http://svn.mysql.com/svnpublic/mysql-migration-tool/source/java/com/mysql/grt/modules/MigrationGeneric.java

Look for the doDataBulkTransferTableToMysql() method.

Regards,

-Mark
.