HOWTO:Export SQL Global Data to File Based Database

From WireCAD Online Help
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 v6-v7 Equipment Libraries.
  5. Un-check the [Database is Server Based] option and click the [...] button in the File Name field. Browse to the location of the WireCADGlobalEquipment.vdb3 file you copied from the v6 project.
  6. Select the Import option.
  7. Click [Sync] and wait for it to finish. You will see in the final report that the DocumentsCollection Failed. This is ok since the v6 version does not contain a documents table.
  8. Done. You are now in sync with the incoming data. You will need to close your Equipment Library and any grids that you have open, then re-open to see the changes.