August 23, 2013 at 2:59 pm
Hi,
what are the best options to sync one table between two separate SQL Server databases(Same domain). Thanks.
August 23, 2013 at 4:10 pm
Change tracking?
ADO Sync Framework?
Merge replication?
BULK INSERT?
SSIS?
Triggers?
Service Broker?
There are plenty of options, but which is the best depends on your situation - which we know nothing about.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 4:14 pm
Red Gate's SQLCompare and SQLDataCompare?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply