Subject Re: [Firebird-general] Upgrading my app and the db
Author Helen Borrie
Please move this to firebird-support.

^ Helen ^

At 03:53 AM 15/06/2009, you wrote:
>Good Morning!
>
> 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.
>
> But, when I do that, all the new metadata is lost. I end up with the same structure as the original db + the original data.
>
> 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 metadata. I was hoping that I could I could accomplish this with a backup/restore.
>
>Cya...Dan'l
>
>
>
>------------------------------------
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-generalYahoo! Groups Links
>
>
>