AnsweredAssumed Answered

Move Enterpise PDM to new SQL server.

Question asked by Jeff Allen on Apr 5, 2016
Latest reply on May 15, 2016 by Jeff Allen

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?

Outcomes