Subject | RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4 |
---|---|
Author | Mark Rotteveel |
Post date | 2015-07-23T12:40:07Z |
On Thu, 23 Jul 2015 07:16:18 -0500, "'stwizard' stwizard@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
set upgrade) is probably the least of your worries. Make sure you test your
applications intensively before doing a production upgrade.
is a valid default and switching that to something else can have
implications that only you and your application developers can check.
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-metadata
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Thank you Helen for your reply,have
>
> I'll do as you suggest and read the release notes (in order) and I may
> question after reading them.Just know that upgrading the database (apart from the metadata character
set upgrade) is probably the least of your worries. Make sure you test your
applications intensively before doing a production upgrade.
> Should I continue to ask all my questions in this thread or should I askThat is up to you, but I'd start a new thread for a new question.
> each in a separate post?
> For Instance, I do have a few questions currently:should
>
> 1) The Character Set of my current database is NONE. Is this OK or
> IThe restore doesn't change the default character set of a database, NONE
> set it to something else? Or it this done automatically during the
> restore?
is a valid default and switching that to something else can have
implications that only you and your application developers can check.
> 2) The database I want to upgrade is 25,231,544 KB, so I have aquestion.
> Is it possible to do a metadata only backup followed by a restore of theYes:
> metadata only in 2.5.4 to see if there are any issues with Stored
> procedure,
> Triggers, constraints, keywords, etc before attempting the full backup
> and
> restore?
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-metadata
Mark