Competition: What’s your favorite Redgate tool? Enter now.

MS Access

graffitigraffiti Posts: 2
Do you support MS Access?

Comments

  • No, Data Compare does not support Microsoft Access.

    Data Compare is supported on SQL Server 7 and above.
  • You can get around the access limitation by doing the following:

    #1: Setting up the Access database as a LINKED server to your SQL server.

    #2: Setup a SQL Database that consists of VIEWS to each table in your access database.

    I have done this and can sync the access database to my sql database.
Sign In or Register to comment.