Sqlitestudio How to use

Source: Internet
Author: User
Tags sqlite sqlite database sqlite db table name

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"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.