EMS DB Extract for SQL Server is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract process you can select objects and data tables for extract and tune many other extract options. DB Extract for SQL Server includes a graphical wizard, guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.
First of all you must have an opportunity to connect to some local or remote SQL Server. Besides you need your computer to satisfy the system requirements of EMS DB Extract for SQL Server.
You can configure the template files for each table or export type visually using the DB Extract Wizard. Set the required export options on Step 3 of the wizard and click the ‘Save Extract Options‘ button. All the options will be saved to the template file, which can be used by the console application.
EMS DB Extract for SQL Server includes some additional features, which are not available in SQL Manager for SQL Server, such as:
- extracting metadata from several databases on one host;
- console application for executing extract in one-touch;
- faster execution speed.
