Upgrade database from sql server 2008 to sql server 2016 -
i have database created on sql server 2008. want upgrade sql server 2016. best way upgrade whole database?
thanks in advance.
migration can done many ways 2008 2016. in-house upgrade, backup restore, etc. different approaches explained here:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-database-engine
but simple backup/restore approach better in practical understanding. has links ssis/ssas/ssrs if required plan those. each has different approaches...
major things consider how remove deprecated features , how make use of new features:
deprecated features: 2012: https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx
2014: https://msdn.microsoft.com/en-us/library/ms144262(v=sql.120)
you can use new amr tool identify tables can use in-memory can analysis of columnstore indexes etc using below:
Comments
Post a Comment