Moving to a Newer SQL Server/Version

book

Article ID: 131670

calendar_today

Updated On:

Products

CA Output Management Document Viewer CA Output Management Web Viewer

Issue/Introduction



How to move to a new SQL Server? I know during a fresh install we can pick what SQL Server we want to use, but how to I migrate later? We are currently running on SQL Server 2008 and are trying to upgrade to SQL Server 2014. In 12.1 Web Viewer I see the properties for it in WVProfile.properties, but I see the password is already encrypted in there. How would this migration work?

Environment

Release:
Component: WBVLUW

Resolution

We recommend using MS SQL Backup & Restore to move the DB from SQL Server 2008 to SQL Server 2014, then running the Web Viewer ConfigTool to point to new SQL Server. If the credentials are all the same, you could be finished at that point. If they are not, if the credentials changed, go through the ConfigTool to point to the new server AND provide the new credentials – you can’t encrypt it yourself. In any event, it’s best to use the ConfigTool and let it make the changes for you.