Sqlitestudio How to use

How to use Sqlitestudio to quickly import export data in SQLite:

First, because it is. NET project to Android, the original database using SQL Server, because the same part of the project or need to use the original data table structure, in order to reduce duplication of work, the table in SQL Server directly converted to SQLite, the current use of the conversion tool is "convert SQL Server db to SQLite DB "

In SQL Server address, enter the SQL Server instance addresses using the default address "." The native mode database instance click on the "Set" button on the right

The list of available databases under this instance appears on the right side of select DB, select the database you want to convert

"SQLite Database file path": Select and create a converted SQLite database file store path and name

Click "Start the conversion process" to start the transformation

Select the table to convert directly to the "OK" conversion

Once the conversion is complete we use "Sqlitestudio" to open the Sqlitestudio "database"-"Add Database"

Select the exported database file to open directly.

In Sqlitestudio you can create and modify tables or execute SQL statements that can basically meet your common needs

Sqlitestudio Export table data directly right-click Export table default format CSV file

Import Table Data:

Right-table name "Import data to Table"