Re: Migration Errors .. Solution is here..

[Bipin Kadam]

Here is solution...for Windows OS

I got same problem by using migration toolkit for mysql.
I am doing migration of data from sql server 2000 to mysql.

By this method you can solve problem for the single table migration. And then repeat same method for other tables...

Solution is :
1. Use odbc driver, you can get it at this location http://dev.mysql.com/downloads/connector/odbc/3.51.html
Install it..

2. Now create DSN (Data source name for given datbase connection). This dsn will contain connection to your mysql database.

3. In sql server 2000, there is concept of DTS i.e. data transformation services.
create new dts, Drag and drop "other odbc connection" and specify your dsn name in that connection, which you specified in step 3.

4. Also drag and drop source connection i.e. say "ole db provider for microsoft sql server".

5. Create transformation between them. And execute the DTS.
That's it.... :)



Edited 2 time(s). Last edit at 10/29/2007 06:35AM by Bipin Kadam.