Subject | Extract data to SQL script, FK-friendly |
---|---|
Author | Jorge Andrés Brugger |
Post date | 2007-03-15T17:41:35Z |
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).
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?
Regards!
--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar
metadata (I need to change collations to several domains and field, so
I've done a database script and modified it).
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?
Regards!
--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar