Set up Global Workshare with SQL Server - Intergraph Smart 3D - Administration

Intergraph Smart 3D Global Workshare (SQL Server)

Intergraph Smart 3D
Administration & Configuration
12.1 (2019)

After you set up the SQL Server database servers, you can use the Project Management task to set up Global Workshare.

  1. Add the Satellite locations and associate them with the name of the SQL Server database server. For more information, see New Location.

  2. Back up the SQL Server database.

  3. Run Tools > Duplicate Model for Workshare. For more information, see Duplicate Model for Workshare.

    The Duplicate Model for Workshare command generates scripts that you must run to complete the process. The scripts are located in a subfolder named Replication<<ModelName> in the local the temp folder. You can click Start > Run and type %temp% in the Run dialog box to locate the local temp folder.

  4. From a DOS command line, run the ToRunPreBackup.bat file on the Host machine.

    You may want to redirect the output to a log file to check for errors later. For example: ToRunPreBackup.bat >out, which would output to a file called out.log.

  5. Make a second backup of the databases and transfer the backup files to all Satellite locations.

  6. Restore the backups to all satellite locations.

  7. From a DOS command line, run the ToRunPostRestore_n.bat file (where n is the Satellite number on the model) for each location. These batch files can be run from the Host location or remotely to the other servers.