Subject RE: [firebird-support] To extract Schema and Data from SQL DB
Author Nigel Weeks
> 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.
>


A tool to extract the schema is included:
isql -X -u sysdba -p masterkey server:/path/to/database.fdb >
file_to_contain_the_schema.sql

You'll have to use a datapump to get INSERT statements out of it.

Just a thought - why not do a backup and restore to a new database?

Nige.