Subject | Re: [firebird-support] Extract data to SQL script, FK-friendly |
---|---|
Author | Jorge Andrés Brugger |
Post date | 2007-03-16T13:29:30Z |
Thanks Milan, that seems what I´m looking for.
I´ve sent you a private mail about make it even better :)
Alan: FBExport works with one table at a time, AFAIK. Thanks anyway!
Milan Babuskov escribió:
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
[Non-text portions of this message have been removed]
I´ve sent you a private mail about make it even better :)
Alan: FBExport works with one table at a time, AFAIK. Thanks anyway!
Milan Babuskov escribió:
> 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.
>
>
>
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
[Non-text portions of this message have been removed]