Table of Contents

Search

  1. Preface
  2. Informatica Managed File Transfer Welcome Overview
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Switch Database

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.

0 COMMENTS

We’d like to hear from you!