Android Development Notes: SQLite import and export data

SQLite is the most convenient database in Android. Now let's take a look at how 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"

Official download updates are available in codeproject:

The usage is very simple: installation is not required, and then run “converter.exe directly after decompression"

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" (you can also use other sqlite visualization tools. I am used to using this tool, which is small in multiple languages and does not need to be installed): Official download

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"