Create a new site database for SQL - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

This procedure is for SQL Server 2016. If you are using Oracle, see Create a new site database for Oracle.

  1. Open the Database Wizard, select Create a new site, and then click Next.

  2. On the Create Site Database and Schema page, do the following:

    1. Select MSSQL from the Database type list.

    2. Select the name of the server in the Site database server list on which your site database will reside. Only registered SQL Servers appear in the Site database server list. For more information about registering a SQL server, see the Smart 3D Installation Help

    3. Type the name of your site database in the Site database name text box. Include the type of database in the name you type. For example, type Project1SiteDB (where DB stands for database) or Project1_SDB (where SDB stands for site database).

      SHARED Tip When you name the site database, the site schema server and site schema name default to match the site database server and name.

    4. Type 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.

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

    6. Type 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. For more information about installing and configuring the Name Generator Service, see the Smart 3D Installation Help.

    7. Use the default paths for the site database files in the Physical database and Log file boxes.

  3. Click Browse Browse ... ICON to the right of the Template file to be used to create site schema text box and browse for the name of the template file (apprepos.dat) the software uses when creating your site schema database. The location of the file is on the reference data computer in the [Product Folder]\3DRefData\DatabaseTemplates folder.

  4. Select apprepos.dat. This is the file that the software uses when creating your site schema database.

  5. Click Next.

  6. On the Catalog Database and Schema page, select Use existing catalog, and then click Next.

  7. On the Ready to Load Databases page, click Next to create the specified databases.

  8. After the the site and site schema databases are created, the wizard displays a summary page. Click Finish to close the Database Wizard.

The Name Generator Service that runs on the server computer you specify in the Name generator server for site box 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 you type 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.