Depending on which database you are using you can normally do something like this programmatically in the database itself. ---------------------
Using MS SQL. I know I can script the whole database easily from within the Enterprise Manager Console, but is this the way to go though? I know real DBA's suggest using a scripting tool, are they wrong? --------------------- 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. --------------------- Hmm, how would you go about writing a query to test about 40 tables and more than 60.000 records and take across any data changes? I sure as hell would not like to get that job, I only have 2 hours to get this done though. --------------------- 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. --------------------- Well before go live I reckon it needs to be done at least 5 times in one week......... --- 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
