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?