Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

MOVEit Automation Web Admin Help

Database

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Introduction
    • Overview
    • Key Features
    • Key Processing Concepts
    • Typographical Conventions
  • Web Admin UI
    • Web Admin UI Tour
      • Dashboard
      • Web Admin Tour
      • Individual Task - Quick Tour
    • User Access Control
    • In-App Notifications and Resource Center
    • Single Sign-On
      • Configure Single Sign-On (SSO)
      • Log On and Off Using Single Sign-On
    • Multi-Server Access
      • Switch Servers
      • Multi-Server Tabs and Windows
    • Common Activities
      • Searching
      • Filtering
      • Sorting
      • Quick Reference Common Activities
  • User Preferences
    • Time Display Format
    • Items Per Page
    • Home Page Preference
  • DASHBOARD
    • Welcome Pane
    • Task Runs Widget
    • File Activities Widget
    • Hosts Widget
    • Tasks Widget
    • Keys/Certs Widget
    • Most Active Hosts Widget
    • Most Active Tasks Widget
    • Watched Tasks Widget
  • TASKS
    • Task List
      • Task Schedule Status
    • Add a New Task
      • Add a Traditional Task
      • Add an Advanced Task
      • Add a Synchronization Task
        • Add/Edit Sync Folder A
          • Sync Folders - General Settings
          • Sync Folders - Host Override settings
          • Sync Folders - FTP - Additional Commands
        • Add/Edit Sync Folder B
        • View Sync Preview
        • Change Initial Run Options - Sync Task
        • Sync Tasks - Actions
        • Macro - Sending Sync Actions in Next Action Email
        • More About Synchronization
        • Synchronizing Content To or Between Multiple Remote Sites
        • Synchronizing Content To or Between Multiple Folders
      • Import Task
        • Rename Task Element
        • Remove Task Element
        • Resolve Duplicate Task Elements
        • Import Options
      • Minimum Task Configuration Requirements
    • Task Elements
      • View a Task
      • Add or Remove a Task from the Watch List
      • Task Source
        • Add/Edit Source - General settings
        • After Transfer settings
        • Source - FTP Additional Commands
        • Host Override Settings on a Source
          • Source - Local File System or UNC - Host Override Settings
          • Source - MOVEit Transfer Host Override Settings
          • Source - FTP Host Override Settings
          • Source - SFTP Host Override Settings
          • Source - Amazon S3 Host Override Settings
          • Source - Azure Blob Storage Host Override Settings
          • Source - SharePoint Host Override Settings
          • Source - Google Cloud Storage Host Override Settings
          • Source - OneDrive Host Override Settings
        • Source - POP3 General Settings
        • Source - POP3 After Transfer Settings
        • Source - POP3 Host Override Settings
        • Source - AS1 Settings
        • Source - AS2 Settings
        • Source - AS3 Settings
        • Editing Source Timestamps
      • Task Process
      • Task Destination
        • Destination - General Settings
        • Destination - Send as Email Attachment
        • Host Override Settings on a Destination
          • Destination - Local System Host Override Settings
          • Destination - UNC Host Override Settings
          • Destination - MOVEit Transfer Host Override Settings
          • Destination - FTP Host Override and Commands Settings
          • Destination - SSH/SFTP Host Override Settings
          • Destination - Amazon S3 Host Override Settings
          • Destination - Azure Blob Storage Host Override Settings
          • Destination - SharePoint Host Override Settings
          • Destination - Google Cloud Storage Host Override Settings
          • Destination - OneDrive Host Override Settings
        • Destination - AS1, AS2, AS3 Settings
      • File Loop (FOR)
      • Conditional Branch (IF block)
      • Send Email Step (advanced task)
      • Run Task Step
      • Disable Task Step
      • Next Action - Send Email
      • Next Action - Run Task
        • Using Error Macros in Next Action - Run Task
      • Task Schedule
        • How Schedules Work
      • Use Process as Destination
      • Add/Edit a Date List
      • Update Original (rename or delete)
      • Multiple Sources, Destinations, Processes, and Schedules
      • View Task Logs
        • Disable/Enable Task Logs
    • Task Settings and Parameters
      • Edit Task Info - General
      • Task Settings - Advanced Info
      • Task Settings - Sync Info
      • Task Settings - Parameters Info
      • Add Task Parameter
      • Edit Task Parameter
      • Parameter Notes
    • Task Actions
      • Run Task
      • Clone Task
      • Delete Task
      • Export Task
      • Edit Task Transfer Exceptions
      • Create Advanced Task from a Traditional Task
    • Bulk Actions
      • Create Resource Group
      • Add Tasks to a Resource Group
      • Enable Tasks
      • Disable Tasks
      • Export Tasks
      • Delete Tasks
      • View Run History
      • View File Activity
      • View Audit Records
  • HOSTS
    • Manage Hosts
      • Add New Host
      • Edit Host
      • Clone Host
      • Delete Host
      • View Existing Hosts
      • Search Existing Hosts
      • Filter Existing Hosts
      • Sort Existing Hosts
    • Supported Host Types
      • Local File System Host Field Descriptions
        • Local File System - Additional Properties
      • Windows UNC Share Field Descriptions
        • UNC Host - Additional Properties
      • MOVEit Transfer Host Field Descriptions
        • MOVEit Transfer Host - Additional Properties
      • FTP Host Field Descriptions
        • FTP Host - Additional Properties
      • SSH/SFTP Host Field Descriptions
        • SSH/SFTP Host - Additional Properties
      • POP3 (Incoming Email) Host Field Descriptions
        • POP3 Host - Additional Properties
      • SMTP (Outgoing Email) Host Field Descriptions
        • SMTP (Outgoing Email) Host - Additional Properties
      • Amazon S3 Host Field Descriptions
        • Amazon S3 Host - Additional Properties
        • Amazon S3 Authentication
      • Azure Blob Storage Host Field Descriptions
        • Azure Blob Storage Host - Additional Properties
      • SharePoint Host Field Descriptions
        • SharePoint Host - Additional Properties
        • SharePoint Authentication
      • Google Cloud Storage Host Field Descriptions
        • Google Cloud Storage Host - Additional Properties
      • OneDrive Host Field Descriptions
        • OneDrive Host - Additional Properties
        • OneDrive Authentication
      • AS1 Host Field Descriptions
        • AS1 Host - Additional Properties
      • AS2 Host Field Descriptions
        • AS2 Host - Additional Properties
      • AS3 Host Field Descriptions
        • AS3 Host - Additional Properties
    • Proxy Servers
      • SSH/SFTP Host Proxy Server
      • FTP/FTPS Host Proxy Server
      • Amazon S3 Host Proxy Server
      • Azure Blob Storage Host Proxy Server
      • SharePoint Host Proxy Server
      • AS1 Host Proxy Server
      • AS2 (HTTP/S) Host Proxy Server
      • AS3 Host Proxy Server
      • MOVEit Transfer Host Proxy Server
        • No Proxy Server
        • Proxy Server, No Authentication Required
        • Proxy Server with "Windows Integrated" NTLM Authentication
    • Tests Performed on Hosts
    • Enabling File Notifications
      • How File Notifications Work
      • File Notifications and Task Schedules
  • RESOURCES
    • Scripts
      • Built-in Scripts
        • Certs Backup
        • Certs Restore
        • Command Line App
        • Convert CRLF to LF
        • Convert LF to CRLF
        • Find Or Replace
        • FTP Directory Parse - AS400
        • Header ID
        • HTTP Form Only Post
        • HTTP Get
        • HTTP Put
        • HTTP Post
        • HTTP SharePoint Get
        • HTTP SharePoint Put
        • Ignore All Files
        • Look Up
        • MessageWay Translation
        • No Op
        • PGP Decrypt
        • PGP Encrypt and Sign
        • PGP Encrypt Only
        • Prepend Lines
        • Report Long Running Tasks
        • Set Destination
        • Sleep
        • SMIME Receive
        • SMIME Send
        • Tamper Check
        • Trim Statistics DB
        • Unzip Advanced
        • XSL Transform
        • Zip Advanced
      • Custom Scripts
        • Manage Custom Scripts
        • Add New Custom Script
        • MOVEit-specific Functions and Subroutines
        • Application Notes
        • Custom Script Samples
    • Date Lists
    • Keys and Certs
      • About TLS Client Certificates
        • Obtaining and Importing TLS Client Certificates
        • Create TLS Certificates
      • About SSH Client Keys
        • Create SSH Client Keys
        • Edit SSH Client Keys
        • Import SSH Client Keys
      • About PGP Keys
        • Public and Private Keys
        • Create PGP Keys
        • Edit PGP Keys
        • Obtaining PGP Keys from Other PGP Applications
        • Importing PGP Keys
        • Exporting PGP Keys
        • Deleting Keys
        • PGP Compatibility
        • Using Global Parameters to Sign Outgoing Files
        • Using a Process to Encrypt Files
        • Mark File as PGP-encrypted
        • Decrypting Files
    • Global Parameters
      • Add/Edit Global Parameter
      • Global Parameters and Error Reporting using Next Action
    • Groups and Permissions
      • Resource and Windows User Groups
      • Create/Edit Resource Group
      • Delete Resource Group
      • Add Windows User Groups
      • Apply or Edit Permissions
  • REPORTS
    • Task Run
    • File Activity
    • Custom Duration
    • Audit
  • SYSTEM
    • System Settings
      • System Log Settings
      • Audit Log Settings
      • Windows Event Log Settings
      • ASx Log Settings
      • System-Wide Task Settings
      • State File Settings
      • Tamper Detection Settings
      • IP/User Lockout Policy
      • S3 Configuration
    • System Log
      • Manage System Log
        • View Existing System Logs
        • Search System Log
        • Filter System Log
        • Sort System Logs
        • Pause/Resume System Log
        • Clear System Log
    • Manage Lockouts
    • Failover Status
  • HELP
    • Help Links
    • Quick Stats
    • About
  • COMMANDS
  • Macros
    • Macro Attributes
    • Macro Date and Time Syntax
    • Macro Functions
  • Common Applications
    • Trigger Files
    • "Last Day Of Month" Schedules
    • Converting EBCDIC Text to ASCII Text
    • HTTP Uploads and Downloads
    • MessageWay Translation
      • Task that Runs a Translation
      • Sample Task
        • MessageWay Setup
        • MOVEit Central Setup
  • S/MIME Email
    • Configuring Certificates
    • Sending and Receiving
  • AS1, AS2, AS3
    • AS1, AS2 and AS3 Overview
      • Identifying My Organization and a Partner
      • Optional Elements
      • Limitations of the ASx Protocols
    • The AS1 Protocol
      • How an AS1 File Transfer Works
      • MOVEit Implementation of AS1
      • Advantages/Disadvantages of AS1 (Compared to AS2 and AS3)
    • The AS2 Protocol
      • How an AS2 File Transfer Works
      • MOVEit Implementation of AS2
      • Advantages/Disadvantages of AS2 (Compared to AS1 and AS3)
    • The AS3 Protocol
      • How an AS3 File Transfer Works
      • MOVEit Implementation of AS3
      • Advantages/Disadvantages of AS3 (Compared to AS1 and AS2)
    • MOVEit Implementation
      • Drummond "eBusinessReady" Certification
      • Why MOVEit Transfer is best choice for AS3
      • Advantages of a MOVEit Implementation
      • Limitations of the MOVEit Implementation
    • About Certificates
      • Where to Configure Certificates
    • Configuring AS1, AS2, and AS3 Hosts
    • The Role of MOVEit Transfer in AS2 File Transfers
    • AS2 Server URL and MOVEit Transfer File Specifics
    • Troubleshooting
    • The Role of MOVEit Transfer in AS3 File Transfers
    • ASx Source and Destination Options
      • AS1 - Source and Destination
      • AS2 - Source and Destination
      • AS3 - Source and Destination
  • Advanced Topics
    • FTP Source Integrity
    • Custom Directory Parsing
      • Automatic Directory Parsing
      • Column-based Custom Parsing
      • Directory Parsing Script
        • Date and Time Formats
        • Sample Script
    • SysLog and SNMP
      • Syslog Utilities
      • SNMP
    • Antivirus
    • Tamper Detection
    • POP3 Sources
    • GetMICConfig Utility
    • Port Numbers
    • System Internals
    • MOVEit Automation Error Codes
    • Change Windows Service Account Password
    • MessageWay CLI
      • Program Arguments
      • Input File
      • Output File
      • Return Code
    • Database
      • Schema
      • Database Conversion
        • Migrate MySQL to Microsoft SQL or Azure SQL
      • Database Tamper Detection
      • Trimming
      • Troubleshooting
  • Configuration Reference
    • config.properties
    • Server Certificate and Web Admin Certificate
    • Update the MOVEit Automation Web Admin SSL/TLS Certificate
    • Update the MOVEit Automation Server SSL/TLS Certificate
    • Configure Web Admin FIPS mode
    • Algorithms for SSH/SFTP in Standard Mode and FIPS Mode
    • Performance Tuning
  • MOVEit Automation Service
    • Starting and Stopping
    • Firewall Considerations
    • Running As...
      • Recommended Configuration: Running As a Service Under a Specific Windows Administrator
      • Converting From MOVEit Automation as a Local System Service
      • Running MOVEit Automation in the Foreground, Not As a Service
      • Additional Considerations
    • Configuration Utility
      • Start the Configuration Utility
      • Configuration Utility Dialog
        • General Tab
        • Web Admin Tab
        • License Tab
        • Database Tab
        • Email Tab
        • Failover Tab
        • Virus Tab
        • Tamper Tab
        • TLS Tab
        • Lockout Tab
        • About Tab
    • Backup
      • Backup - Disaster Recovery
        • Backup and Restore Tasks
      • Automated Configuration Replication
    • Failover
      • Overview
        • Requirements
        • How Failover Works
        • What Failover Replicates
        • Database Replication
        • After a Failover
        • Failover Alerts
        • Resynchronizing
        • How to Make Two MOVEit Automation Systems Appear As One
      • Installation
        • Assumptions and Requirements
        • Step-by-Step Instructions
        • Failover configuration with a remote SQL Server
        • Securing Connections Between Nodes
        • Updates
      • Failover Status
      • Common Procedures
        • Backup
        • Software Update
        • Node Swap
        • Resynchronization for MySQL
        • Resynchronization for MSSQL
  • Third Party Software used in MOVEit Automation
Table of Contents

Database

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: June 2, 2022
  • 1 minute read
    • MOVEit Automation
    • Version 2026
    • Documentation

In this section:

  • Schema - how MOVEit Automation keeps track of histories of task runs and file transfers.
  • Database Conversion - facilitates database migration from MySQL to Microsoft SQL or Azure SQL.
  • Tamper Detection - detects attempts by an intruder to alter database tables containing audit information and activity history.
  • Trimming - deleting old records form the database
Contents
  • Schema
  • Database Conversion
  • Database Tamper Detection
  • Trimming
  • Troubleshooting
TitleResults for “How to create a CRG?”Also Available inAlert