BCPME make importing and exporting data to ASCII from SQL Server a breeze. It provides a wrapper around the Microsoft Bulk Copy Program that allows you to export a whole database or even a complete server in one operation. If you are moving data between versions of SQL or wanting to backup and reloaded tables quickly or load data into a warehouse you will find this application useful.
Easy to run from the command line to be able to run on a schedule.
Provides options to compress your data using ZIP or CAB compression to save disk space and make it easier to distribute your data.