Subject | Re: [firebird-support] Re: Creating database through a script and later updating it |
---|---|
Author | Venus Software Operations |
Post date | 2004-01-30T15:10:07Z |
Hi Alexander
At 07:57 pm 30/01/2004, you wrote:
and the script extract tool generated script when fed to DBComparer (not
from sqlly) tool was not able to sync the target database but the script
generated by Marathon was able to successfully sync the target database.
Thanks for your response. Let me know if you get newer links/ideas.
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]
At 07:57 pm 30/01/2004, you wrote:
> Gbak creates not a script but gbk-format file which is much moreThanks for the info.
>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, thereI have tried command line tools from www.sqlly.com but they had limitations
>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.
and the script extract tool generated script when fed to DBComparer (not
from sqlly) tool was not able to sync the target database but the script
generated by Marathon was able to successfully sync the target database.
Thanks for your response. Let me know if you get newer links/ideas.
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]