| Author |
Message |
graffiti
Joined: 05 Feb 2007 Posts: 1
|
Posted: Mon Feb 05, 2007 8:04 am Post subject: MS Access |
|
|
| Do you support MS Access? |
|
| Back to top |
|
 |
Dave Mellors
Joined: 01 Feb 2007 Posts: 31
|
Posted: Mon Feb 05, 2007 11:27 am Post subject: |
|
|
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 |
|
| Back to top |
|
 |
lc6529
Joined: 18 Apr 2007 Posts: 20
|
Posted: Wed Apr 18, 2007 7:52 pm Post subject: MSAccess And SQL Data Compare |
|
|
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. |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group