Upgrading a SQL DB and maintaining data integrity

Ok, we have a SQL DB and it has been tested and a fair amount of data has been entered into some of the tables.

On the development side of things we have added more fields and made a few changes to our database. We now need to upgrade the testing DB to the same spec as ours but maintain the data that has been entered into the test DB. Is there any way we can copy this data accross easily to our new upgraded DB??

All primary key ID's need to stay the same...

Any help is appreciated.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!