View source for Moving A WireCAD SQL Project Database Using Microsoft SQL Server Management Studio

{{PageHeader
|shortcut=Varied
|perms=All
|level=All
|desc=This will guide you on how to move a project database to a new SQL server using Microsoft's SQL Server Management Studio.}}<br>

{{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.}}

__TOC__


== 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 ==

{| class="wikitable" style="color: black; background-color: rgb(255, 255, 204);" width="100%"
|-
! Step
! colspan="3" | Description/Image
|-
| 1. Launch Microsoft SQL Server Management Studio and log on to your SQL server that contains your project database
| colspan="3" | 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&nbsp;''Object Explorer''&nbsp;and then selecting&nbsp;'''Properties>Database Settings.'''
| style="text-align: center; vertical-align: middle;" | [[File:RightClick.png|400px|RightClick.png]]
| style="text-align: center; vertical-align: middle;" | [[File:Properties.png|400px|Properties.png]]<br/>
| style="text-align: center; vertical-align: middle;" | [[File:Database Settings.png|400px|Database Settings.png]]
|-
| 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'''.
| style="text-align: center; vertical-align: middle;" | [[File:Task Detach.png|400px|Task Detach.png]]
|-
| 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''.
| style="text-align: center; vertical-align: middle;" | [[File:Drop Connections.png|400px|Drop Connections.png]]
|-
| 6. Navigate to your database folder location and copy your projects '''MDF & LDF''' filesto the default folder location of your new SQL Server.
| style="text-align: center; vertical-align: middle;" | [[File:MDF and LDF.png|400px|MDF and LDF.png]]
|-
| 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.
| style="text-align: center; vertical-align: middle;" | [[File:Attach Databases.png|400px|Attach Databases.png]] [[File:MDF.png|400px|MDF.png]]
|-
| 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)
| style="text-align: center; vertical-align: middle;" | [[File:Attach Databases 2.png|400px|Attach Databases 2.png]]
|-
| 10. Verify that your databases are now in the correct location and your done.
|}