Antepo, Inc. | 185 Varick Street, 5
th
Floor | New York, NY | 10014 | (212) 741-6653 | www.antepo.com

How to create a Microsoft SQL Server database for OPN System™ XT
Server?
Introduction
The OPN System supports McKoi, Microsoft SQL Server, MySQL and Oracle databases. You
select the database during the installation the OPN System™ XT Server: either the embedded
database (McKoi), or an external database. If you chose the embedded database, you can change
to a different one by creating a new database and configuring it to be used with the OPN System™
XT Server.
This document describes the steps to create a new Microsoft SQL Server database to be used with
the OPN System™ XT Server. Here are the steps to create a new database:
1. Download database management tool (if you don’t have one).
2. Modify the sql script to point to the designated database.
3. Run the sql script on your database server.
4. Configure the database on the OPN System™ XT Server.
3
Step 3: Run the opn_mssql.sql on Microsoft SQL Server
1. Start Aqua Data Studio, and connect to the Microsoft SQL Server.

Enter your Register Server information and click OK.
2. Right-click the Microsoft SQL Server icon and select Query Analyzer.
How to create a Microsoft SQL Server database for the OPN System™ XT Server? 4

The Query Analyzer window is displayed.

How to create a Microsoft SQL Server database for the OPN System™ XT Server?
5
3. Click the Open Script button, or press CRTL-O.