Thanks Mark
From: [email protected] [mailto:[email protected]] Sent: Thursday, July 23, 2015 7:40 AM To: [email protected] 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' [email protected] [firebird-support]" <[email protected]> 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]
