Subscribe to our news:
![](/i/subscribe-bottom.gif)
![](/i/arr-open.gif) Partners
![](/i/arr-open.gif) Testimonials
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
More
Add your opinion
![](/i/arr-open.gif) 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
![](/data/help/sqlite/maestro/05_05_03_sql_dump_options.png)
|
![](/i/arr-open.gif) Company news ![](/i/rss.gif)
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.
![](/i/arr-open.gif) Feature of the day
All editors of SQLite Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.
SQLite Maestro: You can save frequently used queries to the database profile and use them as usual database objects.
|
|