Re: Data migration

[Michael G. Zinner]

Nicolai,

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.

Example:

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

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



Hope this helps,
Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



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