[AccessD] Database Comparison Tool

William Hindman wdhindman at bellsouth.net
Mon Nov 21 17:55:39 CST 2005


...hhhmmm ...surprising ...upon the occasions when I've needed to use it, it 
worked just as promised ...are you using one of the non-Access versions?

William

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, November 21, 2005 6:25 PM
Subject: Re: [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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list