# Great SQL Tool

<datetime class="hidden">2004-01-07T00:00</datetime>
<!-- category -- mostlylucidcouk, Imported, Database, Tools -->

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](http://www.adeptsql.com/sql_compare_tool_overview.htm) 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...