Navigation:  Installation > Configure Datasources >

Running SQL Create Scripts

Previous pageReturn to chapter overviewNext page

 

Once you have your database created you can run the Create Scripts. The create scripts are found in the dbimport Folder.

Create DataDSN

Find the script <application root>\dbImport\Create_datadsn.sql and open it in Query Analyzer. make sure that the main database is selected in the drop down list at the top.

Once the main database is selected click on the "go" button or hit F5. The window below should say "command completed successfully".

 

For Data Import Users

Create Staging DSN

Find the script titled <application root>\install\Create_stagingDSN.sql and open it in Query Analyzer. Make sure that the staging database is  selected in the drop down list at the top. Click the "go" button or hit F5 to create the database.

Once the staging Database is selected hit the "go" button or hit F5 to run the script. The window below should say "command complete successfully".