This tutorial assumes that you have installed Connectivity Kit on the machine that holds the database server.
This tutorial will guide you through the steps required to create a new database using Microsoft SQL Server.
1. In Windows explorer, go to the following directory:
C:\Program Files\Applied Tech Systems\Inspect\Connectivity Kit\Build
2. Edit InspectBuild.cmd. You may need to run the editor as Administrator in order to be able to save the changes.
In the file you will see many lines similar to the following one:
sqlcmd -S localhost -U sa -P password -d Inspect -iCreateRoles.sql -o logs\CreateRoles.out
The following information must be modified in every line that contains it:
o -u <administrative user name>
o -p <password>
o -d <database name>
3. Change the administrative user name to your sql server administrative user name.
4. Change the password to your sql server administrative password.
5. Change the database name to InspectTutorial.
6. Save and close the file.
7. Edit CreateDatabase.sql.
8. Modify the database creation line as follows:
create database InspectTutorial
9. Also modify the database alteration line:
alter database InspectTutorial...
10. Save and close the file.
11. Open a command prompt.
If you are using Windows Vista or 7 you must start the command prompt with administrative rights.
12. Go to the \build directory.
13. Run InspectBuild.cmd.
A message will appear at the end to show that it built successfully.
14. In Windows Explorer go to the Logs directory within the Build directory.
15. Check that there are no *.err files.
16. Open DatabaseVerify.out.
17. Ensure that the counts listed inside all match (each count should be duplicated). If they don't, review the *.out files and execute the appropriate steps to resolve the issues.
18. If required, update the database schema to the latest version.