I currently use Erwin as my database comparison tool (the SQL 7 version even though I'm using SQL 2K). I've used the SQL 2K version of Erwin in the past and from what I recall it suffers from poor script generation in the same way as the SQL 7 version. e.g. not taking into account permissions on stored procedures / dropping and rebuilding tables when it doesn't need to etc. I've now got to keep half a dozen or so different versions of a database up and running and am looking for a better comparison tool to aid in generating "version to version scripts". i.e. generate a script to take a database from one version to the next. Does anyone have any experience using the multitude of tools available?