How to migrate the database to SQL 2008

Solution - General Instructions

1. Back up in as many ways as possible:
   • Symphony backup
   • Direct database backup
2. Follow Microsoft instructions for migrating databases from SQL 2005 to SQL 2008.
3. Ensure that you have TCP/IP, Shared Memory, and Named Pipes protocols enabled in your SQL Server 2008 instance (run SQL Configuration Manager).
4. Verify that you can establish a connection from a remote server over TCP/IP to your new database with a 3rd party tool.
5. Run dbconfiguration.exe on all servers in your farm to adjust the connection string for each server to be the new SQL 2008 location.
6. Restart all services on all servers in your farm using the killall r command. You may need to reboot the servers as well.
7. Ensure that your services are running properly (can connect to the database).
   Printshmem (command line utility on Symphony Server) will fail without database connectivity.

Specific Instructions

Task 1: Backup the Database

1. Open a command prompt on the database server.
2. Type: osql -S localhost\Aimetis -U sa
3. Press Enter.
4. Type in 1> BACKUP DATABASE Aira TO DISK = ‘C:\temp\<MyBackup>.bak’ //please define an existing path
5. Press Enter.
6. Type in 2> Go
7. Press Enter.
8. After it finishes, type quit and press Enter.

 Task 2: Import New Database

You can use the existing server and uninstall SQL and install the new version of SQL or move to another database which opens two options:

1. User same DNS and IP as previous SQL Server or use new information and replace all paths through the Symphony Setup Wizard or through the dbconfiguration tool
2. On the new server install SQL and Management Studio.
3. After installation is complete, and the SQL Connection manager steps are finished, restore <MyBackup>.bak into the SQL server.
4. You might have to restart InfoServices.

Note: Moving from SQL 2005 Express to SQL 2008 Express does not upgrade the database itself, it still runs SQL V9. This is NOT related to Symphony.

See Also:

• Using the killall command