Upgrade Site Databases and Projects - Intergraph Smart Interop Publisher - Installation & Upgrade

Intergraph Smart Interop Publisher Installation and Setup

Language
English
Product
Intergraph Smart Interop Publisher
Search by Category
Installation & Upgrade
Smart Review Version
2020 (15.0)
Smart Interop Publisher Version
17

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.

  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. See Create a project and Upgrade a project.

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 to display the Upgrade Database Dialog.

  2. Select Create a new site database and then click Continue to display the Configure Site Database Dialog.

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

    You can also set up a site database on a remote system where the SQL Server Browser service is disabled by appending the system port number used by SQL Server. Use a comma to separate the system name and server name: [system name]/[SQL server name],[system port number].

    Example:

    System name: US-PPM305

    MSSQL server name: MSSQLSERVER1

    Port number: 24310

    How To Find the Port Number

    To find out the system's SQL Server port number, use the SQL Server Configuration Manager that is installed with your SQL Server installation. The SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. For details on how to add the SQL Server Configuration Manager snap-in, see the Microsoft Technical Documentation site.

    1. Open the SQL Server Configuration Manager, and go to Protocols for [SQL Server name].

    2. Right-click and select Properties.

      Click the IP Addresses tab and note the number for TCP Port used by IPAll as shown in the example below. This is the port number to enter in Smart Interop Publisher.

  4. Type a name for your site database Name.

  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.

    See Create a project.