SQL Server Database Migration to Azure VM — Current Supported SQL Server Version
IT Partner migrates SQL databases from your existing SQL Server to SQL Server in an Azure VM running the current supported version of SQL Server. This Microsoft Azure migration service is for customers who need their databases available from Azure without data loss and need the migration target to use the current supported version of SQL Server. SKU: ITPWW290MIGOT. Price: $450. Duration: 1 week. Manager: Mike Mackey.
What this engagement is
This service moves SQL databases from your own SQL Server to SQL Server running in an Azure virtual machine, targeting the current supported version of SQL Server. This is a simple, well-tested technique for moving databases across machines. For large data transfers, IT Partner will help arrange shipment of hard drive(s) through the Azure Import/Export Service when uploading over the network is prohibitively expensive or not feasible. This is a Migration service for Microsoft Azure. Original page date: 2018-06-27.
Success criteria
What you receive
How the work unfolds
Begin the project with a kickoff meeting.
Review SQL Server and Windows Server before deployment.
Start the deployment.
Finalize the deployment.
Verify the deployment and fix issues, if any.
Prerequisites
Who does what
IT Partner
- Perform a full database backup to an on-premises location
- Create a virtual machine with the current supported version of SQL Server
- Set up connectivity
- Connect to SQL Server over the Internet or in the same virtual network
- Copy file(s) to VM
Your team
- Provide a dedicated point of contact responsible for working with IT Partner and coordinate any outside vendor resources and schedules
- Configure all networking equipment, such as load balancers, routers, firewalls, and switches
- Provide access to physical and virtual servers and/or systems and services, as needed. Provide remote and/or physical access to facility and systems required to complete work
What's not included
Limitations & technical notes
Frequently asked questions
What does IT Partner’s SQL Server Database Migration to SQL Server in Azure VM service include?
IT Partner migrates SQL databases from an existing SQL Server to SQL Server running in an Azure virtual machine on the current supported version of SQL Server. The service includes a full database backup to an on-premises location, creation of an Azure VM with the current supported version of SQL Server, connectivity setup, copying files to the VM, deployment finalization, verification, and issue fixing if needed.
What SQL Server version is used for the migration target?
This service migrates SQL databases to SQL Server in an Azure VM running the current supported version of SQL Server. SQL Server version targets other than the current supported version of SQL Server should be confirmed separately with IT Partner.
What is the goal or success criterion for this SQL Server migration service?
The success criterion is that the SQL databases are available from Azure without data loss. IT Partner verifies the deployment and fixes issues if any are found during the engagement.
How long does the SQL Server migration to an Azure VM take?
The listed duration for this service is 1 week. The plan may vary depending on customer needs, environment readiness, data size, connectivity, and any issues discovered during verification.
How much does this SQL Server migration service cost?
The listed price for the SQL Server Database Migration to SQL Server in Azure VM service is $450. This price applies to the defined service scope, and any work outside scope, such as SQL Server version targets other than the current supported version of SQL Server, training, or more extensive documentation, should be confirmed separately with IT Partner.
What is the SKU for this SQL Server migration service?
The SKU for this service is ITPWW290MIGOT. The service title is SQL Server Database Migration to the Current Supported Version of SQL Server in Azure VM.
Who manages this migration service at IT Partner?
The listed manager for this service is Mike Mackey. Prospective customers should confirm current scheduling, scope, and availability with IT Partner before purchasing.
What happens during the migration engagement?
The engagement starts with a kickoff meeting, followed by a review of SQL Server and Windows Server before deployment. IT Partner then starts and finalizes the deployment, verifies the migration, and fixes issues if any are found.
What deliverables does IT Partner provide at the end of the project?
IT Partner delivers SQL databases migrated to an Azure VM running the current supported version of SQL Server. IT Partner also provides a project closeout report showing final project status, evidence of meeting acceptance criteria, any outstanding issues, and the final budget.
What is not included in this SQL Server migration service?
This service does not include SQL Server version targets other than the current supported version of SQL Server, customer team training, or documentation beyond the project closeout report. More extensive documentation may be available for an additional fee.
Can IT Partner migrate large SQL Server databases to Azure if network upload is not practical?
Yes, for large data transfers IT Partner will help arrange shipment of hard drives through the Azure Import/Export Service when uploading over the network is prohibitively expensive or not feasible. The service description does not define exact size thresholds, so customers should confirm the best transfer method with IT Partner during planning.
What responsibilities does IT Partner handle during the migration?
IT Partner performs a full database backup to an on-premises location, creates a virtual machine with the current supported version of SQL Server, sets up connectivity, connects to SQL Server over the Internet or within the same virtual network, and copies the files to the VM. IT Partner also finalizes and verifies the deployment within the service scope.
What responsibilities does the customer have during the migration?
The customer must provide a dedicated point of contact to work with IT Partner and coordinate outside vendor resources and schedules. The customer is also responsible for configuring networking equipment such as load balancers, routers, firewalls, and switches, and for providing access to physical or virtual servers, systems, services, facilities, and remote access as needed.
Are there listed prerequisites for this SQL Server migration service?
The service description does not list explicit prerequisites separate from customer responsibilities. Customers should confirm required Azure subscription access, licensing, VM, storage, network, server access, and SQL Server details with IT Partner before scheduling the migration.
Will there be downtime or business impact during the SQL Server migration?
The service description does not specify a downtime window or cutover approach. Because downtime depends on the source environment, database size, connectivity, and migration method, customers should confirm expected business impact and scheduling with IT Partner during the kickoff and planning steps.
Does this service include setting up network connectivity to the SQL Server VM in Azure?
Yes, IT Partner sets up connectivity and connects to SQL Server over the Internet or in the same virtual network. The customer remains responsible for configuring networking equipment such as load balancers, routers, firewalls, and switches.
Will IT Partner review the existing SQL Server and Windows Server before migration?
Yes. The implementation plan includes a review of SQL Server and Windows Server before deployment, because the migration depends on understanding the current server environment before moving the databases to Azure.
What happens if issues are found after the databases are migrated to Azure?
The implementation plan includes a verification step and fixing issues if any are found during the engagement. Any outstanding issues at closeout are documented in the project closeout report along with final project status and acceptance evidence.
Can this service be customized for different migration needs?
The plan may vary depending on customer needs, but the stated scope remains migration of SQL databases to SQL Server in an Azure VM running the current supported version of SQL Server. Any additional requirements, such as other SQL Server version targets, training, or expanded documentation, should be confirmed separately with IT Partner.