c# - Which one is the best method to replicate a database in SQL Server? -

c# - Which one is the best method to replicate a database in SQL Server? -

i wondering 1 best way replicate info of database another.

i have database in 1 computer , 1 receives transactions. need send info server (in same local network) modified value (i need add together 11 years timestamp value).

so looking options case, can develop windows service don't know if sql server replication can me or if there alternative kind of magical trigger can that.

i'm using sql server 2005 on windows server 2003 r2.

this link should help you:

selecting appropriate type of replication

quoted summary link:

microsoft sql server offers 3 types of replication. each type of replication suited different application requirements. depending on needs of application, can utilize 1 or more types of replication in topology:

snapshot replication transactional replication merge replication

i replicate database (transactional) , utilize log shipping update replicated database (on sec server) latest info changes (from primary server) utilize stored procedure running sql agent job update fields need.

i not fan of triggers can end having triggers activating other triggers , takes milliseconds run can take seconds , if have big volumes of info can painful (i manage scheme has issue - replaced thankfully)

hope helps , if have follow questions i'll happy help.

c# sql sql-server database triggers