How to move a SQL database to a new server

Applies to:

SQL Server Any version - Microsoft SQL Server Management Studio express required

Description:

How to backup and restore Blue's SQL database to a new SQL server, even of different versions, provided the target SQL server is the same or higher version.

Solution:

Please, make sure the destination SQL server is the same or higher version of the source SQL server.

Download and install Microsoft SQL Server Management Studio Express
Make sure your SQL is already installed on the destination machine and that you have username and password for the both source and destination SQL servers
Login through Remote desktop to Imagicle Application Server and stop all Imagicle Services running <IAS_Installation_Folder>*\Temp\SV-StopAllService.bat as administrator
Run SQL server Management Studio and connect to the source SQL where your current database is stored
Open database folder and right click on <IAS_DB_Name>** => activity => Backup...
From the new tab, click add and set a destination path for the backup, specifying the file name. click ok
Click OK to start the backup
Right click database folder and select restore database
Select 'source resource' and click '...'. Select the previously created backup file
Click OK to import the database
After the restore, close the application and Click Billy Blue's Configuration (start > program > Imagicle Application Suite >Configure Billy Blue's or, starting from Spring '18 you can use start > program > Imagicle Application Suite > Imagicle AS Database Configuration)
Modify the connection settings with the new ones
Click next and wait until operation ends
Click next until the end

When procedure is completed restart Imagicle Application Server, after the restart the applications will start to use the database in the new location

<IAS_Installation_Folder> by default is C:\Program Files (x86)\StonevoiceAS\

**<IAS_DB_Name> by default is 'BluesPro' and for new installations, starting from Spring '18 is 'IAS'