Replicating tables from remote to local database

  • I have three tables on a remote database that I would like to synchronize with a local database.  What is the easiest way to accomplish this task?

     

    SQL2DAY

  • Hi,

    That really depends on how uptodate you want the local database. Also how big the tables are and what sort of connection you have to the remote database.

    So a few of the questions you should ask yourself are;

    Are there any updates being made ? If so at what end and at what frequency?

    How big are your tables ? (Snapshot replicaton will give you the least grief but does a complete copy)

    How fast is your connection? Is is reliable ? (Merge replication will sustain connection downtime without breaking...but this is a bit more involved.

    HTH

    Graeme

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply