Support Articles

Create a Test Copy
Last Updated 4 months ago

The easiest way to set up a test database is to make a backup of your current database, and then restore it to a new database. You would then need to connect the user interface to this test database. If you are using ODBC, just create a second ODBC, or use a DSN-less connection. We recommend adding some data flags to ensure that your users know which database they are using (for example, in the test database, a training record called "_TEST DATABASE".

Make a backup of your database

1. Open SQL Management Studio and locate your database in the navigation panel on the left.
2. Right-click on the name of your database, and in the pop-up box, select "Tasks > Backup".
3. In the pop-up window, select the destination and file name.
4. Click "OK".

Restore to a new database

  1. Open SQL Server Management Studio.
  2. Locate the database you want to restore in the tree at the left (or create a new database by right-clicking on "Databases" and selecting "New").
  3. Right-click on the database and select "Tasks > Restore > Database".
  4. Uncheck the "Database" radio button and select "Device".
  5. Click the elipse (…) button. In the pop-up window, select "ADD" to browse to your .bak file. Click "OK"
  6. In the "Destination" section, update the database name to the name of the database you are restoring to (double-check this step as it may revert to the original database name).
  7. Under "Select a Page", choose "Options" and be sure that "Overwrite the existing database/REPLACE" is checked.
  8. Uncheck "Tail-Log Backup" if it is checked.
  9. Click "OK" and the database should restore in under a minute.
  10. If the file fails to restore, click on the error message for the reason and correct the specified setting.
Add your TRAIN TRACK users or active directory group and assign them datareader/datawriter for the new database.

Create the ODBC connection on the new workstation

1. Open the Windows "Control Panel" and select "Administrative Tools > ODBC Data Sources (32 bit)".
2. Select the "USER DSN" tab and click "Add".
3. In the "Create New Data Source" window, select the SQL Native Client (it is usually the one at the bottom). If you don't have the Native Client, select the SQL driver.
4. The “Create a New Data Source to SQL Server” window will open. Enter the following and click "Next".

Description: (optional) Type in a description
Server: select (or type in) your SQL server

5. Select “with integrated windows authentication” or “with windows NT authentication” and click "Next".
6. Check the box that says “Change the default database to:” and select your test database. Click "Next".
7. Click “Finish”.
8. Click “Test Data Source”. You should see a message that the test was successful. Click "OK".

Connect the user interface

  1. Open the user interface and go to "Database Administration > Linked Table Manger".Open the Linked Table Manager, and check the box at the bottom "Always prompt for new location".
  2. Click "Select All".
  3. Click "OK".
  4. In the pop up window select the ‘Machine Data Source’ tab and choose New.
  5. Select SQL Native Client as your driver (from the bottom of the list). Click Finish.
  6. In the “Create New Data Source’ window enter "TTSERV" as the DSN.
  7. In the third box, select the appropriate SQL server from the drop down menu.
  8. Click "Next".
  9. Select ‘With Integrated Windows Authentication,” click Next.
  10. Check “Change the default database to” and select the correct database from the pull-down menu.
  11. Click "Next" on each screen until you can click the "Finish" button.
  12. Click "Test data source".
Tags: Set up a test copy of the database, testing database, test copy, test database.

Please Wait!

Please wait... it will take a second!