Hi Ann

Thanks for your response.

At 12:21 am 14/05/2005, you wrote:

>I'd use QLI and the following set of commands:
>
>qli> ready old_database.fdb as source
>qli> ready new_database.fdb as target
>qli> for x in target.rdb$relations with x.rdb$system_flag = 0 or
>con> x.rdb$system_flag is null
>con> begin
>con> print "target."||x.rdb$relation_name || " = source." ||
>con> rdb$relation_name on "foo.qli"
>qli> @...

Can these above commands be put into a script of sorts and fed to qli. I
tried to get help for qli but either it gives errors or starts the interpreter.

>For each table in the target database, qli will move the data from the
>source database matching relation names and field names.

Is this code adaptive, meaning can I give however old a database for the
latest version of the same database and it will transfer the data? I can
understand if it can't match a table name and or a field name then nothing
happens.

Also I hope I don't have to manually provide table names?

Sorry for dumb questions but I am a newbie for FireBird and whatever
development I have done in the database is using GUI tools for FireBird.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.10 - Release Date: 13/05/2005