Difference between revisions of "HOWTO:MoveProjectServer"
From WireCAD Online Help
Wirecadadmin (Talk | contribs) (Created page with "{{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 w...") |
Wirecadadmin (Talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 21: | Line 21: | ||
# Now click Detach/OK | # Now click Detach/OK | ||
| − | Repeat this process for ALL | + | Repeat this process for ALL PROJECT databases. |
== Move Files to New Server== | == Move Files to New Server== | ||
| Line 28: | Line 28: | ||
# 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] | # 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. | # 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. | ||
Latest revision as of 15:36, 20 September 2011
| Command Line Shortcut: Varied User Permissions Level: All |
 Note: You will need to use MS Sql Server Management Studio (SSMS), and a text editor like Notepad.exe for the following procedures.
|
Contents
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>
<DatabaseUser>NEW_USERNAME</DatabaseUser>
<DatabasePassword>NEW_PASSWORD</DatabasePassword>
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.
