dbForge Data Pump for SQL Server is a powerful SSMS plug-in for SQL Server database population from various file formats. Additionally, it can be also used for exporting database data to a number of file formats. Some of the formats include text, Excel and XML. Templates are also supported for saving import and export settings.
When importing the data, you can configure many options as to how the data should be imported. You can, for instance, import the data to new tables or update existing ones. You also get to preview import file, choose which columns you want to import, and set other rules for how the data should be imported. You will be also able to save these settings for later use, in the Template (.dit) file.
When exporting the data, there are also many options you can set, for how the data will be presented and formatted in the exported file. Data can be exported from tables, views or queries. You can choose which columns and also which rows you want to export. You can either export all rows, selected rows, or a range of rows. All this export settings can be saved to a Template (.det) file, and used for further data exports. There are also more file formats to choose from, compared to when importing the data.
Overall, a very handy utility for exporting database data to a number of file formats. It also includes a lot of options for data importing, and thus greatly simplifies the process of database population. All the latest versions of SQL Server and SSMS are also supported.
