How to Use sqlitestudio

How to Use sqlitestudio

 

How to Use sqlitestudio to quickly import and export data in SQLite:

First, because. NET project to Android, the original database uses SQLSERVER, because the same part of the project structure still needs to use the original data table structure, in order to reduce repetitive work, directly convert the SQLSERVER table into SQLite, the current conversion tool is "Convert SQL Server DB to SQLite DB"

In "SQL SERVER Address", enter the SQLSERVER instance Address. Here, use the default Address ".", that is, the local database instance. Click "Set" on the right.

The list of available databases under the instance is displayed on the right side of "Select DB". Select the database to be converted.

"SQLite DataBase File Path": select and create the converted sqlite DataBase File storage Path and name

Click Start The Conversion Process to Start The Conversion Process.

Select the table to be converted and convert it with "OK"

After the conversion is complete, use "sqlitestudio" to open sqlitestudio "Database"-"add Database"

Select the exported database file and open it directly.

In sqlitestudio, you can create and modify tables or execute SQL statements to meet common requirements.

Right-click sqlitestudio to export table data and choose export table & gt; default format CSV file

Import table data:

Right-click the table name "import data to table"