Author: plavin
Date: 2006-12-08 17:43:59 +0100 (Fri, 08 Dec 2006)
New Revision: 4168
Log:
Add chapter on scripted migration
Added:
trunk/migration-toolkit/scripting-migration.xml
Modified:
trunk/migration-toolkit/indepth.xml
Property changes on: trunk/migration-toolkit/scripting-migration.xml
___________________________________________________________________
Name: svn:executable
+ *
Modified: trunk/migration-toolkit/indepth.xml
===================================================================
--- trunk/migration-toolkit/indepth.xml 2006-12-08 16:09:13 UTC (rev 4167)
+++ trunk/migration-toolkit/indepth.xml 2006-12-08 16:43:59 UTC (rev 4168)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 2; 772 bytes
@@ -908,8 +908,8 @@
<para>
Click the <guibutton>Generate Migration Script</guibutton> to create
- a <literal>lua</literal> script file of the migration process. With this
- file you can script the migration of this database or
+ a <literal>Lua</literal> script file of the migration process. With this
+ file you can script the migration of a database or
customize it. For more information about this topic see,
<xref linkend="invoking-grt-from-command-line"/>.
</para>
Added: trunk/migration-toolkit/scripting-migration.xml
===================================================================
--- trunk/migration-toolkit/scripting-migration.xml (rev 0)
+++ trunk/migration-toolkit/scripting-migration.xml 2006-12-08 16:43:59 UTC (rev 4168)
Changed blocks: 1, Lines Added: 130, Lines Deleted: 0; 4046 bytes
@@ -0,0 +1,130 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % fixedchars.entities SYSTEM "../common/fixedchars.ent">
+ %fixedchars.entities;
+ <!ENTITY % gui-common.entities SYSTEM "../gui-common/gui-common.ent">
+ %gui-common.entities;
+]>
+<chapter id="migration-scripting">
+
+ <title>Migration Scripting</title>
+
+ <para>
+ As noted earlier in
+ <xref linkend="mysql-migration-toolkit-indepth-summary"/>, if you
+ choose to generate a migration script when migrating a database, a
+ <literal>Lua</literal> script will be created. You can find out
+ more about Lua by going to
+ <ulink url="http://www.lua.org/">lua.org</ulink>.
+ However, if you have some familiarity with programming you should
+ be able to make sense of this script
+ without too much effort.
+ </para>
+
+ <para>
+ This section reviews a simple migration script. You can create your
+ own migration script by following the steps outlined in
+ <xref linkend="mysql-migration-toolkit-indepth"/>.
+ </para>
+
+ <section id="migration-script">
+
+ <title>The Migration Scripting Steps</title>
+
+
+ <para>
+ The migration script is conveniently divided up into six checkpoints:
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Set Source and Target Connection
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Do the Reverse Engineering
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Migration Methods and Ignore List
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Set Object Mappings and Do Migration
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Generate and Execute SQL Create Statements
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Bulk Data Transfer
+ </para>
+ </listitem>
+
+ </orderedlist>
+
+ </para>
+
+ <para>
+ Each checkpoint will be examined in turn. For a better understanding
+ of the migration script, it is useful to have the GRT shell open
+ within the &migration_toolkit;. Do this and you will see how the
+ various objects in the GRT Globals Tree are referenced from the shell.
+ Press <keycap>F4</keycap> to open the GRT shell.
+ </para>
+
+ <section id="setting-source-target-connection">
+ <title>Setting the Source and Target Connection</title>
+
+ <para>
+ In Lua comments are
+
+ Find the <literal>-- Set source connection</literal> line.
+ Immediately below this is the code that defines the database that
+ is being migrated.
+ </para>
+
+ <para>
+ With the GRT shell open and the <guilabel>Values</guilabel>
+ tab selected, double click the <literal>migration</literal> object
+ and find the <literal>sourceConnection</literal> object. Click this
+ item and its parameters and the values of those
+ parameters will be exposed in the frame beneath the Globals tree.
+ </para>
+
+ <para>
+
+ </para>
+
+
+ <para>
+ both the <literal>modules</literal> and
+ <literal>parameterValues</literal>
+ </para>
+
+ <para>
+
+ </para>
+
+ </section>
+
+
+ </section>
+
+<!-- End Chapter -->
+
+</chapter>
Property changes on: trunk/migration-toolkit/scripting-migration.xml
___________________________________________________________________
Name: svn:executable
+ *
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r4168 - trunk/migration-toolkit | plavin | 8 Dec |
