SQL Server Upgrade and Transfer of Database

Description

This document explains a migration plan to upgrade SQL and move the database.

Detail Steps

Upgrading SQL and moving databases.

Backup system.

Install SQL as per our knowledge base instructions including allowing TCP/IP connections, remote connections and starting the browser service.
Ask all users to logout of the ICXE
Backup ICXE Database.
Rename old database to identify it is no longer is use.
Restore Database to New SQL Instance keeping the exact same database name.

The following 3 steps are completed in a file on the machines the software is installed on. C:\Program Files\Datapel Systems\Inventory Controller\System.xml or C:\Program Files (x86)\Datapel Systems\Inventory Controller\System.xml

Update "<Connectivity.ODBCDriver>SQL Server Native Client 10.0</Connectivity.ODBCDriver> – SQL Server Native Client 11.0(For SQL Server 2012) or SQL Server Native Client 10.0(For SQL Server 2008 and 2008R2) No String required for 2005 editions).
Update <Connectivity.ServerIP>.\SQLEXPRESS2008</Connectivity.ServerIP> = New SQL Server Name and instance if applicable.
Update other applicable strings as required "<Connectivity.InstanceName>DPL-WMSSQL</Connectivity.InstanceName>
<Connectivity.ServerUsername>sa</Connectivity.ServerUsername>
<Connectivity.ServerPassword>datapelwms</Connectivity.ServerPassword>"
From the restored database remove the SQL user as per registry entry “normally setup as datapel (must match as per file above.)”
Create SQL User as per the Fields “<Connectivity.ServerUsername>sa</Connectivity.ServerUsername>
<Connectivity.ServerPassword>datapelwms</Connectivity.ServerPassword>".
Map the user to the restored database ticking all permissions except the deny permissions.
Delete, Add and Map any other Windows Users that are required to have access to the software.
Test Software runs as administrator and as restricted users.
Contact Datapel support if any issues.

Related Information

None