Guys,

I know somebody out there knows how to do this. I have a site set up in a staging / production environment. Both sites are on their own unique install with their own SQL database. I use SQL Server Management studio to copy the database from staging to production.. Works slick as hell.

I use a GREAT little file compare/sync utility I found to sync up the file & folder structure. http://www.scootersoftware.com/shop.php?bld=9222

The problem is, as people register on the site, fill out surveys, etc, there is data in the PROD database that is not in the DEV database. If I overwrite the entire database when updating the site, I lose all that data.

Any thoughts on how to update the PROD database without losing registration info, user accounts, passwords, logins, role assignments etc?

Any help would be greatly appreciated.

Thanks in advance!

Ian Robinson wrote ....Also, I think Red Gate has a SQL Compare utility that may come in handy if you'd rather buy software to address the issue. ...

I second Ian's suggestion we use Red Gates SQL Data Compare to move data between production and development and vice versa.  Now where was that referral code ;)

Antony

I actually use a different tool.

Apex SQL-Diff

It deos the same as the Red Gate tools but I find it provides more flexibility in its options.