Difference between revisions of "Moving A WireCAD SQL Project Database Using Microsoft SQL Server Management Studio"
From WireCAD Online Help
Line 24: | Line 24: | ||
|- | |- | ||
| 2. Find the file path that your SQL databases are saved to. You can do this by right clicking on your host server name in the ''Object Explorer'' and then selecting '''Properties>Database Settings.''' | | 2. Find the file path that your SQL databases are saved to. You can do this by right clicking on your host server name in the ''Object Explorer'' and then selecting '''Properties>Database Settings.''' | ||
− | | [[File: | + | | [[File:RightClick.png|50px]] [[File:Properties.png|50px]] [[File:Database Settings.png|50px]] |
|- | |- | ||
| 3. Take note of where the databases are saved and then return to your ''Object Explorer''. | | 3. Take note of where the databases are saved and then return to your ''Object Explorer''. | ||
|- | |- | ||
| 4. Right click on your project database and select '''Task>Detach'''. | | 4. Right click on your project database and select '''Task>Detach'''. | ||
− | | [[File:Task Detach.png|thumb | + | | [[File:Task Detach.png|thumb]] |
|- | |- | ||
| 5. A new window will open showing your database. If a message appears that you have a connection to that database, check the '''Drop Connections''' box and click ''OK''. | | 5. A new window will open showing your database. If a message appears that you have a connection to that database, check the '''Drop Connections''' box and click ''OK''. | ||
− | | [[File:Drop Connections.png|thumb | + | | [[File:Drop Connections.png|thumb]] |
|- | |- | ||
| 6. Navigate to your database folder location and copy your projects '''MDF & LDF''' filesto the default folder location of your new SQL Server. | | 6. Navigate to your database folder location and copy your projects '''MDF & LDF''' filesto the default folder location of your new SQL Server. | ||
− | | [[File:MDF and LDF.png|thumb | + | | [[File:MDF and LDF.png|thumb]] |
|- | |- | ||
| 7. With your new SQL Server Location open, login to the server and attach your Project Database's to your new server. | | 7. With your new SQL Server Location open, login to the server and attach your Project Database's to your new server. | ||
Line 41: | Line 41: | ||
|- | |- | ||
| 8. A new window will open under ''Databases to attach''. Click '''Add''' and navigate to your project '''MDF''' file that you copied from the other machine. | | 8. A new window will open under ''Databases to attach''. Click '''Add''' and navigate to your project '''MDF''' file that you copied from the other machine. | ||
− | | [[File:Attach Databases.png|thumb | + | | [[File:Attach Databases.png|thumb]] [[File:MDF.png|thumb]] |
|- | |- | ||
| 9. When you select the correct '''MDF''' file, it will automatically grab both the Data MDF file and the Log LDF file under database details. (Make sure you see both of these files) | | 9. When you select the correct '''MDF''' file, it will automatically grab both the Data MDF file and the Log LDF file under database details. (Make sure you see both of these files) | ||
− | | [[File:Attach Databases 2.png|thumb | + | | [[File:Attach Databases 2.png|thumb]] |
|- | |- | ||
| 10. Verify that your databases are now in the correct location and your done. | | 10. Verify that your databases are now in the correct location and your done. | ||
|} | |} |
Revision as of 13:47, 24 April 2013
Command Line Shortcut: Varied User Permissions Level: All |
Note: You will need to have access to both SQL server locations as well as have Microsoft SQL Server Management Studio installed on your machine. |
Before You Start
This procedure assumes that you are not afraid of working with SQL Server. It also assumes that the project databases and global equipment databases are SQL Server based.