Subject RE: [firebird-support] To extract Schema and Data from SQL DB
Author Alan McDonald
> Hi,
>
> Is there a tool available to extract Schema and Data in the form of
> SQL scripts either from an SQL DB or existing FireBird DB.I would like
> to use the extracted SQL scripts to then Create a fresh DB and
> populate the Data.
>
> Thanks,
> -Kumar

gbak backup and restore is your ultimate solution but you can also extract
metadata using isql then run the script in isql, then use a 3rd party
datapump tool to move the data e.g. clever components, but this is slower
Alan