Creating the Database Tables

The final step in initializing the database is to create the database tables. These tables are created by executing the createtables command that is included with your SIMULIA Execution Engine installation.

Be sure to execute the command in the following procedure on the computer containing the database (the computer running Microsoft SQL Server). Open a Command Prompt dialog box (terminal window on Linux).

  1. Open a Command Prompt dialog box (terminal window on Linux).
  2. Navigate to the following directory: 

    <SEE_install_dir>/<os_dir>/reffiles/SMAFIPserver/db/mssql/

    where <os_dir> is one of the following:

    • /win_b64/ for Windows 64-bit
    • /linux_a64/ for Linux 64-bit

  3. Type one of the following commands, based on your operating system. Enter information for Microsoft SQL Server database like Server Name, Instance Name (Optional, Note: if more than one Microsoft SQL Server versions installed on machine, it requires Instance Name else keep it blank), Port number, Database name, User Name, and Password.

    • Windows: createtables

    • Linux: ./createtables

  4. Verify correct script operation by examining the createtables.log file, which is located in the same directory as the createtables command itself.