I am going to need to synchronize several tables in a couple of local databases with an SQL DB that Amazon will be hosting for us starting next week. Is this difficult? Will we require any additional software or is there some facility built into MS SQL already?
Performance, as always, is crucial so I can't be sending large chunks of the DB back and forth, just the changes. Oh, and it needs to be bi-directional, of course.