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...") |
(No difference)
|
Revision as of 15:28, 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.
|
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.
