First page of Microsoft's 100,000-partner directory, sorted by responsiveness Microsoft Solutions Partner — Security, Modern Work, Infrastructure, App Innovation Microsoft partner since 2006 1,100+ organizations under management
Home/Services/SQL Server to Azure Migration Assessment
Assessment

SQL Server to Azure Migration Assessment

A fixed-fee, three-business-day, read-only assessment of your SQL Server estate that tells you which Azure target fits — SQL Server on an Azure VM, Azure SQL Managed Instance, or Azure SQL Database — which migration method we would use and why, every blocker with its remediation, a sized and licensed target, and a fixed written quote for the migration itself with the cutover window stated in minutes. $950 fixed, for up to three SQL Server instances. The report is yours whether you migrate with us, with someone else, or not at all.

Timeline 3 daysService owner Mike MackeyMicrosoft AzureSQL Server

What this engagement is

Most SQL Server migrations that go wrong go wrong for reasons that were visible on day one and nobody looked: tables with no primary key that rule out the replication method someone already promised, a source version the chosen tool no longer supports, FILESTREAM buried in one database that quietly disqualifies Managed Instance, a storage layout that halves query performance the moment you cut over, or a VPN that was never tested under load. This assessment finds those things before you have committed to a date, a method, or a budget. The timing is rarely accidental. SQL Server 2016 left extended support on 14 July 2026, and Microsoft's current guidance is that its Extended Security Updates are a paid subscription — unlike 2012 and 2014, they are not free simply for running on an Azure VM. SQL Server 2017 follows in October 2027. If an end-of-support date is what put migration on your agenda, the assessment also tells you which target lets you leave the version treadmill behind entirely and which one keeps you on it. Over three business days we inventory your SQL Server estate with read-only collection, test the connectivity path to Azure, and produce a written report that answers four questions: 1. Which Azure target is right — SQL Server on an Azure VM, Azure SQL Managed Instance, or Azure SQL Database — and why, with the alternatives stated and the reason each was ruled out. 2. Which migration method we would use — backup and log-restore chain, Managed Instance link, Log Replay Service, Azure Database Migration Service, transactional replication, or a whole-VM lift with Azure Site Recovery — with the reasoning written down, not assumed. 3. What will block it, listed individually, with the remediation each item needs. 4. What the migration will cost and how long the cutover window will be, as a fixed written quote. You own the report. Take it to another vendor, hand it to your own DBA team, or decide not to migrate at all — each is a legitimate outcome and the report is still worth having. If you do proceed with us, the migration quote is built directly from these findings, which is what makes a fixed price for the migration itself possible.

Success criteria

The engagement is successful when you can make a go/no-go decision without needing another meeting. Specifically:

01A recommended target platform and migration method, with the alternatives considered and the reason each was ruled out.
02A complete blocker register — every item that would stop or delay the migration, with the remediation effort estimated for each.
03A sized Azure target with a storage layout and a licensing route, costed both ways: Azure Hybrid Benefit versus pay-as-you-go.
04A measured connectivity finding — achievable throughput on the path to Azure, or a statement of what has to be built first.
05A quoted cutover window, expressed in minutes, with the assumptions it depends on stated.
06A fixed-price migration quote, or a written explanation of what has to change before a fixed price is responsible.

What you receive

Migration Assessment Report (typically 6–10 pages) covering the items below, delivered as a document you own.
Instance inventory — SQL Server version, edition, patch level, host OS, database list with sizes and growth rates, recovery models, and current backup posture.
Target platform recommendation — Azure VM versus Managed Instance versus Azure SQL Database, with the compatibility findings that drove the decision.
Method recommendation — log-restore chain, Managed Instance link, Log Replay Service, Azure Database Migration Service, transactional replication, or Azure Site Recovery — with rationale.
Blocker register — tables without primary keys; unsupported or problematic features and data types (FILESTREAM and FileTable, CLR, Service Broker, `xp_cmdshell`, linked servers to non-SQL sources, memory-optimized tables, Always Encrypted, oversized LOBs); version-span limits; authentication and cross-domain issues; deprecated feature usage.
Dependency map — SQL Agent jobs, linked servers, logins and permissions, SSIS/SSRS/SSAS packages, applications and their connection strings, DNS names, service accounts.
Azure sizing and storage recommendation — vCore and memory target from observed workload, disk layout (separate data, log, and tempdb), caching policy and disk tier, and the licensing route with a cost comparison of Azure Hybrid Benefit against a pay-as-you-go image. You can pre-check your own licensing numbers with our SQL Server licensing calculator.
Connectivity findings — measured throughput on the existing path to Azure, or a statement of what needs to be built.
Performance baseline — Query Store or plan-cache capture of your top queries, so post-migration regression can be measured rather than argued about.
Fixed-price migration quote with the cutover window stated in minutes.
A 60-minute findings walkthrough with the engineer who did the analysis.

How the work unfolds

Day 0 — Kickoff (45 minutes)

Confirm which instances are in scope, who owns the applications that connect to them, what your downtime tolerance actually is, and any target platform you have already committed to. Agree the read-only access and the collection window.

Day 1 — Collection

Run read-only collection scripts against the source instances. Nothing is installed, nothing is changed, no configuration is modified. We capture schema metadata, object inventory, data type and feature usage, index and constraint definitions, job definitions, login and permission mappings, wait statistics, and workload characteristics. Where Query Store is on we capture a plan baseline; where it is not, we sample the plan cache.

Day 2 — Analysis and connectivity test

Evaluate the migration method options against the findings and against Microsoft's current tooling and support matrix — checked on the day, not from memory. Test the network path to Azure and measure achievable throughput, which sets the initial seeding time and often decides the method. Size the target and model the licensing cost both ways. Build the blocker register.

Day 3 — Report and walkthrough

Deliver the written report and walk through it live for 60 minutes with your team. Answer the 'what if we did X instead' questions on the call rather than in a follow-up. Issue the fixed-price migration quote.

Prerequisites

Read access to the source SQL Server instances — `VIEW SERVER STATE`, `VIEW ANY DEFINITION`, and `db_datareader` on the in-scope databases is sufficient. We do not need `sysadmin` for an assessment.
Read access to the Windows hosts sufficient to identify OS version, CPU, memory, and disk configuration.
A named technical contact who can say which applications connect to which databases.
If an Azure subscription already exists, Reader access to it. If it does not, that is a finding, not a blocker.
Confirmation of which instances and databases are in scope — the standard fee covers up to three SQL Server instances.
If your security policy does not permit external access at all, your own staff can run our collection scripts and return the output; we never need production credentials handed over in plain text.

Who does what

IT Partner

  • Provide and explain the read-only collection scripts.
  • Run or supervise collection and analysis.
  • Test and measure the connectivity path to Azure.
  • Produce the assessment report, blocker register, sizing and licensing recommendation, and the fixed-price migration quote.
  • Deliver the findings walkthrough and answer the follow-up questions it raises.
  • Treat everything collected as confidential and request the least access the job needs.

Your team

  • Provide a named technical contact for the duration.
  • Grant the read access described above, or run collection on our behalf.
  • Identify application owners and confirm which applications depend on which databases.
  • Confirm scope before Day 1.
  • Attend the Day 3 walkthrough.

What's not included

Changes to your environment — this is a read-only engagement: no remediation, no configuration changes, no test migration.
Azure resources — sizing is recommended, not provisioned. Building the foundation is the Azure Landing Zone implementation or part of a per-workload migration.
Application code review — we identify which applications connect and flag compatibility risk at the database surface; we do not audit application source.
A security, compliance, or licensing audit — licensing is covered only to the extent of comparing Azure Hybrid Benefit against pay-as-you-go for the recommended target.
Performance tuning — we capture a baseline so regression can be measured after migration; fixing pre-existing performance problems is separate work.
Whole-datacenter discovery — if the question is 'what should move to Azure at all' across VMware, Hyper-V, or physical servers, that is the Azure Migrate Datacenter Discovery and Assessment; this engagement goes deeper on the database engine than that one does.
Network establishment — if the connectivity test finds there is no usable path to Azure, building one is the Azure Site-to-Site VPN and ExpressRoute implementation.
The migration itself — quoted from the report as a separate fixed-price engagement: Azure VM, Azure SQL Managed Instance, or Azure SQL Database.
Estates larger than three SQL Server instances — scoped and quoted separately in writing before we start.

Limitations & technical notes

!Findings are only as complete as the access granted. If collection is restricted, the report states what could not be examined and what risk that leaves open.
!The fixed-price migration quote states its own validity period and assumes the environment does not materially change in that window; findings older than 60 days are re-verified before a migration starts.
!If the assessment concludes that a fixed-price migration is not responsible — an unbounded blocker such as a vendor schema you are not permitted to modify — we say so and quote time-and-materials instead. We would rather lose the fixed-price sale than commit to a number we cannot hold.
!The performance baseline needs Query Store, or a plan cache with meaningful uptime. If the instance was restarted recently the baseline is weaker and the report says so.
!Microsoft's migration tooling and support matrix move quickly — the Azure SQL migration extension for Azure Data Studio was retired in February 2026, for example, and SQL Server versions gain and lose support for the Managed Instance link. Method recommendations are checked against Microsoft's current documentation on the day the report is issued, and the report states that date.
!End-of-support and Extended Security Update terms are Microsoft's and change by version. Where the report cites them it cites Microsoft's lifecycle pages at the time of writing; confirm against those pages before making a licensing decision.

Frequently asked questions

What do we actually get for $950?

A written report, typically 6–10 pages: target platform recommendation, migration method recommendation, blocker register, dependency map, Azure sizing and storage recommendation with a licensing cost comparison, a measured connectivity finding, a performance baseline, and a fixed-price migration quote with the cutover window stated in minutes — plus a 60-minute walkthrough. Three business days end to end, for up to three SQL Server instances.

Why is this not free? Other vendors offer a free assessment.

Because a free assessment is a sales call, and it produces a proposal rather than findings. Charging for it means we spend three days on your environment instead of an hour, and it means the report is yours — including the parts that say don't migrate, or migrate somewhere other than what we would prefer to sell you. If you want a free conversation first, that is exactly what our 30-minute discovery session is for, and it will tell you honestly whether this assessment is worth $950 for your estate.

Do we have to use you for the migration?

No. The report is written to be actionable by any competent SQL Server team, including your own. It is not a proposal with findings attached. If you do proceed with us, the migration is a separate fixed-price engagement quoted directly from the report.

Will you recommend an Azure VM just because it is the easiest thing to sell?

The report states which alternatives were considered and why each was ruled out, so you can check the reasoning. Managed Instance is the better answer for a meaningful share of estates and Azure SQL Database for some; the report says so when it is true. We publish separate migration services for all three targets, so the recommendation does not cost us the engagement either way.

How is this different from the Azure Migrate datacenter assessment?

Scope and depth. The Azure Migrate Datacenter Discovery and Assessment looks at an entire server estate — VMware, Hyper-V, physical — and answers what should move to Azure at all, with SQL Server instances discovered and inventoried along the way. This assessment goes inside the database engine: feature usage, data types, jobs, logins, linked servers, the compatibility surface of each Azure SQL target, and the method that gets you there with a cutover window in minutes. Estates that need both usually run the datacenter assessment first and this one for the databases it flags.

SQL Server 2016 is out of support. Does that change the answer?

It changes the urgency and sometimes the target. SQL Server 2016 reached the end of extended support on 14 July 2026; Microsoft's current guidance is that Extended Security Updates for it are a paid subscription and — unlike 2012 and 2014 — not free for running on an Azure VM. Moving to a supported SQL Server version on an Azure VM ends the ESU question for that version; moving to Managed Instance or Azure SQL Database ends the version treadmill altogether. The report lays out both paths against your estate. Verify the current lifecycle terms on Microsoft's pages before you commit — they are Microsoft's to change.

How long does it take?

Three business days from the completion of collection. Kickoff to report is typically one calendar week including scheduling.

Do you need sysadmin access to production?

No. `VIEW SERVER STATE`, `VIEW ANY DEFINITION`, and read access on the in-scope databases is enough. If your policy does not permit external access at all, your staff can run our collection scripts and return the output. Least access is how we work on every engagement, not a concession for this one.

Will this touch production?

Collection is read-only and runs against system catalog views and DMVs. It does not install anything, change configuration, take locks on user data, or generate meaningful load. It can be run during business hours.

What if you find something that means we cannot migrate?

Then you have saved the cost of finding out during a failed cutover. The report states the blocker, the remediation required, and the effort involved — for example, tables without primary keys in a vendor schema you are not permitted to modify, which rules out some methods but not others; or FILESTREAM in one database, which rules out Managed Instance for that database but not for the rest of the estate.

We have already decided on an Azure VM. Is this still worth it?

Yes, and it is the more common case. Even with the target fixed, the assessment decides the method, the sizing and storage layout, the licensing route, the blocker list, and the achievable cutover window — which is what makes a fixed-price migration possible at all. If your estate is one small database and the cutover window does not matter, say so on the discovery call: a fixed-price single-database copy to an Azure VM may be the better product, and we will tell you.

Can you assess more than three instances?

Yes. The standard fee covers up to three SQL Server instances; larger estates are scoped and quoted in writing before we start.

Didn’t find your question?

Ask it here. A real engineer answers by email within one business day — and if it’s a good one, it becomes part of this page so the next person finds it.

Answered by a person, one time, to your inbox. Nothing you type here is published without a human reviewing and anonymizing it first.

Often combined with

$950 per project
3 days
Book the assessment