[AccessD] Database Comparison Tool

No, I was using the version for Access XP.  It drove me nuts, frequently
blew up, and would sometimes simply refuse to recognize the requests
that it had just handled.  I have a bias against FMS software, which I
think is wildly overpriced anyhow, but this did nothing to change my
opinion.

Charlotte Foust


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


...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
> 


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