Subject | RE: [firebird-support] Upgrading my app and the db |
---|---|
Author | Alan McDonald |
Post date | 2009-06-15T22:36:25Z |
> Good Morning!this isn't clear (enough).
>
> I am using FB 2.1.0.17798 and Delphi 6.
>
> I have a released version of my app that is in use. While upgrading the
> app, I have found it necessary to modify some stored procs and to add
> tables & SPs.
>
> The first time the upgraded app is run, I thought it would be a good
> idea to backup the existing db, rename the existing, rename the
> upgraded db then do a restore to the renamed/upgraded db. I used the
> Jedi UIB Backup & Restore components.
>then you are obviously doing something wrong. Are you committing the DDL
> But, when I do that, all the new meta data is lost. I end up with the
> same structure as the original db + the original data.
changes?
Alan
>
> I can run create or alter statements. Indeed, I had already started
> down that path. But there quite a few changes from the released
> metadata to the upgraded db's meta data. I was hoping that I could I
> could accomplish this with a backup/restore.
>
> Thanks...Dan'l
>