Copy SQL Tuning Task to different database
Q-: How to copy SQL tuning advisor task with profile recommendation.(Not sql profile but task)
Scenario -:
I have a sql profile recommendation in Prod database by sql tuning advisor task. However, we cannot apply sql profile directly in Prod.
Also, Non-prod tuning advisor is also not giving same profile recommendation.
So, have to
i) copy the task from Prod to Nonprod
ii) Accept sql profile in nonprod & test
iii) Accept in prod or export/import profile to Prod.