How to update database schema without dropping tables?

What you're looking for is the ALTER TABLE, ADD statement.

What you're looking for is the ALTER TABLE, ADD statement. msdn.microsoft.com/en-us/library/ms19027... ALTER TABLE Comments ADD newColumn INT As an example. The question, then, becomes how do you do this for a whole database?

What you will need is to have a SQL Delta tool. (Here's an example of one sqldelta.com/ but there are others! ) This tool will then generate an update script that you can run on your old database to bring it up to sync with your latest database.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.