Thread: Upgrading an existing database structure

Upgrading an existing database structure

From
Chitra Creta
Date:

Hello all,

 

I am interested in knowing how to upgrade a database structure on an existing database.

 

I have a script that creates and alters tables, columns and data. When this script is run, errors are thrown for already inserted tables, columns and data. Anything that is not found in the existing database is then executed. This prevents existing data to not be wiped out. Does anyone else have a better way of upgrading a database structure on an existing database?

 

Thanking you in advance.