Data-only migration (Schema already exists)

[Nicolai Hoge]

Hi.
I would like to use The Migration Toolkit to migrate data only from a MSSQL server to MySql. (We migrated the schema before your product haad MSSQL support).

In the migration plan drawing in the GUI, there is a path for data only, however there doesn't seem to be a way of actually doing this in the application.

I would like to do something like this:
1. select data from MS source tables. (preferrably with row/column filters)
2. Do not migrate the schemata itself.
3. Select a target schemata on MySql
4. Transfer data to the tables in the target schemata

I don't manage to do this. If I try to "cheat" i.e. say that I don't want to migrate any objects, then it migrates the schemata anyway. The schemata is also named "dbo" rather than the correct name. Then when I try to transfer data it doesn't transfer anything, because the objects doesn't exist on the target server. In the newly created schemata.



Edited 3 time(s). Last edit at 06/24/2005 02:54PM by Edwin DeSouza.