MS Access

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

MS Access

Postby graffiti » Mon Feb 05, 2007 8:04 am

Do you support MS Access?
graffiti
 
Posts: 1
Joined: Mon Feb 05, 2007 6:43 am

Postby Dave Mellors » Mon Feb 05, 2007 11:27 am

No, Data Compare does not support Microsoft Access.

Data Compare is supported on SQL Server 7 and above.
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
 
Posts: 31
Joined: Thu Feb 01, 2007 6:03 pm

MSAccess And SQL Data Compare

Postby lc6529 » Wed Apr 18, 2007 7:52 pm

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.
lc6529
 
Posts: 20
Joined: Wed Apr 18, 2007 7:32 pm


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests