Import Database Nightly?

Discussion in 'OT Technology' started by sablehonda, Nov 28, 2003.

  1. sablehonda

    sablehonda New Member

    Joined:
    Sep 21, 2002
    Messages:
    8,514
    Likes Received:
    0
    Location:
    Chicago
    Say you have identical Access databases (same schema) on different systems. How would you go about merging them nightly to 1 central database?
     
  2. Astro

    Astro Code Monkey

    Joined:
    Mar 18, 2000
    Messages:
    2,047
    Likes Received:
    0
    Location:
    Cleveland Ohio
    Data replication... But Access doesn't support that. MS SQL Server does.

    Since Access doesn't natively support it, you could build your own. But if you don't know anything about replication, then you'll need to spend some time learning about dirty records and decide the rule set you want to use whe you need to update a record that has been changed in both databases.
     

Share This Page