Change Database Collation - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation

Intergraph Smart 3D
Installation & Upgrade
12.1 (2019)
  1. Install SQL Server with locale-specific collation. These collation settings include the character set, sort order, and other locale-specific settings.

  2. Install Smart 3D client.

  3. Click Start > All Apps > Intergraph Smart 3D > SQL Server Collation Utility.

    The SQL Server Collation Utility displays. See SQL Server Collation Utility Dialog Box.

  4. Specify the collation that you need.

    The file names for the “new” templates update to reflect the selected collation automatically.

  5. You can modify the default file names and paths.

  6. Click OK to update the collation in the templates. These templates can now be used to create every Smart 3D database in the correct collation for the project.

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

  8. Follow the steps to create a new site.

  9. In the Template file to be used to create site schema field, select the new template with the desired SQL Server collation that you created with the SQL Server Collation Utility.

  10. When creating or restoring the catalog database for the new site, be sure to select the template with the correct collation. If the collation for the selected catalog does not match the collation for the site, the following message appears: "The collation for the selected template, catalogdb.dat, does not match the collation for the site. Please select another template."

    This message also appears in the Bulkload Utility and in the New Catalog command in Project Management if the collation does not match the site.

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

  11. When you create the plant, reports, and reports schemas in Project Management, Smart 3D automatically uses the collation of the site database.

  12. In the future, when you create additional sites or catalogs, remember to select the correct template with the desired collation.

See Also

Install Microsoft SQL Server 2016