Application uses below config data points:
To Locate DataBase Server: Uses registered SQL Servers in user profile to auto locate its Database server. This config file is saved in "$ENV:AppDataMicrosoftMicrosoft SQL Server100ToolsShellRegSrvr.xml" location. You need to ensure to copy this file for all users of Smart3D.
To Locate the Site Database to Connect to: Uses HKCU registry to find the DataBase to connect to for that user. The registry location is: "HKCU:SoftwareIntergraphApplicationsEnvironmentsCommonAppProjectDB". The keys used are
- PhysicalName (REG_SZ) : SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_SDB
- Schema (REG_SZ) : SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_SDB_SCHEMA
C:>reg query HKEY_CURRENT_USERSoftwareIntergraphApplicationsEnvironmentsCommonAppProjectDB
HKEY_CURRENT_USERSoftwareIntergraphApplicationsEnvironmentsCommonAppProjectDB
SiteDatabaseProviderType REG_SZ MSSQL
PhysicalName REG_SZ SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_SDB
Schema REG_SZ SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_SDB_SCHEMA
C:>
To Locate other DBs: Site Database holds a table that contains the configuration for Connecting to other DBs. The table is named PRJMGTDatabase and the respective entries are Name, Path, PMSchema as given below:
SELECT Name, Path, PMSchema FROM [S3D_V11R1_SDB].[dbo].[PRJMGTDatabase]
Name Path PMSchema
Catalog SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_CDB SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_CDB_SCHEMA
Model SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_MDB SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_CDB_SCHEMA
Reports SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_RDB SERVER=APPDBSMART3D;DATABASE=S3D_V11R1_RDB_SCHEMA
Note: the PMSchema for Model point to Catalog Schema DB as there is no Model Scheme DB.
The other references related to installed servers and Databases to be taken care are below:
With in SDB:
Update S3D_V11R1_SDB..REFDATServerPath set NameGeneratorServer = ‘AppSRV01’
Update S3D_V11R1_SDB..CORENamedObjects set ObjectName = ‘S3D_V11R1_MDB’ Where ObjectOid = ‘00007535-0000-0000-0600-58AE5E511E04’
Update S3D_V11R1_SDB..PRJMGTProjectRoot set Name = ‘S3D_V11R1_MDB’
With in CDB:
Update S3D_V11R1_CDB..REFDATServerPath set CabServerPath = ‘\AppSRV01SharedContent’
Update S3D_V11R1_CDB..REFDATServerPath set OleServerPath = ‘\AppSRV01SharedContent’
With in MDB
Update S3D_V11R1_MDB..CORENamedItem set strName = ‘S3D_V11R1_MDB’ Where Oid = ‘00009C45-0000-0000-0800-B2B65E510D08’
Update S3D_V11R1_MDB..CORENamedItem set strName = ‘S3D_V11R1_MDB’ Where Oid = ‘0001ADBB-0000-0000-2200-B2B65E510D08’
Update S3D_V11R1_MDB..DRAWNGPropertyObject2 set PlantName = ‘S3D_V11R1_MDB’
Update S3D_V11R1_MDB..REFDATServerPath set NameGeneratorServer = ‘AppSRV01’
Note: There are no changes required in Schema DB as they don’t have any installation specific data.
