Knowledge Base
Knowledge BaseSubject: | Host machine migration |
---|---|
Status |
Resolved |
Product | WireCAD v6 |
Product Level | PRO |
Database Type | SQL Server |
Build Number (last 4 digits of version) | |
Upload | No file! |
Message
Do you have a document that details how I can move my WireCAD installation and SQL server DBs to a new host machine? Also will WireCAD run on Server 2012R2 with SQL server 2014?
11-March-2016 (02:13 PM)
The document that we do have is marginal. I will link to it below.
The rough outline goes like this:
1. Create the new host and install the sql server version >= SQL SERVER 2005 (EXPRESS versions are ok).
2. Detach the existing databases from the old host and move them to the new host.
3. Attach the existing databases to the new host. Be sure that the user(login) has ownership of the attached databases.
4. Run WireCAD 8.
5. Open the Application Menu>Settings[Global Database Location].
6. Enter your new host info and test the connection. If the Server and Database server are configured properly you should see two messages about connection succeeded.
7. Open each project that was migrated. Please note that this procedure is much easier in WireCAD 8.
8. The connection to the old database server will fail and present you will a dialog to enter the new host info.
These articles still apply (though you may want to upgrade the version of SQL server that you use):
https://www.wirecad.com/wiki/index.php?title=Setup_SQL_Server
https://www.wirecad.com/wiki/index.php?title=Moving_A_WireCAD_SQL_Project_Database_Using_Microsoft_SQL_Server_Management_Studio
The rough outline goes like this:
1. Create the new host and install the sql server version >= SQL SERVER 2005 (EXPRESS versions are ok).
2. Detach the existing databases from the old host and move them to the new host.
3. Attach the existing databases to the new host. Be sure that the user(login) has ownership of the attached databases.
4. Run WireCAD 8.
5. Open the Application Menu>Settings[Global Database Location].
6. Enter your new host info and test the connection. If the Server and Database server are configured properly you should see two messages about connection succeeded.
7. Open each project that was migrated. Please note that this procedure is much easier in WireCAD 8.
8. The connection to the old database server will fail and present you will a dialog to enter the new host info.
These articles still apply (though you may want to upgrade the version of SQL server that you use):
https://www.wirecad.com/wiki/index.php?title=Setup_SQL_Server
https://www.wirecad.com/wiki/index.php?title=Moving_A_WireCAD_SQL_Project_Database_Using_Microsoft_SQL_Server_Management_Studio
11-March-2016 (04:07 PM)
Can I use SQL server 2014 and Windows Server 2012R2 for the OS?
11-March-2016 (04:48 PM)
Yes
11-March-2016 (04:58 PM)