Subject | Upgrading my app and the db |
---|---|
Author | GreatDayDan |
Post date | 2009-06-15T22:23:18Z |
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. I used the Jedi UIB Backup & Restore components.
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.
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
____________________________________
Every day with Jesus is a Great! day
and He loves YOU!
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.
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.
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
____________________________________
Every day with Jesus is a Great! day
and He loves YOU!