You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2006/03/16 23:02:58 UTC
svn commit: r386467 - in /db/derby/site/trunk:
build/site/integrate/db_ddlutils.html
src/documentation/content/xdocs/integrate/db_ddlutils.xml
Author: jta
Date: Thu Mar 16 14:02:57 2006
New Revision: 386467
URL: http://svn.apache.org/viewcvs?rev=386467&view=rev
Log:
Added note about using DdlUtils to migrate an alpha Derby database to an
official Derby release.
Modified:
db/derby/site/trunk/build/site/integrate/db_ddlutils.html
db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_ddlutils.xml
Modified: db/derby/site/trunk/build/site/integrate/db_ddlutils.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/integrate/db_ddlutils.html?rev=386467&r1=386466&r2=386467&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/integrate/db_ddlutils.html (original)
+++ db/derby/site/trunk/build/site/integrate/db_ddlutils.html Thu Mar 16 14:02:57 2006
@@ -240,7 +240,7 @@
<a href="#Add+an+import+target+to+the+build.xml">Add an import target to the build.xml</a>
</li>
<li>
-<a href="#Execute+the+Ant+task-N1021F">Execute the Ant task</a>
+<a href="#Execute+the+Ant+task-N10227">Execute the Ant task</a>
</li>
</ul>
</li>
@@ -275,19 +275,25 @@
<a href="http://db.apache.org/ddlutils/ant-tasks.html">DdlUtils Ant tasks</a>.
</p>
<p>
-Now, this example features Derby as both the source and target database
-because Derby is easily available and is what the author knows.
-But it's important to realize that there's an even easier way to
-migrate a Derby database from one machine to another:
-all you need to do is copy the Derby database files.
-You don't need to export/import the schema and data,
-not even for machines with different architectures,
+This example features Derby as both the source and target database
+because Derby is easily available and is what the author knows, but it can
+be used with any of the databases that
+<a href="http://db.apache.org/ddlutils/database-support.html">DdlUtils
+supports</a>.
+Usually there's an even easier way to migrate a Derby database from
+one machine to another: just copy the Derby database files.
+If the source and target machines use official Derby releases
+you don't need to export/import the schema and data, not even for
+machines with different architectures,
because the files that make up a Derby database are platform-independent.
-So, substitute the Derby source database in this example
-with the vendor of your choice and you'll get an idea of
-how DdlUtils can make it easier to migrate any database to Derby.
+However, if you want to upgrade a Derby database to or from an alpha
+version of Derby to an official release,
+you must export the schema and data because Derby doesn't support
+<a class="external" href="http://wiki.apache.org/db-derby/UpgradingTen">upgrading</a>
+an alpha database.
+DdlUtils makes this migration easier.
</p>
-<a name="N10026"></a><a name="Target+Audience"></a>
+<a name="N1002E"></a><a name="Target+Audience"></a>
<h3 class="boxed">Target Audience</h3>
<p>DdlUtils doesn't have an official release yet,
so this example is intended for developers -- and for users who have a
@@ -301,7 +307,7 @@
variables, and troubleshooting
any problems that might occur.
</p>
-<a name="N10030"></a><a name="Prerequisites"></a>
+<a name="N10038"></a><a name="Prerequisites"></a>
<h3 class="boxed">Prerequisites</h3>
<p>This project assumes a basic knowledge of Derby.
If you're new, start with the on-line
@@ -330,7 +336,7 @@
</div>
-<a name="N10066"></a><a name="Step+1%3A+Setup+a+working+directory"></a>
+<a name="N1006E"></a><a name="Step+1%3A+Setup+a+working+directory"></a>
<h2 class="boxed">Step 1: Setup a working directory</h2>
<div class="section">
<p>
@@ -348,7 +354,7 @@
</div>
-<a name="N1007D"></a><a name="Step+2%3A+Build+and+Install+DdlUtils"></a>
+<a name="N10085"></a><a name="Step+2%3A+Build+and+Install+DdlUtils"></a>
<h2 class="boxed">Step 2: Build and Install DdlUtils</h2>
<div class="section">
<p>
@@ -402,7 +408,7 @@
-<a name="N100BF"></a><a name="Step+3%3A+Create+a+sample+database%3A+Books1"></a>
+<a name="N100C7"></a><a name="Step+3%3A+Create+a+sample+database%3A+Books1"></a>
<h2 class="boxed">Step 3: Create a sample database: Books1 </h2>
<div class="section">
<p>
@@ -468,7 +474,7 @@
</div>
-<a name="N100F9"></a><a name="Step+4%3A+Books1+--+Export+Schema+and+Data"></a>
+<a name="N10101"></a><a name="Step+4%3A+Books1+--+Export+Schema+and+Data"></a>
<h2 class="boxed">Step 4: Books1 -- Export Schema and Data </h2>
<div class="section">
<p>
@@ -478,7 +484,7 @@
<a href="http://db.apache.org/ddlutils/ant-tasks.html">DdlUtils Ant tasks</a>
to execute the export.
</p>
-<a name="N1010C"></a><a name="Create+an+Ant+build.xml+file+with+an+export+target"></a>
+<a name="N10114"></a><a name="Create+an+Ant+build.xml+file+with+an+export+target"></a>
<h3 class="boxed">Create an Ant build.xml file with an export target</h3>
<p>
Complete source for the Ant build file is below.
@@ -558,7 +564,7 @@
</li>
</ul>
-<a name="N1016A"></a><a name="Execute+the+Ant+task"></a>
+<a name="N10172"></a><a name="Execute+the+Ant+task"></a>
<h3 class="boxed">Execute the Ant task</h3>
<p>
Now execute the task with <span class="codefrag">ant</span>:
@@ -580,7 +586,7 @@
</div>
-<a name="N1018F"></a><a name="Step+5%3A+Books2+--+Create+Database+and+Import+Schema+and+Data"></a>
+<a name="N10197"></a><a name="Step+5%3A+Books2+--+Create+Database+and+Import+Schema+and+Data"></a>
<h2 class="boxed">Step 5: Books2 -- Create Database and Import Schema and Data</h2>
<div class="section">
<p>
@@ -590,7 +596,7 @@
<a href="http://db.apache.org/ddlutils/ant-tasks.html">DdlUtils Ant tasks</a>
to execute the import.
</p>
-<a name="N101A2"></a><a name="Copy+and+%28maybe%29+modify+the+db-schema.xml+file"></a>
+<a name="N101AA"></a><a name="Copy+and+%28maybe%29+modify+the+db-schema.xml+file"></a>
<h3 class="boxed">Copy and (maybe) modify the db-schema.xml file </h3>
<p>
The export step created a file called <span class="codefrag">db-schema.xml</span>. Copy that
@@ -626,7 +632,7 @@
</li>
</ul>
-<a name="N101E0"></a><a name="Add+an+import+target+to+the+build.xml"></a>
+<a name="N101E8"></a><a name="Add+an+import+target+to+the+build.xml"></a>
<h3 class="boxed">Add an import target to the build.xml</h3>
<p>
Copy the source for the <span class="codefrag">import-target-db</span> target below
@@ -677,7 +683,7 @@
</li>
</ul>
-<a name="N1021F"></a><a name="Execute+the+Ant+task-N1021F"></a>
+<a name="N10227"></a><a name="Execute+the+Ant+task-N10227"></a>
<h3 class="boxed">Execute the Ant task</h3>
<p>
Execute the task with <span class="codefrag">ant</span>:
@@ -706,7 +712,7 @@
</div>
-<a name="N10238"></a><a name="Step+6%3A+Verify+Migration"></a>
+<a name="N10240"></a><a name="Step+6%3A+Verify+Migration"></a>
<h2 class="boxed">Step 6: Verify Migration</h2>
<div class="section">
<p>
@@ -727,7 +733,7 @@
</div>
-<a name="N10254"></a><a name="Caveats"></a>
+<a name="N1025C"></a><a name="Caveats"></a>
<h2 class="boxed">Caveats</h2>
<div class="section">
<p>
@@ -740,7 +746,7 @@
</div>
-<a name="N10262"></a><a name="Questions%3F"></a>
+<a name="N1026A"></a><a name="Questions%3F"></a>
<h2 class="boxed">Questions?</h2>
<div class="section">
<p>Please post questions about this example to
@@ -752,7 +758,7 @@
<p>
-<em>Last Updated: March 13, 2006</em>
+<em>Last Updated: March 16, 2006</em>
</p>
Modified: db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_ddlutils.xml
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_ddlutils.xml?rev=386467&r1=386466&r2=386467&view=diff
==============================================================================
--- db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_ddlutils.xml (original)
+++ db/derby/site/trunk/src/documentation/content/xdocs/integrate/db_ddlutils.xml Thu Mar 16 14:02:57 2006
@@ -22,18 +22,25 @@
to Derby using the
<a href="http://db.apache.org/ddlutils/ant-tasks.html">DdlUtils Ant tasks</a>.
</p>
+
<p>
-Now, this example features Derby as both the source and target database
-because Derby is easily available and is what the author knows.
-But it's important to realize that there's an even easier way to
-migrate a Derby database from one machine to another:
-all you need to do is copy the Derby database files.
-You don't need to export/import the schema and data,
-not even for machines with different architectures,
+This example features Derby as both the source and target database
+because Derby is easily available and is what the author knows, but it can
+be used with any of the databases that
+<a href="http://db.apache.org/ddlutils/database-support.html">DdlUtils
+supports</a>.
+Usually there's an even easier way to migrate a Derby database from
+one machine to another: just copy the Derby database files.
+If the source and target machines use official Derby releases
+you don't need to export/import the schema and data, not even for
+machines with different architectures,
because the files that make up a Derby database are platform-independent.
-So, substitute the Derby source database in this example
-with the vendor of your choice and you'll get an idea of
-how DdlUtils can make it easier to migrate any database to Derby.
+However, if you want to upgrade a Derby database to or from an alpha
+version of Derby to an official release,
+you must export the schema and data because Derby doesn't support
+<a href="http://wiki.apache.org/db-derby/UpgradingTen">upgrading</a>
+an alpha database.
+DdlUtils makes this migration easier.
</p>
<section>
@@ -517,7 +524,7 @@
</section>
-<p><em>Last Updated: March 13, 2006</em></p>
+<p><em>Last Updated: March 16, 2006</em></p>
</body>
</document>