up vote 1 down vote favorite
share [g+] share [fb]

We have a Microsoft Access 2007 database that we would like to mirror as SQL database (typically MSSQL or MySQL, but we are flexible here). The mirrored database is only used for read-only purposes. However, the mirror should be kept relatively up-to-date.

Is there any fully automated way to achieve this mirroring? (commercial tools would be OK too)

link|improve this question
100% accept rate
What is your actual scenario? What purpose is that SQL Server "mirror" of your A2007 database going to serve? – David W. Fenton Sep 28 '11 at 23:28
Scenario: legacy ERP based on Access holding sales data. Online sales data mirroring to enable Lokad.com to remotely grab the sales and offer web-based sales forecasts (dislaimer: I am working at Lokad.com). – Joannes Vermorel Oct 3 '11 at 6:43
Is the ACCDB/MDB file locally accessible ot the SQL Server? If so, why not mount it as a linked server, and the it will look like it's just SQL Server. – David W. Fenton Oct 5 '11 at 17:39
Unfortunately, the ACCDB/MDB file is NOT locally accessible from the SQL Server. – Joannes Vermorel Oct 10 '11 at 8:10
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.