Difference between revisions of "Convert Vista Project To SQL Project"

From WireCAD Online Help
Jump to: navigation, search
(Created page with "{{PageHeader |shortcut=np |perms=All |level=All |desc=}}This will guide you on how to convert a project from a ''Vista Database'' to a ''SQL Sever Database''.<br> __TOC__ == B...")
 
(→‎Converting Vista DB to SQL DB)
 
(2 intermediate revisions by the same user not shown)
Line 9: Line 9:
  
 
== Before You Start ==
 
== Before You Start ==
−
You will need to have a project created using a ''Vista DB'' and have that project checked out using the ''Pack Up and Go'' function. For more info on the pack up and go function, please see [[Howto:Packup and Go]]
+
You will need to have a project created using a ''Vista DB'' and have that project checked out using the ''Pack Up and Go'' function. For more info on the pack up and go function, please see [[PackUp_CheckOut]] & [[Unpack/Checkin]]
  
 
   
 
   
Line 17: Line 17:
 
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%"
 
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%"
 
|-
 
|-
−
! Step !! Description
+
! Step !! Description/Notes
 
|-
 
|-
−
| Check for Program Updates Automatically Upon Startup || This is pretty self-explanatory. Checking this setting will force WireCAD to automatically try to access the server during startup and check for any updates avaliable. [[File:Updates On Startup.png|thumb|Check for Updates Automatically Upon Startup]]
+
| 1. Create a new SQL project with the exact same name as the Vista project. || If your Vista project is in the same location that you are wanting your SQL project to reside then first move your Vista Project folder to another location.
 
|-
 
|-
−
| Show Application Setup Wizard Upon Startup || This will cause the Application Setup Wizard to open each time you start WireCAD. This is the same wizard that you are presented with during your initial WireCAD setup. [[File:Application Wizard.png|thumb|Show Application Setup Wizard Upon Startup]]
+
| 2. With your newly created SQL Project open, go to the WireCAD Project Menu>Project Utilities>Check in Project.  
 
|-
 
|-
−
| Community Library Auto-Contribution Mode || This defines when and if WireCAD will upload created equipment to the online community library. When you first setup WireCAD you are asked to select which method you would like to use (Automatically, only after approval, or never). If you would like to change this, simply ''Click'' the drop down box and select which method you would like to use. [[File:Auto Contribute Mode.png|thumb|Community Library Auto-Contribution Mode]]
+
| 3. Follow the types in the Check in dialog. Locate the path to your Vista Project.|| If your vista project is not in a zipped folder then change the file type option in the lower left corner of the navigation window to the WireCAD Project Locator file type and select the project locator file for your vista project.
 
|-
 
|-
−
| Release Licence Lease Upon Application Shutdown || Releasing the lease is useful if you are floating your license among multiple machines. This will allow you to close WireCAD on one machine and open it on another using the same license code. {{Note| Your machines will need to be web connected in order to verify and activate the license on each machine. If you do not have web access, leave this unchecked, manually release your license and then activate by phone on the next machine.}}  [[File:Release License.png|thumb|Release License Lease Upon Application Shutdown]]
+
| 4. Once you have the file path selected click next and then click Finish to start the check in process. During the check in process all the data located in your vista project will be copied into your sql database and your drawings will be copied over into the sql project folder location.
 
|-
 
|-
−
| Default Project Database Host (SQL only)|| If you are running on a SQL Server, this will be your default host name where your project database will be stored. [[File:Default Host.png|thumb|Default Project Database Host (SQL only)]]
 
−
|-
 
−
| Use SQL Server Project Databases By Default || If you have set up a SQL server database during the initial WireCAD setup, this will be checked and will force the program to use the SQL server project databases as your default databases. [[File:SQL Server Default.png|thumb|Use SQL Server Project Databases By Default]]
 
−
|-
 
−
| Users (mere mortals)Can Select Project Database Mode || This will allow any WireCAD user to select which project database is used without requiring administrative privileges. [[File:Mere Mortals.png|thumb|Users (mere mortals) Can Select Project Database Mode]] 
 
−
 
 
|}
 
|}

Latest revision as of 07:49, 22 March 2012

Command Line Shortcut: np

User Permissions Level: All
Product Level: All

This will guide you on how to convert a project from a Vista Database to a SQL Sever Database.


Before You Start

You will need to have a project created using a Vista DB and have that project checked out using the Pack Up and Go function. For more info on the pack up and go function, please see PackUp_CheckOut & Unpack/Checkin


Converting Vista DB to SQL DB

Step Description/Notes
1. Create a new SQL project with the exact same name as the Vista project. If your Vista project is in the same location that you are wanting your SQL project to reside then first move your Vista Project folder to another location.
2. With your newly created SQL Project open, go to the WireCAD Project Menu>Project Utilities>Check in Project.
3. Follow the types in the Check in dialog. Locate the path to your Vista Project. If your vista project is not in a zipped folder then change the file type option in the lower left corner of the navigation window to the WireCAD Project Locator file type and select the project locator file for your vista project.
4. Once you have the file path selected click next and then click Finish to start the check in process. During the check in process all the data located in your vista project will be copied into your sql database and your drawings will be copied over into the sql project folder location.
Retrieved from "https://www.wirecad.com/wiki/index.php?title=Convert_Vista_Project_To_SQL_Project&oldid=2301"