SQL Server Migration to Azure VM — Upgrade & Move Databases

IT Partner migrates SQL databases from your existing SQL Server to SQL Server running in an Azure virtual machine and upgrades supported source versions to the current supported version of SQL Server. The service includes preparing the databases, creating the Azure VM with the current supported version of SQL Server, setting up connectivity, copying files to the VM, configuring the new SQL Server installation, and verifying the deployment.

The stated scope covers upgrades from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014 to the current supported version of SQL Server. Confirm implementation details with IT Partner before purchasing.

The project is successful when the SQL databases are available from Azure without data loss. IT Partner also provides a project closeout report showing final project status, evidence of meeting acceptance criteria, any outstanding issues, and the final budget.

The listed duration for this service is 1 week. The actual plan may vary depending on your needs, because the engagement includes review, deployment, finalization, and issue verification activities.

This service is priced at $150 per hour. The service details list SKU ITPWW280MIGOT, and the final budget is included in the project closeout report.

Yes, this service requires some downtime because SQL Server services may be stopped and started during the upgrade and cutover process. IT Partner will try to minimize downtime, but the service content does not state a guaranteed downtime window.

The engagement follows milestones for kickoff, review of SQL Server and Windows Server, deployment start, deployment finalization, and verification with fixes if needed. In practical terms, IT Partner backs up and checks the databases, creates the Azure VM, sets up connectivity, copies files, configures SQL Server, and verifies that the databases are available from Azure.

IT Partner backs up all SQL Server database files from the server to be upgraded so they can be restored if required. IT Partner also runs the appropriate Database Console Commands, or DBCC, on databases to be upgraded to confirm they are in a consistent state before proceeding.

Yes, IT Partner creates a virtual machine with the current supported version of SQL Server as part of the stated service scope. IT Partner also configures the new SQL Server installation and sets up connectivity for access to SQL Server.

The service includes setting up connectivity and connecting to SQL Server over the Internet or in the same virtual network. The source does not specify exact network design, firewall, VPN, private connectivity, or access requirements, so those details should be confirmed with IT Partner for your environment.

IT Partner handles database backups, DBCC consistency checks, disabling startup stored procedures, performing a full database backup to an on-premises location, creating the Azure VM, setting up connectivity, copying files to the VM, and configuring the new SQL Server installation. IT Partner also verifies the deployment and fixes issues if any are found within the engagement scope.

The service description does not list specific client responsibilities. In practice, details such as required access, Azure subscription availability, maintenance windows, and approvals should be confirmed with IT Partner because they are not specified in the published scope.

No formal prerequisites are listed in the service description beyond the supported SQL Server source versions in scope. Requirements such as permissions, Azure subscription readiness, network access, source server health, and maintenance-window planning are not specified, so they should be clarified with IT Partner before the engagement begins.

IT Partner disables startup stored procedures because stored procedures processed at startup time might interfere with the upgrade process. This matters because the upgrade process can stop and start SQL Server services.

Yes, the service includes backing up SQL Server database files from the server being upgraded and performing a full database backup to an on-premises location. This is done so the databases can be restored if required and to support a controlled migration process.

The acceptance criterion is that SQL databases are available from Azure without data loss. IT Partner’s preparation steps include backups and DBCC consistency checks, but any environment-specific risk, rollback plan, or validation approach should be reviewed with IT Partner before the migration.

IT Partner provides a project closeout report that states the final project status, evidence of meeting acceptance criteria, any outstanding issues, and the final budget. More extensive documentation than the project closeout report is not included and can be provided for an additional fee.

More extensive documentation than the project closeout report is not included in the base service and can be provided for an additional fee. The published scope also does not specify items such as application remediation, detailed network architecture, high availability design, performance tuning, or post-migration managed services, so those should be confirmed separately if needed.

The listed manager for this service is Mike Mackey. The service details identify the offering as SKU ITPWW280MIGOT.

The plan may vary depending on your needs, according to the service notes. However, any changes should stay within the agreed scope, because the stated service is specifically for migrating SQL databases to SQL Server in an Azure VM and upgrading the supported SQL Server versions described in the service.