Subject | Re: [firebird-support] Extract data to SQL script, FK-friendly |
---|---|
Author | Milan Babuskov |
Post date | 2007-03-15T20:13:40Z |
Jorge Andrés Brugger wrote:
to new database.
http://fbexport.sourceforge.net/fbcopy.html
copy the data.
--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org
> I want to export to a SQL script a complete database, but only data, notNo need to export, you can use FBCopy to copy the data directly from old
> metadata (I need to change collations to several domains and field, so
> I've done a database script and modified it).
to new database.
http://fbexport.sourceforge.net/fbcopy.html
> Tools I´ve tried (EMS DB Extract, for example) extracts data inFBCopy reads the foreign keys, so it knows the exact order needed to
> 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?
copy the data.
--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org