Subject | RE: [firebird-support] To extract Schema and Data from SQL DB |
---|---|
Author | Nigel Weeks |
Post date | 2005-06-24T03:10:24Z |
> Is there a tool available to extract Schema and Data in theA tool to extract the schema is included:
> 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.
>
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.