Hi,

here what I did in ssis packages migration from 2008 to 2016 (I think it's the same for 2017):

• created an empty catalog (SSISDB) on MS SQL 2016
• MS SQL...

• This reply was modified 5 years ago by  elenad80.

Hi NicHopper,

you could try to move the DB out of the AG (and then remove it from all replica nodes) , do the data changes/updates etc... , and then re-add...

Yes, it’s not possible to choose which databases to fail over on inside the same AG : when you do fail over you do it per AG , and so...