To create a Microsoft SQL Server database for OPN Systemô XT Server

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.
Nội dung trích xuất từ tài liệu:
To create a Microsoft SQL Server database for OPN Systemô XT ServerHow to create a Microsoft SQL Server database for OPN System™ XTServer?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 http://www.aquafold.com/downloads.html (the Windows version).Step 2: Modify the opn_mssql.sql 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 | www.antepo.comHow to create a Microsoft SQL Server database for the OPN System™ XT Server? 2. Open the opn_mssql.sql file in a text editor. 3. In the text editor, click Edit > Replace to change the $DATABASE_NAME$ to the designated database name, e.g. opnMSSQL: 4. Save the file.2 How to create a Microsoft SQL Server database for the OPN System™ XT Server?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. 3How to create a Microsoft SQL Server database for the OPN System™ XT Server? The Query Analyzer window is displayed.4 How to create a Microsoft SQL Server database for the OPN System™ XT Server?3. Click the Open Script button, or press CRTL-O.4. Navigate to :/Program Files/antepo/opnserverXT/data/download. The list of sql scripts is displayed.5. Select the opn_mssql.sql file and click Open. The sql file is displayed in the Query Analyzer window. 5How to create a Microsoft SQL Server database for the OPN System™ XT Server? 6. To run the opn_mssql.sql script, click the Execute button, or press CRTL-E. 7. This creates the OPN database on the Microsoft SQL Server.Step 4: Configure the Microsoft SQL Server database on the OPN System Server 1. Start the OPN Server Console. 2. Start the Web Configuration Interface and log onto the system. 3. Navigate to Database > Connection and add a new database handler for Microsoft SQL Server. Click Save to add the database handler to the configuration. 4. Navigate to Database > Selection and select the newly created Microsoft SQL Server database for all database selections.6 How to create a Microsoft SQL Server database for the OPN System™ XT Server?Appendix – Instructions for MySQL and Oracle databases The procedures to create a MySQL and Oracle databases are similar to the steps for creating a Microsoft SQL Server. The only differences are as follows: 1. a different sql file for each database 2. required login information when connecting to the database sql scripts Each of the database types has a sql file that you need to: 1. Modify to point to the right database. 2. Run to create the database and the tables needed for the OPN System™ XT Server. Database sql file Microsoft SQL Server opn_mssql.sql My S ...