Create site database from an existing catalog for SQL - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

This procedure is for SQL Server 2016. Site and catalog database creation requires that you install the Project Management and Server Connectivity components. You must have the appropriate server components from Microsoft SQL Server installed on the server computer in order to create the databases. For more information about installing Microsoft SQL Server software, see the Installation Guide available from Help > Printable Guides. The user login used to create the Smart 3D 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. You must name the databases with unique entries. Write down the names as you proceed.

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

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

    1. Select MSSQL from the Database type list.

    2. On the Create Site Database and Schema page, 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 Installation Guide available from Help > Printable Guides.

    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 Model1SiteDB. 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.

      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 typed 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.

    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 Installation Guide available from Help > Printable Guides.

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

    8. Click the ellipsis button 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.

  3. Click Next.

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

  5. On the Ready to Create Databases page, click Create DB to create your databases.

  6. When the Database Wizard displays the site database names that you typed, click Finish.