I've new requirement in my project. Could any tell me how to compress and uncompress the file.

1. First, I've to BCP the data from database to flat file in the
   destination folder
2. Once that is done, I've to compress the entire folder
3. Also, i need to uncompress the folder when i want restore the
   data back into the database table.

I really don't know how to accomplish the task. Please provide me some sample code which would help me in understanding the task more clearly.

Thanks in advance
Chandra


Chandru

__________________
Thanks,
Chandra

The most popular compression format on the PC is ZIP. There are lots of compression tools out there. Some have command line interfaces so you could easily run them programmatically.

The .NET framework has compression classes in it. There is also a 3rd party .NET library for zipping that works well: http://www.icsharpcode.net/OpenSource/SharpZipLib/


-Peter

Rather than using third party tool, i would like to call ZIP Command line utility from SQL Server using XP_CMDSHELL. I'm also sure the ZIP Program should be installed in the server which is running SQL Server. Could you pls. tell me way to go further to achieve my task through this approach.

Chandru

The ZIP CLI program is 3rd party.

Yes, it would need to be installed.

What have you learned about the XP_CMDSHELL procedure so far?


-Peter