locked
repoint WCF SQL Adapter RRS feed

  • 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.

    Monday, October 21, 2013 3:28 PM

Answers

All replies

  • 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.

    • Marked as answer by Angie Xu Monday, October 28, 2013 1:18 AM
    Monday, October 21, 2013 3:46 PM
  • Short answer: Yes.

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

    Monday, October 21, 2013 5:17 PM
    Moderator