Subject | Re: Creating database through a script and later updating it |
---|---|
Author | Alexander V.Nevsky |
Post date | 2004-01-30T14:27:06Z |
--- In firebird-support@yahoogroups.com, Venus Software Operations
<venussoftop@m...> wrote:
compact and more quick to create database than script. To create new
instance of the database from this file use gbak again with -c option.
If you made metadata only gbk, after restore new database will be the
same structure as source one but all tables will be empty. Look at IB6
Operations Guide for description.
Since FB have more fast and effective way to create databases, there
is not extract metadata to script function in command-line utility
isql (described in Operations Guide too) which is used to perform SQL
statements and scripts. Though some third-party tools have this
function. I'm not sure if any of this tools have command-line mode.
Best regards,
Alexander.
<venussoftop@m...> wrote:
> gbak created a non-text file and I am not able to open it inDatabase
> Comparer 2.2, this was the command I used:d:\shared\c99\data\vso3.fdb
>
> GBAK -b -m -pas masterkey -user sysdba -v -z
> c:\trashcan\c99.sqlGbak creates not a script but gbk-format file which is much more
compact and more quick to create database than script. To create new
instance of the database from this file use gbak again with -c option.
If you made metadata only gbk, after restore new database will be the
same structure as source one but all tables will be empty. Look at IB6
Operations Guide for description.
> can I generate a script file so I can also automate it's creation onthe
> development machine. I gave this a try using Marathon (Tools |Metadata
> Extract ... | Migrate Database Metadata to a script file) whichcreated
> such a script but I am more interested in command line for such asituation
Since FB have more fast and effective way to create databases, there
is not extract metadata to script function in command-line utility
isql (described in Operations Guide too) which is used to perform SQL
statements and scripts. Though some third-party tools have this
function. I'm not sure if any of this tools have command-line mode.
Best regards,
Alexander.