Can we migrate PA scores from one instance to another instance?

[cmcclendon]

Can we migrate PA scores from one instance to another instance?

[Filipe Cruz]

Hello cmcclendon,

Yes.
Make sure the table pa_scores is not in the Excluded tables (System Clone > Clone Definition > Exclude Tables) list nor in the Preserve Data records (System Clone > Clone Definition > Preserve Data).


Also, make sure the option "Amount of data copied from large tables" is set to full. 
This option represents the number of days of historical data from large source tables, including task, pa_scores, and metric_instance. By default, the target instance receives the latest 90 days of historical data from the source instance. But you should change it to "full" if you want to do a full copy of the pa_scores table.

Reference: https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/managing-data/ta...

With this, you should be able to perform the clone and do a full copy of the pa_scores table.

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

[sonali panda1]

It's not just migrating the pa scores but you will need to migrate indicators , indicator sources, breakdown , breakdown sources etc which are associated with the pa score generation. Otherwise it may just be like some orphan records. Hopefully I made sense.

[cmcclendon]

We have migrated the pa indicators and such, just trying to see if we can latch the scores back to their respective sources/indicators/breakdowns. Moving to a new (non-cloned) instance.

Thanks.