Post reply

create proc to ZIP the file using WinRAR

  • September 25, 2009 at 12:12 am

    #96328

    Friends,

    Need your help here.

    As we can have WinRAR.exe file and that we can execute fro procedure that will zip the source file.

    We will require some specific format to execute the file from SQL Server "SQL Command".

    Procedure should have parameter as @SrcFile ,@DestFile and that will ZIP the Source file to DestinationFile . as specified location in Parameter.

    Create Proc spZipFile

    @SrcFile varchar(1000), -- Location with File name

    @DestFile varchar(1000) --Location eith Filename.zip

    AS

    BEGIN

    /*

    CODE

    */

    END

    Thanks in Advance

  • September 28, 2009 at 12:24 pm

    #1059142

    See http://www.db-staff.com/index.php/microsoft-sql-server/62-dba-tips-Query to archive a backup file using winrar without access to the server desktop

  • September 30, 2009 at 2:42 am

    #1059848

    Oh Thank you for your reply.

    Pd.

  • October 2, 2009 at 2:17 pm

    #1061172

    Thanks for the link emily-1119612, it points to a very helpful website.

    -RP

  • October 8, 2009 at 3:41 am

    #1063323

    Jai ho.. Sambha....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply