New upgrade capability in SSMS gives you readiness assessment and upgrade the SQL Server within SSMS.
Updated Jan 22, 2025
Version 2.01) If I have 5-10 TB single database, and wanted to migrated this to Azure sql/Azure sql MI / Azure VM. Can I use this feature smoothly without hung and at the same time I can monitor the progress of migration?
2) How about if I have 5 - 10 TB single database full backup of last week I already have and don't want to perform full backup but wanted to use the existing one, Can this feature provide that options?
3) I wanted to take fresh full backup and take the final delta backup and migrate, does this feature provide the option?
My point is simple, if it is covering all practical possible technical scenarios then it would be awesome otherwise again will have to go for alternative routes and all.... then it won't be cool.
Please respond if you can...
hs1912 - if you intend to migrate to higher version of SQL Server upgrade, then the database size and backup size wont be an issue. To move to Azure SQL DB/Azure SQL MI/ Azure SQL VM you can use Azure Database Migration Service.