Migrating the Database
1. Restore the Database on the New Server
Copy the backup file from the old database server to the new database server. It doesn't need to be in the same folder where your fresh ILLData database is, just somewhere you can find it. Restore the backup file by right clicking and choosing Tasks - Restore - Database. In the options be sure to choose to have it Overwrite the existing database using the file location of the database files created using the installer on the new server.
2. Reassign the ILLiad SQL Login
Because the link to the ILLiad user has now been broken, you need to reassign the ILLiad SQL user back to the migrated database. You can do this by running the following query against the database (where ILLData is the name of your ILLiad Database):
3. Swap the IP Addresses of the Old and New Servers
In order for ILLiad to connect to the new database, you will need to swap the IP addresses of the old and new servers. This will allow the client machines to connect to the database without any additional installation/changes on the client side. If you do not swap the IP addresses but instead want to connect to ILLiad with the new IP address, make sure that any references to the IP address are updated in the dbo.Customization table and in the SQL Alias Manager.