Storage process conversion method and device

Abstract

The present disclosure relates to a conversion method and device for stored procedures. The method includes: obtaining the name of the first-type stored procedure from the first-type database; according to the name of the first-type stored procedure, reading the corresponding first-type stored procedure in the first-type database a code and a first input parameter; converting the first input parameter and the first code into a second input parameter and a second code compatible with the second type of database; according to the second input parameter and the The second code generates a stored procedure of a second type. The technical solution can automatically and quickly convert the first-type stored procedure in the first-type database into the second-type stored procedure without human participation, so as to improve user and developer experience.

Description

technical field [0001] The disclosure relates to the technical field of databases, in particular to a method and device for converting stored procedures. Background technique [0002] At present, the LNMP architecture has become the most mainstream development model in the Internet industry. When choosing a database for most projects, they usually choose the MySQL open source database, because it is free to use and the source code is open. Users can even directly modify and submit relevant codes. At the same time, there is no technical control by a certain manufacturer, so it will greatly facilitate developers. [0003] However, some projects still use other commercial closed-source databases due to technology selection at the start of the project or other reasons. However, when there are performance problems or bugs in the closed-source database, you can only find a solution from the manufacturer or purchase a newer version of the database software. Therefore, in terms of ...

AI Technical Summary

Problems solved by technology

[0006] 1. tsql2mysql has been developed for a long time, and can only deal with specific writing and standard style SQLServer stored procedure codes. However, with the continuous release of new versions of SQLServer and MySQL, tsql2mysql has been unable to keep up with the development of technology, and has been unable to recognize many new syntaxes. And conversion, does not support the new syntax of some stored procedures, and cannot recognize some newly added functions, especially for some functions that can only replace the name, but cannot really convert the parameters. In fact, encountering such functions will cause Converted code doesn't work properly

[0007] 2. There is no syntax compatibility conversion for SQL, such as rowcount and limit when turning pages;

[0008] 3. Due to the loose syntax requirements of SQL Server stored procedures, developers can use many non-standard styles. When encountering such random code writing, the conversion work will not be completed normally.

Images