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
-
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.
-
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.
-
-
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.
-
Click Continue.
Smart Interop Publisher performs the backup and then the upgrade.
When the process finishes, Smart Interop Publisher displays the Projects View.
-
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
-
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. -
Select Create a new site database and then click Continue to display the Configure Site Database Dialog.
-
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
-
Type a name for your site database Name.
-
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.
-
-
To check the paths, open the SQL Server Configuration Manager and look at the site Properties.
-
In the SQL Server Data Path Name box, browse to the folder for the site database file.
-
In the SQL Server Log File Path Name box, browse to the full path of the SQL Server-generated log file.
-
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.
-
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.
-
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.
-
Use the default project.
-OR-
Create new projects.See Create a project.