Method for generating upgrade SQL (Structured Query Language) file of relational database

The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LIAO YONGFEI, DI BOWEN, DONG TUNAN, XIE YUSHEN, CHANG LEI, LI GUOHUA, ZHANG SHUO
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 a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in a data table; step 2, file extraction: extracting the structural data and the initialized data of the database obtained in the step 1 into an SQL (Structured Query Language) file; and step 3, file comparison: comparing the data structures and the initialized data in the two SQL files obtained in the step 2, and converting the SQL files into upgrading SQL files. According to the method, errors possibly caused by manual recording of database designers and difficulty brought by database reconstruction are avoided, the problem that the database is not updated in time is fundamentally solved, and the probability of problems occurring during software upgrading is reduced. 本发明公开了一种关系型数据库升级SQL文件生成方法,其特征在于,包括以下步骤:步骤一数据配置,匹配