KB00057: Migrating MessageMaster from SQL Server to MSDE

Description

You have been running MessageMaster Server on SQL Server. You want to downsize to run MessageMaster on MSDE, and you would like to know the best way to migrate your database from one database engine to the other.

Resolution

This procedure will preserve your existing database and nothing will be lost.

1. Back up the ObjSoft database using SQL Enterprise Manager. You only have to back up the database, not the log files.
2. Uninstall SQL Server
3. Install MSDE. Make sure you have the latest version from Microsoft. You won't have a console, so you will need to reinstall the SQL Enterprise Manager console from your SQL Server CD. Then you will need to install Service Pack 3 again.
4. Restore the ObjSoft database into MSDE.
5. Remove the old ObjSoft database user from the restored ObjSoft database.
   
6. Under Security / Logins, create a new Login.
   
7. Name the Login the same as you had named it previously. In our example it's "ObjSoft". Make sure you choose SQL Server authentication and provide the password, and make sure you set the database to ObjSoft.
   
8. On the Database Access tab, make sure you check off the ObjSoft database and check off db_owner as the role. Click OK.
   
9. Download and upgrade to the latest version of MessageMaster.

Applies To

• MessageMaster Server