Depending on which database you are using you can normally do something like this programmatically in the database itself.
There is a good article on how to compare the database schema of two different databases for SQL server. http://www.sqlteam.com/item.asp?ItemID=7269 Once you have the Schemas matching it is fairly straightforward to write queries to test if the data is different. How much work you want to put into it depends on how often you need to check the databases, but this approach is handy for website upgrades and distributed development environments. Spike >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Taco Fleur >Sent: Tuesday, March 30, 2004 3:13 PM >To: CFAussie Mailing List >Subject: [cfaussie] [OT] SQL Compare > >Anybody using SQL Compare tools? > >I am using Red Gate SQL Compare for scripting database and >data changes, but it doesn't seem to work properly, just >wondering if there are any other suggestions? > >Taco Fleur >07 3535 5072 > >Tell me and I will forget >Show me and I will remember >Teach me and I will learn > >--- >You are currently subscribed to cfaussie as: >[EMAIL PROTECTED] To unsubscribe send a blank email to >[EMAIL PROTECTED] >MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia >http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
