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. | 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. For instruction how to export data such as the Contact List from the embedded database to a new database, see the How to export Contact list from McKoi database to Microsoft SQL Server? document. Step 1: Download a shareware database management tool You need a database management tool to create Microsoft SQL Server database and to export/import the Contact List. You can download the Aqua Data Studio tool from the following link (the Windows version). Step 2: Modify the The sql script needed to create the database and the tables required by the OPN System™ XT Server are provided with the OPN System installation. 1. On your desktop, navigate to :/Program Files/antepo/opnserverXT/data/download Antepo, Inc. | 185 Varick Street, 5th Floor | New York, NY | 10014 | (212) 741-6653 | How to create a Microsoft SQL Server database for the OPN System™ XT Server? 2. Open the file in a text editor. 3. In the text editor, click Edit > Replace to change the $DATABASE_NAME$ to the designated database name, . opnMSSQL: 4. Save the file. 2 How
