Upgrade Site Databases and Projects - 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)

After you have installed the latest version of Smart Interop Publisher, you must perform a database upgrade. At a minimum, you must either (a) upgrade your previous site databases, or (b) create a new site database. You can choose to upgrade your project databases at a later time. Follow the steps below to either upgrade or create a new site database.

Option A: Upgrade

  1. Click the Smart Interop Publisher icon on your desktop .
    -OR-
    From the Start menu, click All Programs > Intergraph Smart Interop Publisher.

    Smart Interop Publisher displays the Upgrade Database dialog box.

  2. Select one of the following to upgrade:

    • Upgrade site and project databases - Upgrades all your site and project databases on the current system.

    • Upgrade site database only - Upgrades only the site databases without upgrading the projects contained within the site. If you choose to use the projects at a later time, you must run the Upgrade Project command in the Projects view.

  3. Click Create Backup, and then browse to a folder location to store the backup. Make sure the user account under which the SQL Server service is running has write permissions to the folder. This can be confirmed by running Services on your system to see which account the service is running under.

  4. Click Continue.

    Smart Interop Publisher performs the backup and then the upgrade.

    When the process finishes, Smart Interop Publisher displays the Projects view.

  5. You can create new projects for the site database.
    -OR-
    Upgrade projects. For more information, see Create a project and Upgrade a project topics in the Smart Interop Publisher User's Guide.

Option B: Create a New Site Database

  1. Click the Smart Interop Publisher icon on your desktop .
    -OR-
    From the Start menu, click All Programs > Intergraph Smart Interop Publisher.

    Smart Interop Publisher displays the Upgrade Database dialog box.

  2. Select Create a new site database and then click Continue.

    Smart Interop Publisher displays the Configure Site Database dialog box.

  3. In the SQL Server Name box, select the SQL Server instance name you created for Smart Interop Publisher.

  4. Type a name for your site database Name.

    • Each site name must be unique.

    • The following characters cannot be used in a site database name:

      • Plus (+)

      • Minus (-)

      • Period (.)

      • Comma (,)

      • Question mark (?)

      • Quotation mark (")

      • Greater than (>)

      • Less than (<)

      • Pipe or bar (|)

      • Forward slash (/)

      • Back slash (\)

      • Asterisk (*)

      • Colon (:)

      • Semicolon (;)

    • Site names cannot start with a number.

    • Do not insert spaces in the site name.

    • Site names cannot be longer than 21 characters.

  5. When you create a new Smart Interop Publisher site or project database, you can use either the default SQL Server location or specify your own location. Clear Use the SQL Server default locations to select different locations for SQL Server Data Pathname and SQL Server Log File Pathname.
    -OR-
    Keep the Use the SQL Server default locations option selected to use the default location. Default SQL Path displays in the location boxes for SQL Server Data Pathname and SQL Server Log File Pathname, and the software uses the locations defined for these in SQL Server.

    • After you create a database, you cannot change the SQL Server Data Pathname and SQL Log File Pathname locations.

    • If you are creating a project or site connected to a remote SQL Server instance, you cannot change the SQL Server Data Pathname and SQL Log File Pathname locations.

  6. To check the paths, open the SQL Server Configuration Manager and look at the site Properties.

  7. In the SQL Server Data Path Name box, browse to the folder for the site database file.

  8. In the SQL Server Log File Path Name box, browse to the full path of the SQL Server-generated log file.

  9. Keep the Create default project option checked for Smart Interop Publisher to automatically create a project called [site database name]_General. Otherwise, you must create a project before you can add source files.

  10. If you selected Create default project, browse to or type a Shared Content Location. Every Smart Interop Publisher project requires a shared content location. This folder contains internal files used by Smart Interop Publisher to support work done in the specified project.

  11. Click Configure.

    The software creates subfolders under your shared content location in which you can organize all your work for the selected project.

    Unless you specify a location, Smart Interop Publisher uses the shared content location and its subfolders for default location settings.

    When the process finishes, Smart Interop Publisher displays the Projects view.

  12. Use the default project.
    -OR-
    Create new projects.

    For more information, see Create a project in the Smart Interop Publisher User's Guide.