I'm currently generating an update procedure for an installed site - this involves generating a change script for the DB to make the deployed one the same as the new, modified one (yes, I know you should create change scripts as you go along...well I was on holiday for 2 weeks and the other developer on the project didn't). Anyway, if you have to do this on a reasonably large SQL Server 2000 Db, I can't recommend AdeptSQL Diff highly enough, I've tried 4 (count them, FOUR!) other products which claim to do this, LockwoodTech SqlDiff and Redgate Sql Compare being the two I can recall right now, and they failed miserably to do the updates I required - SqlDiff failed entirely with some odd error, Sql Compare generated a script which would never work oh, and they were both slow as hell! AdeptSQL Diff was VERY fast in comparison, had the best UI and actually worked...which is nice...