ds-blue-logo
Preview  |  SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
JAJeff Allen05/04/2016

I have contacted my VAR 2 times and have not gotten a real step by step guide one how to move my databases of EPDM 2015 to a new SQL server. I have listed the steps that I think need to do and hopefully you can correct my mistakes.

Here is a brief layout of my current environment:

1 SQL 2012 Server (Current Location of EPDM Databases)

1 New SQL 2012 Server (Future Location)

1 Archive Server - Running the Archive Server and Database Server Software.

1 Replication Server

Steps:

1. Backup vault and ConisioMasterDB databases.

2. Restore the database backups on new SQL server.

3. Create a linked server entry: Exec Sys_IndexServerLink 1 (New SQL Server)

4. Update Registry Keys:

Archive Server

     HKLM\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\ArchiveServer\Vaults\"VaultName"   "Server" = "New SQL Server Instance"

Replication Server

     HKLM\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\ArchiveServer\Vaults\"VaultName"   "Server" = "New SQL Server Instance"

Clients

     HKLM\SOFTWARE\Wow6432Node\SolidWorks\Applications\PDMWorks Enterprise\Databases\"VaultName"   "DbServer" = "New SQL Server Instance"

     HKLM\SOFTWARE\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\Databases\"VaultName"   "DbServer" = "New SQL Server Instance"

     Delete    HKCU\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\ConisioAdmin

Am I missing anything?