Data-only migration (Schema already exists)
Posted by: Nicolai Hoge
Date: June 15, 2005 07:39AM

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.

Options: ReplyQuote

Written By
Data-only migration (Schema already exists)
June 15, 2005 07:39AM
June 24, 2005 02:16PM

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.