To export database schema and data to the specified location, do the following:
- Open Veeam Explorer for Microsoft SQL Server.
- In the navigation tree, select the required database and click Export Schema > Export database schema and data ..., using the shortcut menu or use the corresponding ribbon menu command.
- Proceed to the Step 1. Specify the Restore Point step of the export wizard.
When exporting schema objects, Veeam Explorer for Microsoft SQL Server creates a single .SQL script for all selected objects. To import exported objects, you can run this script on a target database. When exporting data (as tables), Veeam Explorer creates a pair of files (.TXT and .FMT) for each exported table. To import data tables, use the standard SQL Server bcp.exe utility (see https://msdn.microsoft.com/en-us/library/aa337544(v=sql.120).aspx for details).