Choose your database:

Partners

Customers

Become a customer

SQL Maestro Group / Products / MS SQL Server / MS Compact Maestro / Documentation

Buy

MS Compact Maestro online Help

Return to chapter overview

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.

•	Selecting fields to include in the result INSERT statement

•	Specifying dump options

See also: Export Data Wizard, SQL Script Editor

Return to chapter overview

News

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Sep 28, 2017

MS Compact Maestro 17.9 released

New version features updated data import and data export tools, colored tabs, enhanced data grids, performance and usability improvements, and a lot of other useful things.

Aug 5, 2013

MS Compact Maestro has been released

We are pleased to introduce a new member of Microsoft SQL Server tools family designed for SQL Server Compact database development and management.

Feature of the day

SQL Formatter

MS Compact Maestro allows you to tune up SQL scripts according to your preferences.

Database Designer

You can create ER Diagrams to represent objects in your SQL Server Compact databases in a couple clicks with Database Designer.