Subject Re: [firebird-support] Extract data to SQL script, FK-friendly
Author Milan Babuskov
Jorge Andrés Brugger wrote:
> I want to export to a SQL script a complete database, but only data, not
> metadata (I need to change collations to several domains and field, so
> I've done a database script and modified it).

No need to export, you can use FBCopy to copy the data directly from old
to new database.

http://fbexport.sourceforge.net/fbcopy.html

> Tools I´ve tried (EMS DB Extract, for example) extracts data in
> table-name alphabetic order, and then I cant use such script to re-fill
> the database, because of FK restrictions.
> How can I do this task?

FBCopy reads the foreign keys, so it knows the exact order needed to
copy the data.


--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org