Create the Site, Catalog, and Schema Databases for SQL - Intergraph Smart 3D - Installation & Upgrade

Intergraph Smart 3D Installation

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
11 (2016)

This procedure is for users of Microsoft SQL Server. If you are using Oracle, skip ahead to Create the Site, Catalog, and Schema Databases for Oracle.

Site and Catalog database creation requires that you have Project Management and Server Connectivity components installed on the computer that you are using.

You must have the appropriate server components from Microsoft SQL Server installed on the server computer in order to create the databases. The user login used to create the databases must be part of the Administrators group on the local computer and the database server. Other users do not need to be part of the Administrators group on the local computer in order to run the product.

  1. Click Start > All Apps > Intergraph Smart 3D > Database Wizard.

  2. Select Create a new site, and then click Next.

  3. From the Database type list, select MSSQL.

    Database Type - MSSQL

  4. From the Site database server list, select the database server on which your Site database will reside.

    SHARED Tip Only registered SQL Servers appear in the Site database server list. If your server does not appear, follow the steps in Register the Microsoft SQL Server.

    Site Database Server - MSSQL

  5. Enter the name of your Site database in the Site database name text box. Include the type of database in the name that you type. For example, type MySiteDB, My_SDB, or ProjectXYZ_SDB, where SDB stands for Site Database. Using the database type in the name makes identifying the Site database in SQL Server Management Studio easier. You must name the databases with unique names.

    SHARED Tip When you name the Site database, the Site schema server and Site schema name boxes default to match the Site database server and name.
    Site Database Name - MSSQL

  6. Enter the workshare location for the Site database in the Site database workshare location text box. You can use any string that represents your physical location.

    This location is the location of the host Site database and is required even if the host is not going to be replicated for worksharing purposes. During generation of the Site database, the software creates a location object and associates it with the Site database.

    Site Workshare Location - MSSQL

  7. Enter a name rule ID in the Name rule ID text box. By default, the software leaves this field blank. You can enter any string identifier, numeric or alpha.

    The Name Generator Service that runs on the server computer you specify in the Name generator server for site box (step 8) supplies unique names to items placed in the Model database. In a replicated configuration, there are multiple servers and multiple instances of the Name Generator Service running at each location; consequently, there is no way to ensure unique and sequential naming of placed objects. The value entered in the Name rule ID text box functions as a substring (an internal ID number) that represents the location at which an item is placed into the replicated model.

    Name Rule ID - MSSQL

  8. Enter the name of the server computer on which the Name Generator Service is configured in the Name generator server for site box.

    A name server must be a valid computer running on the Windows domain and one that has been properly configured to run as a name server. If you do not have a name generator server set up, see Name Generator Service Setup.

    Name Generator Server - MSSQL

  9. You cannot change the default locations for the site database files in the Physical database and Log file boxes.

  10. Click Browse Browse ... ICON to the right of the Template file to be used to create site schema text box.

    The Browse for file on server: database_server_name dialog box appears.

  11. If you installed the Reference Data on your database server, browse to the Plant, Marine, or MaterialHandling folder in the [Installation folder for Smart 3D Reference Data]\DatabaseTemplates file path.

    If you did not install the Smart 3D Reference Data on your database server, you must copy the files in the Plant, Marine, or MaterialHandling folder in the [Installation folder for Smart 3D Reference Data]\DatabaseTemplates file path on the reference data computer to a folder on a local drive on the database server computer.

  12. Select the apprepos.dat file, which is used by the software when creating your Site schema database.

  13. Click Next.

    The Catalog Database and Schema page displays.

  14. Select whether you want to use an existing catalog or restore a catalog from backup.

    • The Use existing catalog created in Project Management or Bulkload option to use an existing Catalog that is already available. If you intend to create a custom catalog, select this option and use the Bulkload utility delivered with the product. If you have used previous versions of Smart 3D, more than likely this is the option that you want. If you select this option, skip to step 20.

    • The Restore catalog from backup option restores a catalog from a Microsoft SQL Server backup file. If you choose to create a new Catalog database for the site using this option, the wizard will restore the .dat file specified in the Template file to be used to create the Catalog database and schema box. Default Catalog database .dat files are delivered in the Plant, Marine, or MaterialHandling folder in the [Installation folder for Smart 3D Reference Data]\DatabaseTemplates file path with the Reference Database installation.

      The catalogdb.dat, sm_shipcatalogdb.dat, and mhe_catalogdb.dat template files contain sample Smart 3D reference data and, while the templates contain many useful examples, they are not certified for production use.

  15. Select the name of the database server in the Catalog database server list on which your Catalog database will reside.

    SHARED Tip Again, only registered Microsoft SQL Servers appear in the Site database server list. If your server does not appear, follow the steps in Register the Microsoft SQL Server.

  16. Enter the name of your catalog database in the Catalog database name box. This step also automatically populates the name of your Catalog schema database in the Catalog schema name text box. Include the type of database in the name that you type. For example, type MyCatalogDB, My_CDB, or ProjectXYZ_CDB, where CDB stands for Catalog Database. Using the database type in the name makes identifying the Catalog database in SQL Server Management Studio easier.

  17. Select the ellipsis button to the right of the Symbol and custom program file folder box, and browse for and select the SharedContent share on the Smart 3D reference data computer. If you did not create this share already, see Configure Network Shares.

    The path in the Symbol and custom program file folder box must be a UNC path (\\server_name\share_name). To obtain a UNC path, click the ellipsis button and browse under Network, not under Computer.

  18. Select the ellipsis button to the right of the Template file to be used to create catalog database and schema text box and browse for the name of the catalog template file that you want the software to use when creating your Catalog and schema databases. If you installed Reference Data on your database server, browse to the Plant, Marine, or MaterialHandling folder in the [Installation folder for Smart 3D Reference Data]\DatabaseTemplates file path.

    If you did not install the Reference Data on your database server, you must copy the files in C:\Program Files (x86)\Smart3D\3DRefData\DatabaseTemplates on the reference data computer to a folder on a local drive on the database server computer.

  19. You cannot change the default locations for the catalog database files in the Physical database and Log file boxes.

  20. Click Next.

  21. On the Ready to Load Databases page, click Next to create your databases.

  22. When the Database Wizard displays the database names that you entered, click Finish.