Salesware Installation Guide : Installation overview : Other installation scenarios : Migrating SiriusSQL from SQL Server 2005 to SQL Server 2008/2012
 
Migrating SiriusSQL from SQL Server 2005 to SQL Server 2008/2012
 
1. Ensure that no one is connected to the database (use the instructions in maintenance section of the Salesware Modules, Licensing and Maintenance document to do this).
2. Important! Back up your SiriusSQL database to media separate from where it currently resides.
3. Detach the SiriusSQL database using the instructions in Manually attaching the SiriusSQL database (there is a note that describes how to detach).
4. Uninstall SQL Server 2005.
5. Install SQL Server 2008/2012 using the instructions in Installing SQL Server 2008/2012.
6. Re-attach the SQL Server database using the instructions in Manually attaching the SiriusSQL database.
 
Note: It is possible your current ODBC connections to the database may not connect to the new installation, but the worst case scenarios is they you have to reselect the server in the ODBC connections.