Re: Data migration
Posted by: Michael G. Zinner
Date: June 24, 2005 02:16PM


There are multiple ways to do this.

Solution #1

You have to perform the migration as you would do a full migration. But on the Object Creation Options page you simple de-select

[ ] Create Objects Online

This will not create the objects on your MySQL server.

Solution #2

Once you are one the Bulk Transfer Settings page, you can select [Store current application state] from the main menu.

When you start the tool a 2nd time, you can select [Reload stored application state] and the tool will go to the Bulk Transfer Settings page immediately.

This way, only the bulk data transfer is performed.

Solution #3

Another way is to save the migration process as a script. Perform the migration as usual. But on the last page with the summary report, you can click on the button [Generate Migration Script] (added in 1.0.8)

In this script you can comment out the block that contains the object creation. Use --[[ and ]] to comment out a block.


-- create database objects online
print("Create database objects.")

grtV.toLua(targetConn.modules.TransformationModule), "executeSqlCreateStatements",
{targetConn, "global::/migration/targetCatalog", "global::/migration/creationLog"}
grt.exitOnError("The SQL create script cannot be executed.")

Hope this helps,

Michael Zinner, Team Lead, Developer Tools

Are you MySQL certified?

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

Options: ReplyQuote

Written By
Re: Data migration
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.