Creating a Microsoft SQL Server Database

Edit online

About this task

When using Microsoft SQL Server, create the database data and log devices and then create the Trading Manager database using these devices. The name of the database you just created cannot contain spaces or special characters. Minimum disk space for the database data device is 100 MB and a recommended size is 500 MB. Minimum disk space for the database log device is 20 MB and a recommended size is 100 MB.

If any part of this procedure needs to be repeated, use sqldropnn.sql to delete all Partner Manager tables and data in the database.

Use caution: sqldropnn.sql cannot be reversed and should be used only if these steps must be repeated.

To run Microsoft SQL Server scripts:

Procedure

  1. Start your SQL Query tool and connect to the Trading Manager database you just created.
  2. See the Trading Manager release notes for the scripts to run.

What to do next

Note: These scripts do not contain a COMMIT statement. You must manually issue a commit if your database environment is not set to auto-commit.