PLEASE TAKE CARE TO FOLLOW THE INSTRUCTIONS BELOW PRECISELY
Ensure that the target server for the migration has SQL Management Studio installed
- Check the SQL Server tool by following this documentation
- Always login to SQL Management Studio with enough rights to be able to backup and restore the ProVConnect Server Database
- Before doing the backup of the database, the database should not be in use, so we recommend to shut down the current ProVConnect Server during this process.
Launch Microsoft SQL Server Management Studio with the Administrator account
Go to the database that you need to migrate
Right click on the database and choose Backup
From this menu, choose the target database
Specify if needed the full path of the backup file
Click on the Media Options menu on the top left
check the highlighted checkbox (Verify backup when finished)
Click on the Backup Options menu on the top left
You can try to choose the Compress Backup options
Press OK to start the backup process
If the Compress backup fails, just use the default mode. You will still be able to compress the update file later with a archive tools.
Once your backup file is ready, please send it to the new server
Unzip the backup file if necessary on the new server
After being connected to the new server, Choose the Restore Database options
From this menu, Choose the Device options and search for your database file
Once done, click on OK in order to import the database
Once the Restoration is over, click on the new database.
You might need to press F5 on the database tree is order to refresh the view
Go to Security/Users
Delete the wpweb user from this database
Once done go to the Security/Logins folder and search for the wpweb user
Click on the properties button
Please note that this user WPWEB is created by default to manage the database communication with the proVConnect Server. This user is not mandatory if you manage this communcation in your own way
On the User Mapping option, please Map this login to the imported database
Choose dbo as the Default Schema and check the role db_owner
To check the database connection, please open this file located in your proVConnect Server (the path is slightly different according to your server installation) : "C:\inetpub\wwwroot\provconnectMS\bin\hibernate.cfg.xml"
In the connection string, make sure that the Catalog entry has the name of the new database
Then save the configuration file
That's it, the database is imported.
You can delete the backup file created during the process.
You can also delete the empty database that was created during the installation of the new ProVConnect Server with SQL Management Studio.