Subject | Bug? My Mistake? gbak metadata generators go haywire |
---|---|
Author | Namit Nathwani |
Post date | 2004-11-02T13:27:28Z |
Hi all
I have tried to attach 2 screen shots of the database generators before and
after gbak, hope they are visible on the list.
I have this situation wherein I had an original database with generator
values as they should be. I gbak'ed this database's metadata and restored
the same as per batch file below.
Supposing the original value of a generator GEN_AACCOUNTS_IID is 12. After
gbak it turned up as 1153008335963779696, in fact all of the generators,
irrespective of the original value is set to this.
Please advise what I did wrong.
My batch file text:
@ECHO OFF
IF "%1"=="" GOTO :PROJNAME
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -meta_data -user
sysdba -password masterkey C:\VSO3\Projects\%1\Data\VSO3.FDB
C:\TRASHCAN\META.FDB
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -create_database
-user sysdba -password masterkey C:\TRASHCAN\META.FDB
D:\VSO3\Projects\%1\Data\Original\VSO3.FDB
DEL C:\TRASHCAN\META.FDB
GOTO :END
:PROJNAME
ECHO:
ECHO:
ECHO Please provide the Project Code
ECHO:
ECHO:
:END
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
[Non-text portions of this message have been removed]
I have tried to attach 2 screen shots of the database generators before and
after gbak, hope they are visible on the list.
I have this situation wherein I had an original database with generator
values as they should be. I gbak'ed this database's metadata and restored
the same as per batch file below.
Supposing the original value of a generator GEN_AACCOUNTS_IID is 12. After
gbak it turned up as 1153008335963779696, in fact all of the generators,
irrespective of the original value is set to this.
Please advise what I did wrong.
My batch file text:
@ECHO OFF
IF "%1"=="" GOTO :PROJNAME
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -meta_data -user
sysdba -password masterkey C:\VSO3\Projects\%1\Data\VSO3.FDB
C:\TRASHCAN\META.FDB
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -create_database
-user sysdba -password masterkey C:\TRASHCAN\META.FDB
D:\VSO3\Projects\%1\Data\Original\VSO3.FDB
DEL C:\TRASHCAN\META.FDB
GOTO :END
:PROJNAME
ECHO:
ECHO:
ECHO Please provide the Project Code
ECHO:
ECHO:
:END
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
[Non-text portions of this message have been removed]