Re: Sql server change in BizTalk Project

Home Page Forums BizTalk 2004 – BizTalk 2010 Sql server change in BizTalk Project Re: Sql server change in BizTalk Project

#16999

All you should have to do is change the SQL Connection strings inside your Send and Receive Ports.  As long as your table names and columns are the same your updategrams should all still work. 

 

This can easily be done inside your Binding files when you move to another environment.  Just make sure you note that the passwords are always stared out when you export the binding file so you need to add them in.