create proc to ZIP the file using WinRAR

  • 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

  • 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

  • Oh Thank you for your reply.

    Pd.

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

    -RP
  • Jai ho.. Sambha....

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

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