Navigation: Installation > Configure Datasources > Data Import Users |
![]() ![]() ![]() |
If you have an existing CHRID Access Database that you want to import you will need to install a total of 3 datasources. After you finish your import, if you have no further need for it, you may delete the "staging" database and the access database.
If you plan on Using the Data Import
Step 1 - Add 2 databases to your SQL server and create a username with dbo access to both of them.
• | Main Database - This is the database where you intend for your live data to be stored. |
• | Staging Database - This is the database that will house the Access File based data to be manipulated. This is a necessary step because the schema has changed quite dramatically. |
Step 2 - Add 3 Datasources to the Coldfusion Administrator.
1. | DataDSN (MS SQL)- This datasource should be directed to the main database (from step 1). |
2. | StagingDSN (MS SQL) - This datasource should be directed to the staging database (from step 1). |
3. | ProxyDb (Access) - This database should be directed at a blank Access file on the disk. The system uses this DSN to make a special file based connection to the uploaded CHRID Access db. See this blog entry for more info about pseudo connectionless Access. |
Step 3 - Run the Create Scripts for each MS SQL database.