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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-05 : 08:09:14
|
| Andrew writes "I manage integration projects between a packaged MS SQL Server application and other systems. To date, the integration projects have involved either scheduled (e.g. daily) or on-demand data transfer from / to the packaged application database.Recently, I have been asked to provide an integration using event-driven data transfer. One of the events is a user changing the value of a specific field in a record in the packaged application (which will result in that record being sent out as an XML document).Since we are working with a packaged application, which supports multiple separate databases (each one having the same schema), we do not want to add anything (tables, stored procedures, triggers) directly to the packaged application database (for maintainability reasons , etc.).Accordingly, do you know of a method / product that can provide ‘external / remote’ trigger functionality (monitor and detect changes in the data in an external / remote database in (near) real-time)?I have designed a couple workable solutions, but trigger functionality would probably be the best solution. Thank you." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-05 : 09:38:35
|
quote:
Originally posted by AskSQLTeam
Since we are working with a packaged application, which supports multiple separate databases (each one having the same schema), we do not want to add anything (tables, stored procedures, triggers) directly to the packaged application database (for maintainability reasons , etc.).
Good idea...not to mention invalidating any support agreement you might havequote:
Accordingly, do you know of a method / product that can provide ‘external / remote’ trigger functionality (monitor and detect changes in the data in an external / remote database in (near) real-time)?
Keep a history copy of the data on your server and build a delta process every 10 minutes? Not very effecient..quote:
I have designed a couple workable solutions, but trigger functionality would probably be the best solution. Thank you."
But the triggers would have to be applied to the 3rd party..which direction are the changes flowing?bi-directional...right?Brett8-) |
 |
|
|
|
|
|
|
|
'External / Remote' Triggers