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...
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 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文件生成方法,其特征在于,包括以下步骤:步骤一数据配置,匹配 |
---|