MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:plavin Date:December 8 2006 4:44pm
Subject:svn commit - mysqldoc@docsrva: r4168 - trunk/migration-toolkit
View as plain text  
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-toolkitplavin8 Dec