Transferring eCertrack SQL Trial Data to another SQL Server

This guide is to help you backup your eCertrack trail data from the local Sql to a networked SQL installation.

​

• Backing up eCertrack Trial Data

Go to folder c:\eCertrack located on user station with trial installation

Make a new folder called c:\eCertrack\backup

Open a CMD prompt (as administrator)

Change to the c:\eCertrack folder

Type: CD \eCertrack​

Run the backup command​ (exactly as typed below)

Type: BackupSQL (localdb)\SqlExpressLocal c:\eCertrack\backup​

Copy the new file created located in c:\eCertrack\backup to a local hard drive where your networked SQL is installed (Not a networked folder) ​

​

• Restoring eCertrack Trial Data on New Sql Server

On networked computer running the new SQL Server, run the SQL Server Management Studio ("SSMS")

Create an New DB called "eCertrack" (if it does not already exist)

Right click the eCertrack database and select Tasks --> Restore --> Database

Click "Device" as the Source

Click the Ellipse (at right)

Click the "Add" button

Locate the backup file created above

After selecting, click "Ok"

Click "Verify Backup Media" to verify backup file integrity

Select "Options" page from left panel

Select "Overwrite Existing Database"

Select "Close Existing Connections"

Click "Ok" to begin restore

​

• Configure Restored SQL DB

From the SSMS locate the eCertrack database

Expand the database level tree

Scroll down tree and expand Security --> Users

Locate user "eCertrack_Scheduler" and delete

Compress database level tree again

Scroll down to the server level Security --> Users and expand tree

Locate user "eCertrack_Scheduler" and double click to open

Enter a new password and confirm password (remember for later)

You will need to enter this password in the eCertrack Setup Wizard​

Select "User Mappings" page

Locate eCertrack and check the check box next to it

With eCertrack still selected, go down to "Database Role Membership" panel

Check the box next to "db_owner", leave all others as is

Click ok to save changes

​

Your trial data is now available for your production setup of eCertrack.