Graham wrote:

>
> So, now I'm on step 10.2. I've edited the get_tables.sql file to
> point to my file, but I'm not clear on how I execute this file.

The easiest thing to do is find one of the tools that copies data from
one database to another. Look here:
http://www.ibphoenix.com/?page=ibp_mig_tools

Or try the sequence that follows.


Regards,


Ann

> qli

QLI> @get_tables.sql

That will produce output like this:

define relation tgt.<table1>
based on relation src.<table1>;
define relation tgt.<table2>
based on relation src.<table2>;
...
tgt.<table1> = src.<table1>;
tgt<table2> = src.<table2>;
...


edit the output, adding the lines necessary to open the source database
and create the target.

connect database.gdb user 'sysdba' password 'masterkey;
create database 'new.fdb' user 'sysdba' password 'masterkey';
finish
ready database.gdb as src
ready new.fdb as tgt

define relation tgt.<table1>
based on relation src.<table1>;
define relation tgt.<table2>
...

call that file move.sql.

QLI> @...

Hope this helps.