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...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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. |
---|