| Author |
Topic |
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
 Posted - 2010-04-27 : 01:06:07
|
| Hi Experts,Good day..As i need a Stored Procedure which will Push the Data(Result set)to another Database on the same server so we are looking for this has been done using Web Services..so can you please help me out how to do this cos iam new to this webservices and any help greatly appreciated.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-04-27 : 01:26:02
|
| Yup..You are Absolutely correct...sorry.i was not clear..both databases are not on the same server...Means different server..i was asked to do push the data using webservices.. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-04-27 : 01:37:22
|
| Hope..Iam not clear..so let me come back soon with the exact issue we have..thanks for the patience tkizer.. |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-04-27 : 01:56:31
|
| Hi again,My stuff is like,lets say..we need to invoke a Webservice from our db triggers(sql server 2005 db)and pass some parameters to webservice(which deployed it already)so once webservice invoked from triggers and parameters has been passed to web services,which will process it.it's like triggers invoke the web service and params has been passed to webservice from our db..hope iam clear..Thanks..any help would be greatly appreaciated..can you help me out how to achive this |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-04-27 : 04:20:57
|
| Guys!..Am i not clear? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-27 : 04:26:11
|
| you didnt answer Tara yet. i.e why cant you consider replication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-04-27 : 04:57:29
|
quote:
Originally posted by visakh16
you didnt answer Tara yet. i.e why cant you consider replication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
oh!..oops!.iam sorry..Thanks visakh for the response.i dunno anything about Replication at all..my requirement is like..we have a CRM system,in that say customer payment details table,updates can happen multiple ways( through Call center,Marketing team..blah balh)..ok..if updates happens on this table,other side on a another server needs this update values on Finanicial Database,for this update this tbl,they have a webservice to updates their table..if we pass the set of parameters to the web service,then it will take care next..we don't need to bother..web services has been ready and up and running in dev server..they have asked to us to consume the webservice in our trigger and pass the req parameters..this is all about..can you please help me out..how to do this..sorry again if iam not clear |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-27 : 07:19:19
|
| nope. in that case what you can do is configure replication b/w servers rather than using webservices. it synchronises the dbs automatically. search on replication in google to get more details------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Trigger - !!!!