January 12, 2010 at 4:17 am
Good day!
I am a .net sql dba guy. I am comfortable with sql, and data, and web programs (Asp.net) that I can 'get my hands on'.
Now comes along a database that is only available to me as an API/web service. I need to sync the api database with my sql database, so they both can sell the same inventory. I have two functions available to me via the api, a simple ping to notify that event a, b, or c has taken place. I also have a bunch of 'calls' available to me. Lets call them get_inventory and set_inventory.
I am assuming that the workflow would go like this:
A web sale pings my sql database, causing sql to jump into action. Sql then runs get_inventory, to see how many were sold, and syncs the local database by reducing inventory by x. IF a sale happens locally, sql will run set_inventory to reduce inventory on the web app.
The question I DON'T get is: Is there a native web app/api interface for sql?
And if so, how to use it to make sql 'listen' for a ping then respond with a fetch?
Or do I need to program some third party middle wear to keep the two DB in sync??
ANY leads, suggestions experiences greatly appreciated!
Dan
January 22, 2010 at 6:07 am
This sounds like a case for the Service Broker. I suggest you start by looking it up in Books Online (plenty of examples there), then perhaps come back here with more details regarding your particular case.
In any case you probably will need some middle-ware application to facilitate communication between the two data stores, but at least on your local server the majority of work can be done through the Service Broker.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply