IS2000: Moving SQL Databases Between Computers

  1. Please refer to the article below for moving Microsoft SQL databases between computers.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/copy-databases-to-other-servers

  1. Once you move your database over from another machine, follow the steps below to configure your database in IS2000:

a. Run the ‘Configuration’ application as ‘admin,’ which is typically located at “C:\Program Files (x86)\IS2000” . (See Figure 1)

Figure 1

b. Under Path and Database, go to the Database field and select the Database type as SQL Server (i.e. “1 – SQL Server”). Select the “Click Here” button next to “SQL Database Connection” to access the Database Configuration window. (See Figure 2)

Figure 2

c. In the “Database Configuration” pop up window, enter your “SQL Server Name” and “Database Name” under the “Connection” tab and select the authentication mode. (See Figure 3)

Figure 3

d. Under the “SQL User” tab, enter the SQL User Name and Password. Click on the “Save Connection” button to save the configuration.

e. Run IS2000.

NOTE: For further assistance, please contact IMRON Support ().