[AccessD] Database Comparison Tool

I have to say that I have not been impressed by the FMS total detective
and wouldn't pay freeware fees for it.  It is crochety and I found much
of the information everything but what I needed.  Different strokes, I
suppose.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Saturday, November 19, 2005 3:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Database Comparison Tool


http://www.fmsinc.com/products/detective/index.html

...expensive but worth every penny imnsho ...hth :)

William

----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, November 19, 2005 5:50 PM
Subject: [AccessD] Database Comparison Tool


>I have the SQL bundle from Red Gate Software, which includes SQL 
>Compare
>and
> SQL Data Compare. Both work wonderfully and I use them every day.
However,
> they work with SQL and not with MDBs. Is there an equivalent tool for 
> MDBs?
> By equivalent, I mean that said tool should list the a) structural
> differences and b) the data differences between db1 and db2; and
further,
> that the databases can be synchronized in either direction. I.e., a
column
> has been added to a table in db1: add it to the same table in db2;
said
> column has been populated with values: in pass two (sql data compare),
> replicate the values; in db1 two rows were added which are not present
in
> db2: copy those rows to db2.
> Any such tool exists for MDB?
> TIA,
> Arthur
> P.S.
> I realize that one way to get there is to upsize db1 and db2 to SQL,
then
> run the Red Gate tools. But wonder if there is something MDB-specific.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com