how to fire window service to update local database when remote database table being updated?

Asked Dec 18 '12 at 17:43

Active May 20 '13 at 15:20

Viewed 507 times

Below problem I searched in "Stack Overflow" but don't get relevant information...

I am using .Net(C#) and SqlServer2008. My problem is below:

I have a remote Database by name 'RemoteDB' that have a table by name 'UserTBL' Table
I have a loca Database by name 'LocalDB' that have a table by name 'UserTBL' Table with same structure as in remote database table
I have a window service for updating local databse Table 'UserTBL' when Remote Table 'UserTBL' is updated ie. I have to reflect same changes in local table 'UserTBL' that were made in remote table.
window service should be executed only when remote table gets updated.

I am trying to resolve above problem but unable to resolve.

Please guide me how to start to do it...If you will place Code Samples or link it will be very helpful for me...

edited May 20 '13 at 15:20

dsolimano

asked Dec 18 '12 at 17:43

Shoeb

Read this post http://stackoverflow.com/questions/2152516/c-sql-database-listener-help-needed – johan Dec 18 '12 at 17:46
http://msdn.microsoft.com/en-us/library/t9x04ed2(v=VS.80).aspx – paparazzo Dec 18 '12 at 18:16

0 Answers0