Create database and tables

Top  Previous  Next
1.Create a database to house the crash data for this configuration.  Identify a login account that has read-only access to this data.  If data entry will be performed, also identify an account with read-write access to this database. Important: The account with read-write access should not have DDL permissions.
 

At Pd' Programming: Use the tool at inhouse.pdmagic.com/db/ to create a database in "Configs". In addition to creating the DB in the appropriate place based on its use, it will also create appropriate logins and permissions.

 

2.Locate the Connection / Reader created earlier, click the "Test" button. Once that works, do the same for the Writer if there is one.
3.Execute the CREATE crash tables script from the Execute tab.
Note: When executing an SQL script, the connection logins are not used, just the connection string.  This is because SQL scripts can easily delete or restructure data.  As a result, a login that has DDL permissions is required to execute the script.  Select the "Reader" connection and enter a login and password with DDL permissions.
4.Execute the CREATE lookup tables script