Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

share|improve this question
    
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.