Can we alter data types in ReportServer and ReportServerTemp databases #ssrs #sqlhelp #sqlfamily #SQLServer
2
0
0
0
0
@SQLDBASri Can I ask the goal? That sounds dangerous.
@SQLTrooper Ran the data migration assistant and it was complaining that the data types are deprecated and we were planning to move these db's to the azure managed instances currently they are on 2017 instance
@SQLDBASri I have never run the DMA against SSRS databases, although I've never touched the data types either. I've gone from 2012 to 2019 w/out issue, although that leap did have a couple tweaks. If the data types were just trivial expansion of character, no biggie.