repoint WCF SQL Adapter

Question

I have to repoint a couple of WCF SQL ports to a different SQL Server. They will be calling the same stored procedures, only on a different server. Can I simply change the server name in the port config as long as I've already got the sprocs deployed on the new server?

Thanks.

Answer 1

Hi Cooper,

In WCF-SQL Adapter, to change to different SQL Servers, just  update the connection string URL which is in the pattern of mssql://SQLServerName//DBName.

Refer these following articles:

SQL Server Connection URI

How the WCF-SQL Adapter builds the ADO.NETconnection string

---

If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful.

Answer 2

Short answer: Yes.

Long answer: So long as all other aspects of the connection, SP Name, security, etc. are the same, yes.