Printable View
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?
Have you look at Red Gate SQL Packager? works pretty sweetly
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
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.
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.