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.  If you wish to be visited by a ChristianSteven approved technical consultant, please visit our Professional Services.

 

image1448.jpg

 

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. If you are unfamiliar with creating database instances, contact your DBA for assistance.

2.  On the CRD PC, create a 32 bit SYSTEM ODBC DSN. SQL Authentication is recommended. Ensure you select the new database as the "default database".

3.  In CRD, go to the Configuration Tab then select Migrate to ODBC.

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

image1446.jpg

 

CRD will perform a back up first.

 

4.  Select your new DSN from the dropdown list and enter your credentials

 

image1447.jpg

 

 Note: If you do not see the DSN that you previously created within the ODBC Datasource Administrator, then the DSN may not have been created as a 32 bit System DSN. Use the odbcad32.exe (located at C:\Windows\SySWOW64\) to ensure you create a 32 bit DSN.

5.  Click "Go".

 

Your local file system will be migrated to the new database, and CRD 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