Moving a Microsoft SQL Server Database

There are two main methods for moving a Microsoft SQL Server database. Both methods assume that Microsoft SQL Server has been installed on the new server prior to moving the Visual Intercept database.

The first method is to simply backup the Visual Intercept database and then restore it on the new server, using the Microsoft SQL Server backup features. Please consult your Microsoft SQL Server documentation for instructions on utilizing the backup and restore operations.

The second method is to run the intercpt.sql script on the new machine to create the Visual Intercept database schema and then use the Visual Intercept import and export utilities to bring in your current Visual Intercept data. The intercpt.sql script is installed by default to the C:\Program Files\Visual Intercept Enterprise\Database directory.

Instructions for Creating a new Visual Intercept database schema:

1. Click Start |Programs |Microsoft SQL Server |Query Analyzer
2. In the Connect to SQL Server dialog, select the SQL Server machine that will host your Visual Intercept database. Select to Use SQL Server authentication and enter your Login Name and Password and click OK.
3. In SQL Query Analyzer, click File |Open and navigate to the Visual Intercept Database directory (by default, this will be located in the C:\Program Files\Visual Intercept Enterprise\Database directory) and Open the intercpt.sql database script.
4. With the intercpt.sql now open in the Query window, select Edit | Go To Line, enter 63 in the Go To Line dialog and click OK. Change the value of the SELECT @bCreateDatabase from 0 to 1.
5. The intercpt.sql script is set up to create a database named "intercept", to create a new database with a different name you will need to change the name in three instances of the script. In the Edit |Go To Line, enter 76 in the Go To Line dialog and click OK. Change the name of the database from intercept to YourNewDatabaseName. Repeat process on lines 109 and 125.
6. Click Query |Execute to create a Visual Intercept database.
7. The Query will run in the lower window. Scrolling to the bottom of this lower window, you will see a line stating "Done updating database objects", followed by a line informing you that the script is Finished.
8. Click File |Exit to close out of Query Analyzer.

Instructions for Exporting and Importing Visual Intercept Data:

1. In Control Panel's ODBC Administrator, create a DSN that points to your new Visual Intercept database.
2. Next, using your old DSN, open the Visual Intercept Desktop Administrator.
3. Select File | Export
4. In the Export Data dialog select the Visual Intercept Dataset.
5. Select a location and name for the .DMP file that will contain your exported data.
6. Click OK and exit the Visual Intercept Administrator.
7. Using your new DSN created in step 1, open the Visual Intercept Desktop Administrator.
8. Select File | Import.
9. Navigate to the location of your .DMP file.
10. Select the File and Click OK.
11. You will be prompted by a dialog that warns that your existing Visual Intercept data will be overwritten. Since there is no Visual Intercept data in the newly created database, click OK.
12. The Visual Intercept database will be imported.

Moving Your Oracle Database

The procedures listed for MS SQL Server described above also apply to moving an Oracle database. The only exception is that you would be using the Oracle script C:\Program Files\Visual Intercept Enterprise\Database\intercpt.ora instead of the SQL Server Script.

Moving a Visual Intercept Access Database

Microsoft Access is a file-based database. Therefore, the intercpt.mdb file that contains your Visual Intercept database can simply be moved to any location on your network. Once the file is moved, the network accounts of the Visual Intercept users must be given full permission to access this new location. The default location of the Visual Intercept intercept.mdb file is C:\Program Files\Visual Intercept Enterprise\Database\intercpt.mdb. It is highly recommended that you back up your .MDB file on a regular basis.

Once the database has been moved, the ODBC DSN used by Visual Intercept to reach the database must be re-configured to point to the new location. If you are using Visual Intercept desktop this would need to done on all of the Visual Intercept client machines. If you use Visual Intercept Web, the newly reconfigured DSN used by the Visual Intercept Web Site would be changed in the Visual Intercept MMC Snap-In in Internet Information Services (IIS).

If you have other questions about issues not included in or beyond the scope of this Tech Tip, please contact Elsinore Technical Support Services at