Subscribe to our news:

 Partners
 Testimonials
Jacob Lyohne, Director of Development: "Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
More
Add your opinion
 Customers
|
SQLite Maestro online Help
Get SQL Dump
Get SQL Dump Wizard allows you to export data from a table or a query result to the SQL script as a number of INSERT statements.
In order to get a SQL dump from a table or a query:
• | open the table in Table Editor or open and execute query in SQL Editor or Query Builder; |
• | open the Data tab or the Result tab respectively; |
• | use the Get SQL Dump item of the Navigation Bar. |
See also: Export Data Wizard, SQL Script Editor

|
 Company news 
May 5, 2021
New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.
Nov 14, 2016
New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.
Jan 12, 2015
New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.
 Feature of the day
SQLite Maestro provides an ability to export your data to any of 14 available data formats.
All editors of SQLite Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.
|
|