Skip to main content
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Source Link

There is no definitive answer to your question, since it will totally depend on the complexity of SSIS packages, SSRS reports and SSAS Cubes.

Doing in-place upgradein-place upgrade is always risky, since if something goes wrong, it would be difficult to rollback. A side-by-side migration is always a good and reliable method, since if something goes wrong, you already have a system up and running that you can point to.

Always, test, test and test your migration and have a fully tested rollback plan. Use upgrade advisor (this touches DB Engine, SSIS, SSRS and SSAS) and fully address all the issues raised by it.

There is no definitive answer to your question, since it will totally depend on the complexity of SSIS packages, SSRS reports and SSAS Cubes.

Doing in-place upgrade is always risky, since if something goes wrong, it would be difficult to rollback. A side-by-side migration is always a good and reliable method, since if something goes wrong, you already have a system up and running that you can point to.

Always, test, test and test your migration and have a fully tested rollback plan. Use upgrade advisor (this touches DB Engine, SSIS, SSRS and SSAS) and fully address all the issues raised by it.

There is no definitive answer to your question, since it will totally depend on the complexity of SSIS packages, SSRS reports and SSAS Cubes.

Doing in-place upgrade is always risky, since if something goes wrong, it would be difficult to rollback. A side-by-side migration is always a good and reliable method, since if something goes wrong, you already have a system up and running that you can point to.

Always, test, test and test your migration and have a fully tested rollback plan. Use upgrade advisor (this touches DB Engine, SSIS, SSRS and SSAS) and fully address all the issues raised by it.

Source Link
Kin Shah
  • 62.4k
  • 6
  • 122
  • 240

There is no definitive answer to your question, since it will totally depend on the complexity of SSIS packages, SSRS reports and SSAS Cubes.

Doing in-place upgrade is always risky, since if something goes wrong, it would be difficult to rollback. A side-by-side migration is always a good and reliable method, since if something goes wrong, you already have a system up and running that you can point to.

Always, test, test and test your migration and have a fully tested rollback plan. Use upgrade advisor (this touches DB Engine, SSIS, SSRS and SSAS) and fully address all the issues raised by it.