View source for HOWTO:MoveProjectServer

{{PageHeader
|shortcut=Varied
|perms=All
|level=All
|desc=If you need to change the sql server that WireCAD looks at you will need to follow these procedures.}}<br>

{{note|You will need to use MS Sql Server Management Studio (SSMS), and a text editor like Notepad.exe for the following procedures.}}

__TOC__


== Before You Start ==
This procedure assumes that you are not afraid of editing text files and 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 ==

# Launch SMSS and log in to the old server. We can't tell you how to do this. It's your server and your login. Here is tutorial on starting up a SQL Server [Setup_SQL_Server|click here]
# Select the WireCADGlobalEquipment database and right-click. The click Properties. Then the Files page. Note the file locations. We will need this information later.
# Close the properties window
# Right-click the WireCADGlobalEquipment database again then click Tasks>Detach...
# Now click Detach/OK

Repeat this process for ALL PROJECT databases.

== Move Files to New Server==

# The files you noted in step 2 above will need to be moved to the new server. 
# Log SMSS into the new server. We can't tell you how to do this. It's your server and your login. Here is tutorial on starting up a SQL Server [Setup_SQL_Server|click here]
# Right-click the server node in the object browser and Attach all of the databases from the old server.


== Edit *.WC6PLF Files to Point to New Server==

Now you will edit the project files so that they point to the new SQL server.
# Open the project's YOUR_PROJECT_NAME.wc6plf file in a text editor and edit the following segments:
<DatabaseHost>NEW_HOST_NAME</DatabaseHost><br>
<DatabaseUser>NEW_USERNAME</DatabaseUser><br>
<DatabasePassword>NEW_PASSWORD</DatabasePassword><br>

== Edit the Application Settings to Point to New Server ==
# Open WireCAD
# Click Project>Application Setup Wizard.
# Proceed through the wizard pages and enter necessary host info and log in.
# Relaunch WireCAD
# Test open all modified project and make sure they can see the databases.


Done.