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:RightClick.png]] | + | | '''[[File:RightClick.png]]''' |
− | | | + | | '''http://www.wirecad.com/wiki/images/4/44/Properties.png''' |
− | + | | [[File:Database Settings.png]]<br/> | |
|- | |- | ||
| 3. Take note of where the databases are saved and then return to your ''Object Explorer''.<br/><br/> | | 3. Take note of where the databases are saved and then return to your ''Object Explorer''.<br/><br/> | ||
|- | |- | ||
| 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 43: | Line 43: | ||
|- | |- | ||
| 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 14:07, 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.
Removing the Files from the Old Server
Step | Description/Image | ||
---|---|---|---|
1. Launch Microsoft SQL Server Management Studio and log on to your SQL server that contains your project database | You will need to have admin privileges so check with your I.T. department if you are unsure of permissions or locations. | ||
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. | http://www.wirecad.com/wiki/images/4/44/Properties.png | | |
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. | |||
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. | |||
6. Navigate to your database folder location and copy your projects MDF & LDF filesto the default folder location of your new SQL Server. | |||
7. With your new SQL Server Location open, login to the server and attach your Project Database's to your new server. | To attach your databases, right click on Databases in your Object Explorer window and select Attach. | ||
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. | |||
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) | |||
10. Verify that your databases are now in the correct location and your done. |