Subject | Re: To extract Schema and Data from SQL DB |
---|---|
Author | Adam |
Post date | 2005-06-24T03:11:32Z |
Hello Kumar,
There are many third party tools that can do it. IBExpert is one, but
the free version doesn't have it from memory. If you only want to
create a "blank" version of your database, the easiest way would be to
do a meta-data backup and restore using gbak.
gbak -B localhost:MyDB c:\temp\emptydb.fbk -m -user sysdba -password
masterke
gbak -R c:\temp\emptydb.fbk c:\temp\emptydb.fdb -user sysdba -password
masterke
(Obviously subsitute your actual connection string, path, username and
password)
Hope that helps
Adam
There are many third party tools that can do it. IBExpert is one, but
the free version doesn't have it from memory. If you only want to
create a "blank" version of your database, the easiest way would be to
do a meta-data backup and restore using gbak.
gbak -B localhost:MyDB c:\temp\emptydb.fbk -m -user sysdba -password
masterke
gbak -R c:\temp\emptydb.fbk c:\temp\emptydb.fdb -user sysdba -password
masterke
(Obviously subsitute your actual connection string, path, username and
password)
Hope that helps
Adam