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 >