Executing database scripts (Microsoft SQL Server)

To create a repository, you must:

•	Run the load_as_sys.sql script to create the database.

•	Run the load.sql script to create the tables etc. for the repository.

Prerequisites

•	The login details for the system administrator user (sa) are available.

•	The ZIP file with the database scripts is generated in Control Center and unpacked using an archiving application, such as WinZip.

Post requisites

•	Always do a sanity check to make sure the repository was created according to your configurations.

•	Since the scripts contain passwords, it is recommended to delete the scripts after you have created the repository.

To execute the scripts

1	Open the appropriate SQL Server tool. For example, Microsoft® SQL Server® Management Studio or SQLCMD.

2	Log in as the system administrator user (sa).

3	Run the load_as_sys.sql script.

4	Run the load.sql script in the database created in step 3 above.