Note:If you find the Microsoft SQL Desktop Engine too limiting, you will need to use the Microsoft SQL Server. CMS recommends that you install the SQL Server onto the same machine, right on top of the existing MSDE as another SQL Server instance.
Note:
|
If you think you need or want to migrate onto an existing SQL Server that is another machine, please contact CMS Support. |
Once you have the Microsoft SQL Server installed, you will need to migrate the Praetor databases to that server. Follow these steps to perform the migration.
|
1. |
Use the Praetor administration tool, temporarily deactivate Praetor. Alternatively you may simply stop the IIS SMTP Server via IIS Manager.
|
|
2. |
Detach the Praetor databases from MSDE by using the SQL script file found in the main Praetor folder called Detach.SQL. Invoke via a command prompt as follows: OSQL -E -i Detach.SQL
|
|
3. |
Using the SQL Enterprise Manager re-attach the two Praetor databases as shown below.
The selection window will then appear allowing you to locate and specify the Praetor database file.
Press
Press
Press
|
|
4. |
Repeat step 3 but select the PraetorClassify_Data.MDF file.
|
and navigate your path to the Praetor G2 folder
and select the PraetorLog_Data.MDF file.
and then in the field for 
