This Document Describes the Steps Necessary to Convert the Default SQL Server Databases

This Document Describes the Steps Necessary to Convert the Default SQL Server Databases

DATABASE MODIFICATION FOR VDOT DEFAULTS

April 18, 2011

This document describes the steps necessary to convert the default SQL Server databases (Virtis62_SQLServer and Virtis62s_SQLServer) installed with Virtis to databases containing VDOT parameters and libraries.

  1. Make sure that you choose the MSDN database configuration during the Virtis®6.2 install procedure. Failure to do so will result in having to uninstall and reinstall the software.

  1. Once Virtis® has been successfully installed, copy the VDOT_Parameters.SQL and VDOT_Parameters-62.bat files to the C:\ directory on the PC where Virtis® was installed.
  1. Execute (Double-click) the VDOT_Parameters-62.bat file. This will open a system window while it adds the VDOT parameters to the two MSDN (SQLServer) databases.
  1. Login to the Virtis62_SQLServer database by selecting it from the user DSN using the button. The Username is virtis, and the password is virtis.

  1. You should see 24 entries in the Bridge Explorer when the database opens. There are 23 example structures and one Visual Reference 1 entry which can be deleted or kept for reference.
  1. Open the Configuration Browser by clicking on .
  1. Scroll down to the Parameters listing at the bottom of the window.
  1. Double-click on the Parameters entry, then choose County from the dropdown. You should see a screen like the one below.

  1. You can also review the District tab. If the County tab does not show the above, the parameters have not been added to the database. Close Virtis® and return to step 3.
  1. Close the Configuration Browser.
  1. Open the Library Explorer by clicking on .
  1. Click on File in the top menu and select Import…
  1. A Library Import window will appear. Navigate to the drive where the VDOT information is stored and select the VDOTSpecificLIBs-V62.xml file.
  1. The window will change to show the contents of the import file on the left.

  1. Click on the Rolled Beam folder highlighted in blue. A list of the data included in the import will appear in the middle section of the window.

  1. Select ALL of the entries in the middle section and click on the . This will transfer the entries to the Selected to Import section.

  1. Repeat steps 15 and 16 for all blue folders.
  1. Once all of the entries have been moved to the Selected to Import section, click on the Import button.
  1. If the import is successfulyou should see a dialog that says the import was successful .
  1. Close the Library Explorer and exit Virtis®.
  1. The above steps can also be performed on the Virtis62s_SQLServer database if desired.

THE ABOVE STEPS MUST BE PERFORMED ON EACH PC THAT HAS THE Virtis® SOFTWARE INSTALLED IN ORDER TO HAVE THE VDOT LIBRARIES AND PARAMETERS AVAILABLE.

Page 1 of 5

Top View