This topic describes how to obtain files to be uploaded for offline assessment.
Supported file types
At present, you can upload SQL, MyBatis, and iBatis files for compatibility assessment, which can cover most mainstream frameworks. You can upload files for compatibility assessment based on the actual situation. You can delete all files and generated reports at any time.
Obtain SQL files
SQL files are standard text files in which each DML or DDL statement ends with a line break followed by double dollar signs ($$). The compatibility assessment service identifies each SQL statement for assessment based on double dollar signs ($$).
Here is a sample SQL file:
SELECT * FROM A
$$
CREATE TABLE A(
INT a
)
$$
SELECT * FROM B
$$
Obtain MyBatis or iBatis files
MyBatis and iBatis files are respectively XML configuration files of the MyBatis and iBatis frameworks. After you upload a MyBatis or iBatis file, the compatibility assessment service will parse the XML configurations and extract the original SQL statements for assessment.