After using Datamigrator to migrate from one database to another, would the destination preserve the jobs statuses before migration?

Products

• Autosys Workload Automation

Issue/Introduction

AutoSys Datamigrator tool ensures that the data migration process is efficient and reliable, maintains data integrity, and ensures compatibility with the destination(target) database.

Resolution

It basically is copying your underlying database content directly from source to destination PostgreSQL database.

So, your entire data set is preserved,  including your jobs, their statuses, user credentials, machines, everything. It's basically like your DBA copied your data from SQL Server to PostgreSQL and now you need to would start operating autosys against PostgreSQL.

After database is copied over,  it is recommended to just start application server for verification checks to complete (you can run autoreps etc., against it to check your data), and not start scheduler already.  Scheduler should be started as the last step (when you are truly ready for it to start processing your jobs).