donovan Stoltz
asked on
Moving old SQL Server estate to the cloud
Any useful information or tips on the below-mentioned topic will be appreciated.
I have the massive task of moving most of our SQL Server estate to SQL Azure. Starting with moving our dev and test environments.
Most of the current estate consists of SQL Server 2008's and 2008 R2's and this why we have to move.
The sysadmins have a SQL Azure environment in place. I have to give them specs (amount of cores, memory, disk space, etc) so that the AZure VM environment can be provisioned accordingly. Is this very similar to configuring a SQL Server environment on-prem?
Also, is scoping out the specs for an on-premise SQL Server setup very similar to that of an Azure SQL server setup?
I have limited experience when it comes to SQL Azure. I do however have knowledge of on-premise configs, migrations and dba related issues
Thanks
I have the massive task of moving most of our SQL Server estate to SQL Azure. Starting with moving our dev and test environments.
Most of the current estate consists of SQL Server 2008's and 2008 R2's and this why we have to move.
The sysadmins have a SQL Azure environment in place. I have to give them specs (amount of cores, memory, disk space, etc) so that the AZure VM environment can be provisioned accordingly. Is this very similar to configuring a SQL Server environment on-prem?
Also, is scoping out the specs for an on-premise SQL Server setup very similar to that of an Azure SQL server setup?
I have limited experience when it comes to SQL Azure. I do however have knowledge of on-premise configs, migrations and dba related issues
Thanks
Both of the guides below are useful if you fancy a go at doing it yourself:
https://dzone.com/articles/migrate-sql-server-2008-database-to-azure-a-comple
https://azure.microsoft.com/en-gb/resources/videos/how-to-migrate-sql-server-2008-or-r2-to-azure-sqldbmi/
if these are business critical systems or contain important data etc. i recommend seeking 3rd party assistance where you lack Azure experience.
https://dzone.com/articles/migrate-sql-server-2008-database-to-azure-a-comple
https://azure.microsoft.com/en-gb/resources/videos/how-to-migrate-sql-server-2008-or-r2-to-azure-sqldbmi/
if these are business critical systems or contain important data etc. i recommend seeking 3rd party assistance where you lack Azure experience.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It seems we will be going the Azure VM route for now. (Iaas)
If one my current main production server's was running SQL server 2008 and this will migrate to Azure and I allocate 40 GB of RAM and 12 cores how do I calculate what the IOPS number should be?
If one my current main production server's was running SQL server 2008 and this will migrate to Azure and I allocate 40 GB of RAM and 12 cores how do I calculate what the IOPS number should be?
There plenty tutorials/videos on the concept of moving on premises SQL server to Azure and in the end is nothing special just moving databases from one SQL server instance to another...