How to upgrade from WS_FTP Server 6.0 to WS_FTP Server 6.1

Product: WS_FTP Server and WS_FTP Server with SSH
Version: 6.1
Platform: Windows 2000 Server SP4, Windows XP SP1 or later, and Windows 2003

Upgrading to 6.1

6.1 supports additional options for web server and database support. While 6.0 supported only Microsoft IIS as its web server, 6.1 has the additional option of using the WS_FTP Web Server.

Similarly, 6.0 only supported PostgreSQL as its database. 6.1 additionally supports Microsoft SQL Server.

This means that there are four different possibilities when you upgrade from 6.0 to 6.1:

  • Keep Microsoft IIS with a PostgreSQL Database (this is the quickest and easiest option, as you will not need to change from 6.0's database and web server),

  • Use Microsoft IIS with a Microsoft SQL Server Database,

  • Use the WS_FTP Web Server with a PostgreSQL Database, or

  • Use the WS_FTP Web Server with a Microsoft SQL Server Database.

The following table summarizes the installation steps needed in each case:

WS_FTP Server 6.1 with...

Microsoft IIS

WS_FTP Web Server

PostgreSQL Database

Run the 6.1 install and upgrade. Nothing further is needed.

1) Uninstall WS_FTP 6.0. (Be sure to choose the option not to delete the present database.)

2) During the uninstall make sure you choose to NOT remove the WS_FTP Server configuration data from the data store and NOT remove the PostgreSQL database

3) Run the 6.1 install, choosing an Express installation.

Microsoft SQL Server

1) Run the 6.1 install and upgrade.

2) Use the dbconfig utility to migrate the old PostgreSQL database to Microsoft SQL Server.

1) Uninstall WS_FTP 6.0. (Be sure not to delete the present database.)

2) During the uninstall make sure you choose to NOT remove the WS_FTP Server configuration data from the data store and NOT remove the PostgreSQL database

3) Run the 6.1 install, choosing a custom installation with WS_FTP Web Server and PostgreSQL options.

4) Use the dbconfig utility to migrate the old PostgreSQL database to Microsoft SQL Server.


You can find instructions for installing and uninstalling WS_FTP Server in the
WS_FTP Getting Started Guide.

To migrate to SQL Server, use the dbconfig tool:

  1. Launch the dbconfig tool (the default location is C:\Program Files\Ipswitch\WS_FTP Server\Utilities\dbconfig.exe). The PostgreSQL Configuration dialog opens.

  2. Click the Migrate button. The Microsoft SQL Server Configuration button opens.

  3. Enter the information for your SQL Server Configuration. Enter the Server Name, Port, Username, and Password in the appropriate fields.

  4. Click OK. The Migrating from PostgreSQL to MS SQL Server dialog opens. This dialog displays entries from the install log file, indicating migration progress. If the log indicates that all operations were successful, the MS SQL Server migration is complete. The migration application will restart the WS_FTP Server, SSH Server, the web server, and Ipswitch Notification services.

Note: The migration process does not include merging database records. If you point to a SQL Server installation that already has a WS_FTP database present, you will be given the option of overwriting the existing data, or connecting to the database's present data.

 

Document #: FS-20071031-CW01.htm
Revision Date:  11/28/07
 






 


Return To KnowledgeBase Search Page