SQL Server

Sync an FTP Directory Tree Down to Local

Demonstrates the Chilkat Ftp2.SyncLocalTree method, which synchronizes the remote tree rooted at the current remote directory into a local directory. The first argument is the local root and the second is the download mode, which selects which files are transferred (all, only-missing, only-newer, different-size, and so on).

Note: The local paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background: Where DownloadTree copies everything, SyncLocalTree transfers only what the mode says needs updating — the key to fast incremental refreshes that skip unchanged files. Timestamp-based modes rely on comparable clocks between systems, while the size-difference modes catch changed files even when timestamps are unreliable across platforms. Mode 99 flips the direction entirely, deleting local files absent from the server. Use GetSyncedFiles afterward to see exactly what changed.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Demonstrates the Ftp2.SyncLocalTree method, which synchronizes the remote tree rooted at the
    --  current remote directory into a local directory.  The 1st argument is the local root and the
    --  2nd is the download mode.

    DECLARE @ftp int
    EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @ftp, 'Hostname', 'ftp.example.com'
    EXEC sp_OASetProperty @ftp, 'Username', 'myFtpLogin'

    --  Normally you would not hard-code the password in source.  You should instead obtain it
    --  from an interactive prompt, environment variable, or a secrets vault.
    EXEC sp_OASetProperty @ftp, 'Password', 'myPassword'

    EXEC sp_OAMethod @ftp, 'Connect', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    EXEC sp_OAMethod @ftp, 'ChangeRemoteDir', @success OUT, 'public_html'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    --  Download mode selects which files are transferred:
    --    0 = all selected files
    --    1 = files missing locally
    --    2 = missing locally, or newer on the server
    --    3 = only files that exist locally and are newer on the server
    --    5 = missing locally, or a different size
    --    6 = missing, different size, or newer on the server
    --   99 = do not download; delete local... (see docs)

    DECLARE @mode int
    SELECT @mode = 6
    EXEC sp_OAMethod @ftp, 'SyncLocalTree', @success OUT, 'qa_output/site', @mode
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    PRINT 'Remote tree synced to local.'

    EXEC sp_OAMethod @ftp, 'Disconnect', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ftp
        RETURN
      END

    EXEC @hr = sp_OADestroy @ftp


END
GO