November 12, 2018 at 10:01 pm
Hello there,
I have good grasp of the options to migrate a SQL Database to a higher/newer version of SQL Server, however I am now looking to do the same with a Data Warehouse. Lets assume the DWH is huge and backup and restore was not an option, I was wondering what methods may have been employed by those that may have already performed an upgrade. This will be to new hardware. I was thinking I could copy the data over, but this could also take a very long time, I know I could use polybase from Blob, but what would be the best option to get the data up to Blob from the old server within a decent amount of time? It might be possible to move older data in advance, then the more recent on the day of the upgrade and switch.
I'd really appreciate any advice, and methods. I'd also be looking to move a fair few SSIS packages and database as well, I do not consider that an after thought either, I realize that this may (will!) come with its own set of challenges.
Thank you for any feedback and suggestions, and of course, your time.
Kind regards,
D
November 13, 2018 at 12:59 am
Duran - Monday, November 12, 2018 10:01 PMHello there,
I have good grasp of the options to migrate a SQL Database to a higher/newer version of SQL Server, however I am now looking to do the same with a Data Warehouse. Lets assume the DWH is huge and backup and restore was not an option, I was wondering what methods may have been employed by those that may have already performed an upgrade. This will be to new hardware. I was thinking I could copy the data over, but this could also take a very long time, I know I could use polybase from Blob, but what would be the best option to get the data up to Blob from the old server within a decent amount of time? It might be possible to move older data in advance, then the more recent on the day of the upgrade and switch.I'd really appreciate any advice, and methods. I'd also be looking to move a fair few SSIS packages and database as well, I do not consider that an after thought either, I realize that this may (will!) come with its own set of challenges.
Thank you for any feedback and suggestions, and of course, your time.
Kind regards,
D
Please talk to your DC team, if they can mount the external HDD, take a full backup and copy and mount to new hardware and restore with norecovery, when the cut-over start do a differential and log. Once, you have imported the backup, there should not be any other full backup, make sure you disable them.
If it is on VM, you can do back end without downtime, it will have a bit drawback to the host.
On VM, the VMDKs are easily un-mount and mount to new server and very fast, you can detach attach the databases as well.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 13, 2018 at 1:02 am
Take a look on this as well -->https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-2017
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply