Desktop Central extends support for using MS SQL database for storing the configuration and data. This document will explain the steps to configure Desktop Central and MS SQL Server to use MS SQL as the back end database. The following steps can be followed to set up a fresh MS SQL database or migrate data from an existing database to new MS SQL database. For both of these cases, you should first upgrade to Desktop Central build 10 or above versions before following any of these steps.
This document is applicable for the following Migration process,
The following steps will explain you, to backup the data from the old server, change the database server and restore the data in the MS SQL database.
Perform the steps below from the computer where MS SQL Server is installed,
Note: Ensure that the you configure Windows firewall to allow access to SQL server. Refer this document for more information.
From the computer where Desktop Central Server is installed, perform the steps below:
Fig: Windows Authentication
Fig: SQL Server Authentication
Ensure that the collation for the Desktop Central folder in MSSQL database is set as SQL_Latin1_General_CP1_CI_AS if it is not set, follow the steps mentioned below to change the collation.
5. Start Desktop Central.
You can start using Desktop Central which has been migrated from the previous location.