As part of the upgrade from Breeze 4.1 or 5.x to Connect 6, you will be required to upgrade the Microsoft SQL Server 2000 MSDE to Microsoft SQL Server 2005 Express. The migration of the Breeze database from SQL Server 2000 to 2005 is not automatic, so you must follow the instructions below.
This applies only to customers using the MSDE included with the Breeze installation. Customers using a separate Microsoft SQL Server do not need to follow these instructions.
Note: You should allocate 1 hour to accomplish the migration. If you have any questions about any aspect of performing this migration, please contact Adobe Connect Product Support.
Note the full path to your Breeze database files (*.mdf and *.ldf). You will need to know the path to both these files in order to attach your database later. If you are unsure of where your database file resides, you may take the following steps to verify the Breeze database location:
At the Windows command line, type the following:
The osql prompt will open. Type the following, substituting your database name for <db_name>. The default database name is breeze. If you are unsure of your database name, you can find it in the DB_NAME key in the custom.ini.
1> SELECT name, filename FROM sysdatabases WHERE name = '<db_name>' 2> GO
Select the default option:
Install the embedded database engine to the following location: C:\Program Files\Microsoft SQL Server.
Note: If you try to install the embedded database engine to a location other than the default, you will receive the following error message:
The embedded database engine install failed with return code 0; Please examine the log file [Connect Installation Dir]\logs\setup.cab for further information. Adobe Connect install will now proceed without the embedded database engine.
Download the following SQL script AttachBreezeDatabase.zip
Note: We recommend that you use the location C:\connect_db to store your Connect database files (*.mdb and *.ldf) and the migration script. If any of these files reside in a directory other than C:\connect_db, you will need to modify AttachBreezeDatabase.sql to include the full path of the files. This directory will be the permanent location of your database files.
The database migration portion of the upgrade is complete.
Breeze 4.1 customers will need to upload the Connect 6 license.txt to complete the upgrade. Breeze 5.x customers will not be required to upload a license.txt file.