HOWTO:Export SQL Global Data to File Based Database

From WireCAD Online Help
Revision as of 04:48, 25 January 2013 by Wirecadadmin (Talk | contribs)

Jump to: navigation, search
Command Line Shortcut: NONE

User Permissions Level: All
Product Level: All
Describes procedure for exporting your v6 SQL Global Database into a file based version that you can sync with v7.




Summary

As of this writing WireCAD v7.0.0.1083 Global Equipment Database cannot reside on the same server as WireCAD v6. We are working to correct this but in the mean time, you will need to export the data from the v6 SQL database into a file base database (VISTADB). Then you can sync that with the v7 global db.

Before You Start

You will need WireCAD v6 and WireCAD v7 installed. They can reside on the same machine. You will need them both authorized.

HOW TO

  1. Open WireCAD v6.
  2. Create a dummy project. Maybe name it MyDummyProject. You will need the path to this project later.
  3. Click Project>Utilities>Pack-up CheckOut. Proceed through the Pack-up process. This may take some time.
  4. If you created a SQL dummy project I recommend using the CheckOut function. That way you can check the project back in later and still have a SQL project.
  5. ----
Bulbgraph.png Note: The Pack-up or Check-out function will create the Global Database in VISTADB form and save it in the MyDummyProject\Project Databases folder.

  1. Open the MyDummyProject\Project Databases folder and copy the WireCADGlobalEquipment.vdb3 to a known location on the WireCAD v7 machine.
  2. Close WireCAD v6.
  3. Open WireCAD v7.
  4. Click Database>Sync Global Databases.