Migrate a Database Server (Local to Remote) - Intergraph Smart Interop Publisher - Installation

Intergraph Smart Interop Publisher Installation and Setup

PPMProduct
Intergraph Smart Interop Publisher
PPMCategory_custom
Installation & Upgrade
Version_SPR
13.x(2018)
Version_SPIOP
13.1 (2019 R1)

Before you begin, make sure you have installed the latest Smart Interop Publisher version and performed the database upgrade. For more information, see Upgrade.

Follow the steps below to move your local database to a remote server for single and multi-user access. Otherwise, you can create a new database on your remote server and create new projects or add in projects created in previous versions of Smart Interop Publisher.

  • For creation, the permissions must be set to the DBCreator role on the SQL Server instance level.

  • To allow reading data only, use the db_datareader server role.

  • To allow read and write, use the db_datawriter server role.

  1. Designate a shared folder to contain Smart Model files and source files.

  2. Use SQL Management Studio to back up your Smart Interop Publisher project (.mdf) files.

  3. Back up and then move your Smart Models and source files to that shared location.

  4. Use SQL Management Studio to back up your site database files.

  5. Make a list of your site database files and corresponding projects.

  6. Create target folders on the remote server to contain the database files and project files.

  7. If you have several files, make a list of your source files and Smart Models to include their name, old path, and then the new path of the folders you just created on the remote server:

    Name Old Path New Path

  8. Connect to your remote serve and go to the new target folders.

  9. Create new, empty site database files using the naming convention [site file name]_SSDB.mdf to replace each local site database file you have.

  10. Create new, empty project files using the naming convention [project name] _SPDB to replace each project file.

    You must use the "_SSDB" and "_SPDB" designation in the name. Otherwise, Smart Interop Publisher cannot open these files.

  11. Use the SQL Management Studio Restore command to restore the site database file first and then each project file contained in that site database. Repeat this step for each site database and project file to move.

  12. Use the SQL Management Studio New Query to run the following queries to change the path of each source file and Smart Model in your list to the new shared location:

    Source Files

    use <DatabaseName>;

    update SourceFiles

    set Path = <NewPath>

    where SourceFileName = <Name>

    Smart Models

    use <DatabaseName>;

    update SmartModels

    set Path = <NewPath>

    where SmartModelName = <Name>

You are ready to use Smart Interop Publisher with your remote database server.