Re: migration agent

[Michael G. Zinner]

The Migration Agent can only be used from a script at the moment and has no separate installation. When you look into the installation directory you will find a grtsh.exe file.

This is the command line interface to the scripting engine we use. When you start it with

grtsh -listen 12345

on the server machine. Then the "agent" will listen on that port.


In the script the following function can be used to execute a function on the server side.

-- ----------------------------------------------------------------------------------------
-- @brief Invoke a remote agent function and wait it to finish.
--
-- Invokes a remote function, polling the agent until it is finished.
-- Once finished, it will return the exit status and result value.
--
-- The first parameter has to be a table {hostname= "192.168.1.100", port= 12345}
--
-- @return {error : error_status, result : result_value }
-- ----------------------------------------------------------------------------------------
function grt.callRemoteFunction(agent, module, funcname, argument, syncGlobals)

As you see, this is non trivial at the moment. We are working on getting this into the GUI but I cannot promise a release date yet.

The easiest solution at the moment is, to run the Migration Toolkit either on the machine MSSQL runs on or MySQL. Then you will get the same performance.

Mike