How to configure Desktop Central to make it use MS SQL Server as the database?
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,
- Migration of Desktop Central from MYSQL to MSSQL database.
- Migration of Desktop Central from PGSQL to MSSQL database.
- Migration of Desktop Central from one MSSQL server to another.
- Desktop Central Supports MS SQL 2005 or later versions.
- If you are using "Failover Server" contact our support team for migration assistance.
Change the Database Server to MS SQL
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.
- Click here and know the steps to configure SQL server (Proceed with step 2 if the SQL server is already configured).
- Migrating the database to SQL server
From the computer where Desktop Central Server is installed, perform the steps below:
- Stop Desktop Central Server
- Open command prompt as Administrator
- Execute the script changeDBServer.bat available under <Desktop Central Home>/bin directory. This invokes the Database Setup wizard.
- Select Database Type as SQL Server
- Specify the Host Name where SQL Server is installed
- From the list of available instances, select the instance on which you wish to run the database.
- You can choose to authenticate the database connection either using Windows Authentication or SQL Server Authentication. Choose the required authentication and provide the credentials.
- Click the checkbox to enable NTLM authentication.
- Click the check box to "Migrate Data from Existing Database". So that the existing data will be migrated to the MSSQl server.
Note: This is applicable only if you wanted to migrate your existing database to MS SQL. If you are trying to create a fresh set up, then you can ignore this step.
- Click Save to save and complete the SQL Server Configuration. It may be noted that it will take a few minutes to configure the settings on the SQL Server.
Fig: Windows Authentication
Fig: SQL Server Authentication
- One of the best practise recommended is to, Click Test to check whether a connection could be established with the given credential.
- If you get any Error messages such as "Authentication Error", check to verify the correctness of specified credentials.(Do not take a back up of the database again)
- This might take several minutes, the size of your database determines the time taken.
You can start using Desktop Central which has been migrated from the previous location.