Automic V24 Upgrade :: Feasibility to use the SQL query generated by the FINAL step on multiple AE (UTF-8) machines

[Ajit G D]

Hello All,

I'm not sure if this was ever tried before, but we are hoping to use the same SQL query on multiple Automation Engine system (basically these machines will be a clone of the existing v21 AE system) that gets generated upon the successful completion of the FINAL step while running the Data Migration Tool workflow on the Automic v21 system.

Since we would be creating clones, would it make sense to :

1. Run the Data Migration tool workflow on the V21 AE system.
2. Complete all the three steps successfully i.e., INITIAL, REFRESH and FINAL.
3. Once the FINAL step generates the SQL query, and if I'm creating 2 machines that will be a clone (data perse), then can I run the same SQL query on both these machines?

Kindly let me know if this is a feasible option.

Many thanks.