TECH SUPPORT

Migrate to SQL Server / ODBC

Follow

Important:

ChristianSteven Software does not provide support or instructions on how to use SQL or other databases.  If you do not have any experience with databases, please contact your database administrator and arrange for the migration to be performed by an expert.  

 

Where more than 500 schedules are expected and/or the database is being accessed by your own application (e.g. a web application), we strongly recommend that you Migrate your database to SQL server or another more reliable ODBC compliant database.

 

Storing your data in an enterprise database (and not in MS Access) affords you a great deal of extended functionality through triggers, stored procedures, integration with other applications, system backups, indexing, tuning, and lots more.

 

To Migrate to SQL Server (or some other ODBC compliant database):

 

1.  Create a new empty database instance in your ODBC Compliant Database.

2.  On the SQL-RD PC, create a SYSTEM ODBC DSN. Windows integrated authentication is preferred, but standard authentication is acceptable.  Ensure you select the new database as the "default database".

3.  In SQL-RD, go to the Configuration Tab then select Migrate to ODBC.

 

image1448.jpg

 

Your local file system will be migrated to the new database, and SQL-RD will use this new database as its default database.

 

image1446.jpg

 

SQL-RD will perform a back up first.

 

4.  Select your new DSN from the dropdown list and enter your credentials (if you are not using Windows Authentication)

 

image1447.jpg

 

 

5.  Click "Go".

 

Your local file system will be migrated to the new database, and SQL-RD will use this new database as its default database.

  

To revert to the local system file:

Go to Tools - System Tools and select "Migrate to File System".

 

"Migration" will migrate all the data from one database type  and move it to another.  If you simply want to switch from one to the other without migrating the latest data, use the "Switch" option instead of the "Migrate" option.

 

 

Comments