Automic Workload Automation

  • Private Community
 View Only

Back to discussions
Expand all | Collapse all

Upgrade from Automic WLA from 21.0.9 to 24.4.1 – DB Migration and Object Count Validation

  • 1.  Upgrade from Automic WLA from 21.0.9 to 24.4.1 – DB Migration and Object Count Validation

    Posted 2 days ago

    Hi everyone,

    We're planning the upgrade from Automic version 21.0.9 to 24.4.1, and as part of this process, we need to migrate our database collation from Latin1_General_CI_AS to Latin1_General_100_CI_AS_SC_UTF8.

    After the migration, I'd like to run some queries to compare the number of objects (e.g., JOBS, JOBP, SCRI, etc.) between the old and new databases to ensure consistency. My goal is to validate that the object count matches what is shown in Client 0 > Administration > Client Management.

    Here are my questions for the community:

    1. Is the object count shown in Client 0 > Administration > Client Management a reliable reference for validating the total number of objects after migration?
    2. Are there any recommended SQL queries or best practices to perform this kind of object count comparison between the two databases?
    3. Has anyone performed a similar upgrade and DB collation change, following all guidelines (Migrating the AE DB to UTF-8) and prerequisites? Any lessons learned or pitfalls to avoid?

    Thanks in advance for your support!

    Best regards,
    Marta Lorenzon



    -------------------------------------------