Howdy, Stranger!

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

Categories

Upgrading a SQL DB and maintaining data integrity

sg123sg123 Member Posts: 11
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.

Thanks
Simon

Comments

  • Andre YoungAndre Young USAMember Posts: 0

    ___ / http://forcoder.org / free video tutorials and ebooks about || Perl PHP Ruby R Swift Java C++ Objective-C MATLAB Python C PL/SQL Visual Basic .NET Visual Basic C# JavaScript Assembly Scratch Delphi Go Alice Scala Julia Crystal Kotlin Transact-SQL Awk FoxPro Ada Erlang Prolog LabVIEW Rust F# Bash Clojure D VBScript Lisp Apex Logo Dart COBOL SAS Fortran ML Hack Lua Scheme ABAP ||

Sign In or Register to comment.