MSSQL Replace Database in Live Web App

Posted by casoninabox on Server Fault See other posts from Server Fault or by casoninabox
Published on 2010-03-13T08:53:55Z Indexed on 2010/03/13 8:55 UTC
Read the original article Hit count: 403

I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one.

My dev SQL instance is not the live one. I usually just make a backup of the new DB, blow the old one away and Restore my updated one. But now I have data I need to preserve.

Most of the current tables have changed, in that extra columns have been added, all existing columns are still there and unchanged.

I have access to Management Studio.

What is the right way to do this?

© Server Fault or respective owner

Related posts about mssql

Related posts about sql