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

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

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.