| Author |
connect to remote database using sql adapter
|
|
|
| Hi
I developed biztalk project with sql adapter to connect to the
database.Database and Biztalk project are on same machine.In staging
environment i need to connect to remote database with sql adapter.
To connect to remote database i need to create whole Biztalk
Project.Are there is way to connect.
For Example
when we connect to database with sql adapter. click on 'Add generated
item' and select the adapter then click next to set the connection i
need to select the server name and database name.
now i already develop the project with local database. Now to connect
to remote database i need to do above thing again
I am new to biztalk world. Can any one help me.
thanks
wask
| |
| Marian Drumea 2005-12-01, 8:53 pm |
| Hi wask,
All you have to do is matter of configuration when you want to change
the server/database you want to access. Assuming that you don't need to
change the data structure at the same time, you don't need to go
through the process again.
You will need to change the details on the port and, when you deploy
your solution, you can do that by updating the binding files only.
Let me know if you can take it from here or you need more details.
Thanks,
Marian
http://www.MarianDrumea.com/BizTalk
| |
|
| Hi Marian
Thanks for help.i will try.
thanks
wask
..
| |
|
| Hi Marian
only i need to configure in Receive ports and send ports in biztalk
explore.
thanks
wask
|
|
|
|