- This topic has 1 reply, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hi,
This is about changing the SQL Server after we build the project which uses SQL Adapter and Updategram.
I have built a BizTalk project to store the flat file data to DataBase. I am using SQL Adapter, Updategram and Orchastration in this project. I am using the local DB to store the data. Now I want to move the project to Production server so I need to change the SQL Server in my project too. I am not sure how to change the database path for this case.
I remeber that I used SQL Connectivity string to create Updategram. If I change the DB server path in the sent port, how it will affect the Updategram? what should I have to change in updategram when I change the DB server?
Thank you in advance,
Siva
-
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.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.