08-02-2010, 10:02 AM
Join Date: Jun 2009
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | BB Professional v4.1 - MSDE to SQL 2005 (In-place upgrade)
Please Login to Remove!
We have BB Professional v18.104.22.168 installed on a Windows 2003 Server R2 member server. The BESMgmt database uses MSDE. We are about to upgrade this server to MS SQL Server 2005 for an application that also runs on this box. It will be an in-place upgrade of SQL. Which process should I follow to transition the BB BESMgmt database across to SQL 2005 from MSDE?
I've read KB03112 but this seems to be for moving a database to a different physical box. Or should I treat this as if this is a new installation, i.e.:
- Backup the BESMgmt database to disc
- Perform the upgrade from MSDE to SQL 2005
- Use createdb.exe to update the existing BESMgmt schema to that of the installed SQL version (SQL 2005) (by the way does createdb know which version of SQL it is dealing with and update the schema appropriately or do I need to do something else here?)
- Restore the database using the SQL Management Studio (I presume as it restores it uses the new schema it is being restored to?)
Any help gratefully accepted. Or slaps to the face for being a rookie...
Novice BB Manager