Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbjroms
Starting Member
13 Posts |
 Posted - 2008-02-27 : 04:46:55
|
| I am trying to develop a concept for my back-office system so that I can define the work that needs to be done. I am not a programmer so please be gentle with me!I have an MS SQL database sitting behind my (VB.Net2) my website. The database has a table into which orders go when customers buy online.What I want to do is to have a copy of this table on my local server and use a web service to feed the local database from the website database. So my idea is that as soon as the website database receives a new record it initiates the web service which sends the record down to the local databse.Simple in theory but is this feasible in practice?Thanks in anticipation.Chris |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-27 : 05:36:53
|
| you probably need replication for something like this. sql server can't call web services without some serious hacking._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
|
|
|
Web Service To Update Tables