Create new site, catalog, and schema databases for SQL - Intergraph Smart 3D - Administration & Configuration - Hexagon

This procedure is for SQL Server databases. If you are using Oracle, see Create new site, catalog, and schema databases for Oracle.

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

2. From the Database type list, select MSSQL.

   

3. Select the name of the server in the Site database server list on which your site database will reside. Only registered SQL Servers display in the Site database server list. If your server is not listed, see Register the Microsoft SQL Server in the Smart 3D Installation Help.

4. Type the name of your site database in the Site database name box. Include the type of database in the name you type. Using the database type in the name makes identifying the site database in SQL Server Management Studio easier. For example, type Project1SiteDB (where DB stands for database) or Project1_SDB (where SDB stands for site database).

   

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

5. Type the workshare location for the site database in the Site database workshare location text box. 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. You can use any string that represents your physical location.

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

7. Type the name of the server computer on which the Name Generator Service is configured in the Name generator server for site box. The 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 in the Smart 3D Installation Help.

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

   

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

10. If you installed the reference data on your database server, navigate to the [Installation folder for Smart 3D Reference Data]\DatabaseTemplates\Site folder.

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

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

12. Click Next to go to the Catalog Database and Schema page.

13. Select Restore catalog from backup. This option restores a catalog from a Microsoft SQL Server backup file. When you choose to create a new catalog database for the site using this option, the wizard restores the .dat file that you specify 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 folder.

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

15. Type the name of your catalog database in the Catalog database name box. Include the type of database in the name that you type. Using the database type in the name makes identifying the catalog database in SQL Server Management Studio easier. For example, type Project1CatalogDB (where DB stands for database) or Project1_CDB (where CDB stands for catalog database).

    

    This step automatically populates the name of your catalog schema database in the Catalog schema name text box.

16. Use the default paths for the catalog database files in the Physical database and Log file boxes.

17. Click Browse to the right of the Symbol and custom program file folder box, and browse for and select the SharedContent folder on the Smart 3D server. The path in the Symbol and custom program file folder box must be a UNC path.

18. Click Browse 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 template file you want the software to use when creating your catalog and schema databases. The location of the file is on the reference data computer in the [Product Folder]\3DRefData\DatabaseTemplates<model type> folder.

    The catalogdb.dat (Plant), sm_shipcatalogdb.dat (Marine), and mhe_catalogdb.dat (Material Handling) template files contain sample Smart 3D reference data. Although the templates contain many useful examples, they are not certified for production use.

19. Click Next.

20. On the Ready to Create Databases page, click Next to create the specified databases.

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

The Name Generator Service that you specify in the Name generator server for site box (step 7) 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.