Moving SmartConnect to new SQL Server
I have read multiple posts in the forum about moving SmartConnect from one SQL Server to another.
We are planning to migrate to new hardware and SQL Server 2014 (from 2012). Could you give me the definitive answer of how to move everything related to SmartConnect?
The supported method for moving SmartConnect to a new server is to create a brand new install of SmartConnect on the new server. Then you can export components from the old server, and import them into the new server.
When moving to a new SQL server, we exported/imported the maps. However, we are using a SQL Validation Pre-Task and when I change the SQL Server, it wipes out my query. The query is next to impossible to create. It’s not complicated I just don’t know how to use your interface to create it. The query is: SELECT RTrim([GL00105].[ACTNUMBR_1]) + RTrim([GL00105].[ACTNUMBR_2]) + RTrim([GL00105].[ACTNUMBR_3]) + RTrim([GL00105].[ACTNUMBR_4]) AS [Account] FROM [GL00105]
How can I type this in? The interface INSISTS on enclosing this in quotes!
If you would like to submit an answer or comment, please sign in to the eOne portal.