Unzipping a zipped bak file

Hi,

I need to upload a bak file.

I would like to zip it and upload it.

Is there any tool that will allow me to unzip the file so that I can do the restore on the bak file.

Thanks,

Will

 

This is pretty much something you would have to do programmatically or using a third party tool. You might want to take a look at the following forum post:

http://forums.asp.net/t/1428916.aspx

 

Hi,

Thanks for that.

I found a similar post about unpacking zipped files remotely. It had an example that ran straight out of the 'box' ....

http://basgun.wordpress.com/2008/02/08/extract-unzip-zip-aspnet-vbnet/

It did not work on large 22mb zip files but was good for smaller stuff. But hey ho I learnt something and I may use it latter.

In the end I used a combination (The data I was trying to get onto one DB turned out to be in 2 other DBs) of the SQL Import Export Wizard (had forgotten about this) and the fact that the 2 databases were on the same DASP SQL Server meant that I could run an insert query between them (http://community.discountasp.net/showthread.php?t=11135).

Thanks,

Will

 

Way to go Will1968, I'm gonna hold on to that one as a reference, glad to hear it all worked out.

 

Wow...That is cool.