Schema Name Validator - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
11 (2016)

The bulkload data files are common to both MSSQL and Oracle databases. However, Oracle has a 30 character naming constraint in the code as well as in the delivered catalog data. For cases in which you are not using the default delivered catalog, you can use the Schema Name Validator application to identify and correct these names in the databases.

This utility identifies part classes, custom interfaces, and custom interface attributes that violate the Oracle character limitation. This allows you to bulk load the data into an Oracle database, as long as the changes are updated in the bulkload data files. This is particularly useful when converting MSSQL databases to Oracle databases.

This utility is delivered by default to the SchemaNameValidator.exe file in the <Product Folder>\Core\Container\Bin\Assemblies\Release\ folder.

Prerequisites

  • Microsoft Office 2010 or later.

  • SQL Server 2008 or later.

  • Smart 3D version 2016 or later.

Impacts

  • You must update any custom code such as shared content or reports so that they use the truncated part class, custom interface, and attribute names.

  • You must update the changed names in the code for custom symbols, if they are used.

  • You must update all data files (such as Excel workbooks) so that they use the new names. The names in GUIDs sheets must be replaced to ensure that the GUID values associated with the old and new names are identical. You must update the GUID sheets to avoid errors in future bulk loads.

After Updating

  • Update all data files, reports, and shared content code with the truncated names.

  • Regenerate views on all of the model databases.

  • Run Synchronize model with catalog with the Regenerate views option selected on all of the projects. For more information, see Synchronize Model with Catalog.

  • Regenerate the reports database for each model database. For more information, see Regenerate Reports Database.

Automatically Filling in Truncated Names

If you type values in the Truncated Names column in an input file, and specify that file in the Map file location box on the Schema Name Validator dialog box, the utility can automatically fill in those names as appropriate when you generate the report. For more information, see Report Workbook, and Schema Name Validator Dialog Box.