SQL Server Change Tracking

[Aspnot]

I have a Dev and a Production environment. When I make changes to Stored Procedures or create new ones, I keep a list on my desk so that I know what to push out when I release the new version.

I have gotten tired of this approach and would like an automated system to do this. I could write something fairly quickly, but there must be something on the market that does this.

Can anyone provide me some guidance here?

[GaryMazzone]

Have you look at Red Gate SQL Packager? works pretty sweetly

[techgnome]

We use SQLDiff from Apex... http://www.apexsql.com/ point it at your dev for the source... your production for the target.... get the differences... then you can script the changes and run it to update the database.

-tg

[GaryMazzone]

basicly the same in SQL Packager... It just wraps it all in a .Net app that you can run. Nice simple front end. You can also use it to create a new database if you wanted to.

[Aspnot]

Wow. Those are really advanced. SQL Compare looks more like what I am looking for.

I'll take a look at the trial version.

Anything else cheaper? This has a ton of features that I will probably never use.