Subject | Re: SQL Dialect 3 vs.1, Database porting & Networking |
---|---|
Author | Adam |
Post date | 2006-02-17T02:54:50Z |
>What
> Would you be able to elaborate on this procedure a bit further ?
> sort of application do I use ? or is there some command linefunction
> which connects the two DBs and populates the 2nd empty one if youhave
> created the empty tables ?Most of the 3rd party db admin tools have metadata extract tools that
are clever enough to get the dependencies working.
If you have a 'blank' dialect 3 database, then you could use a
datapump program to do the hard work. IBDataPump
(www.clevercomponents.com) is what I use to pump data from one
database to another.
Adam