Thanks Mark



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, July 23, 2015 7:40 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4





On Thu, 23 Jul 2015 07:16:18 -0500, "'stwizard' stwizard@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> Thank you Helen for your reply,
>
> I'll do as you suggest and read the release notes (in order) and I may

have

> 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 ask
> each in a separate post?

That is up to you, but I'd start a new thread for a new question.

> For Instance, I do have a few questions currently:
>
> 1) The Character Set of my current database is NONE. Is this OK or

should

> I
> set it to something else? Or it this done automatically during the
> restore?

The restore doesn't change the default character set of a database, NONE
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 a

question.

> Is it possible to do a metadata only backup followed by a restore of the
> 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?

Yes:
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-metadata

Mark





[Non-text portions of this message have been removed]