User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Switch Database

The

Managed File Transfer

database can utilize (connect to) one of the following database types for storing its configuration settings and application data:

Microsoft SQL Server - SQL Server 2008 R2 and later

Oracle - 11g R2 and later

The Switch Database function provides a guided process for changing the

Managed File Transfer

connection to one of these supported databases. This function creates the necessary tables and indexes, as well as migrating the existing

Managed File Transfer

data to the new database.

The Switch Database process is comprised of six steps. No changes will be applied until clicking the Finish button on the final step. After the Switch Database Wizard completes, you will need to restart

Managed File Transfer

in order to connect to the new database.

A database switch may take several minutes to execute if you plan to migrate the existing data from the current database. The data migration time will depend on the amount of data in the current database.

Only perform the database switch when no other users are using

Managed File Transfer

. The migration will stop Monitors, Scheduled Jobs, and Projects from executing. Additionally, all services, Web User sessions, and the

Managed File Transfer

Gateway connection will be stopped.

Database Configuration

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal