Moving SQL Server Objects
Well, I'm preparing for a significant move to production tomorrow morning, including a bunch of new database code. I really can't remember how I was confident that I moved everything before I discovered Red Gate's SQL Compare and SQL Data Compare. These tools make database migration a breeze, and I recommend them for anyone who needs to move DDL or domain data between environments.
I still need an easy way to archive database code along with the rest of the source for my application. VS 2003 just seems to take forever to script all of my objects. Maybe VS 2005 and Team System will have something for me, but for now, I'm busy doing billable work, so I don't have much time to explore.