Subject Re: [firebird-support] Re: Creating database through a script and later updating it
Author Venus Software Operations
Hi Alexander

Sorry for replying late, but it seems I missed a few mails.

Thanks for responding.

At 11:17 pm 28/01/2004, you wrote:

> Make backup and send it to this person together with BAT file
>containing proper gbak call to restore. If you don't want to send
>data, make metadata-only backup.

gbak created a non-text file and I am not able to open it in Database
Comparer 2.2, this was the command I used:

GBAK -b -m -pas masterkey -user sysdba -v -z d:\shared\c99\data\vso3.fdb
c:\trashcan\c99.sql

can I generate a script file so I can also automate it's creation on the
development machine. I gave this a try using Marathon (Tools | Metadata
Extract ... | Migrate Database Metadata to a script file) which created
such a script but I am more interested in command line for such a situation


>Or you are interested how to build
>this script if you don't remember what changes you did?

Yes

>If so, always
>have structure of client's database at hand and look at
><http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp>http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp

Yes thanks. Actually I wanted to do it the other way round. I have the
latest structure and application on the development machine.

Now this junior takes this complete database details (CDBD) (without data)
script to the clients machine, does a command line / batch file on the
clients machine and the specified clients database is now updated in
reference to the CDBD script. Again, is there a command line alternative
to dbcomparer?




Regards
Bhavbhuti Nathwani
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
venussoftop@...
venussoftop@...
venussoftop@...
venussoftop@...
vso_ad1@...
___________________________________________


Please note: We reserve complete rights for policy changes in the future
and the same will be applicable immediately as and when made. Attachments
may get corrupted before reaching you, in such a situation please let us
know and we will resend you the same at the earliest. We do not take any
responsibility for data loss of any type and kind. Data safety remains the
sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or
confidential. If you are not the addressee nor are you responsible for the
delivery of the message to the addressee indicated in this email, then you
may not copy or deliver this email to anyone and you should notify the
sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject,
if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by my company.


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.573 / Virus Database: 363 - Release Date: 28/01/2004


[Non-text portions of this message have been removed]