4 Replies Latest reply on May 15, 2016 9:23 PM by Jeff Allen

    Move Enterpise PDM to new SQL server.

    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?