Transfer Files with FTP

Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

You can use Toad's FTP (File Transfer Protocol) tool to transfer scripts, reports, or other files. Toad supports FTP and secure FTP (SFTP) file transfers. You can also specify a proxy server for an FTP connection.

To create an FTP connection

Select View | FTP Connections.

Click in the FTP Connections toolbar.

Enter the connection information. Review the following for additional information:

General tab	Enter the FTP connection information.
Protocol	Select the type of FTP connection.
Authentication	If using SFTP, select the type of authentication to use.
Private key file	If using a Private Key file, browse to and select the file.
Passphrase	If you are using an encrypted Private Key file, enter the passphrase here.
Proxy tab
Enable proxy	Select to enable the specified proxy.
Type	Select the proxy type.
Address	Enter the proxy server address.
Requires authentication	Select if the proxy server requires authentication. Enter the authentication information.
Advanced tab
Local	Specify the default local directory that you want to associate with this connection.
Remote	Specify the default remote directory that you want to associate with this connection.
Restore directories on reconnect	Select to automatically open the specified local and remote directories when reconnecting.
Test	Click to test the connection.

Click Connect to save and open the specified connection.

Note: You can click Save to save the connection without connecting.

To transfer a file using FTP

Select View | FTP Connections.

Select a connection and click

to connect.

In the FTP window, do one of the following:

To transfer a file to the selected remote directory...	Right-click the file in the local directory and select Upload.
To transfer a file to the selected local directory...	Right-click the file in the remote directory and select Download.

Tips:

You can view the progress or cancel an upload or download from the Background Processes window (View | Background Processes from the menu).

You can add an FTP connection to the Project Manager or to an Automation script. See Project Manager for more information. See Automate Tasks for more information.