SQLSever-based automatic upgrading method for database structure

The invention discloses an SQLSever-based automatic upgrading method for a database structure. The method comprises the following steps: generating a new version of database script by an SQLSever database tool; traversing an old version of database table and the new version of database script, carry...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: SONG SHEPING, ZHANG BIN, SHANG HUILING, LEI YAGE
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses an SQLSever-based automatic upgrading method for a database structure. The method comprises the following steps: generating a new version of database script by an SQLSever database tool; traversing an old version of database table and the new version of database script, carrying out comparison processing on the new version of database script and the old version of database table, and obtaining the processed data; and modifying the old version of database table according to the processed data. According to the SQLSever-based automatic upgrading method for the database structure, database upgrading can be automatically carried out; and the problem that a user cannot operate an sqlsever tool to carry out backup, restoration and upgrading is solved.