Post reply

auto tables's data synchronization

  • October 31, 2011 at 1:50 am

    #262170

    Hello

    I have ms access, which is having around 20 tables,

    with same structure, i have some tables in my sql server 2008 r2.

    Now, end users is using ms access to enter data and update data.

    I want to auto synchronize these data to sql server, whenever changes made in ms access..

    question 2.

    same auto synchronization, i want with sql server to sql server

    but on remote server..

    Regards

  • October 31, 2011 at 3:14 am

    #1400963

    1. Instead of saving to ms acces, have msaccess link your tables

    2. Have a look at replication (some tables)/mirroring (whole database)

  • October 31, 2011 at 3:21 am

    #1400969

    Replication would do for you.

  • November 1, 2011 at 1:14 am

    #1401434

    can you show me steps to do so,

Viewing 4 posts - 1 through 3 (of 3 total)

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