Migrate SQL Server to SQL Server
Certified — live-tested pathSame-engine SQL Server migrations are how you move between hosts, clouds, or versions — and they still fail in the boring ways: half-copied tables, stale sequences, missing indexes. DBShifts moves the schema and every row, defers constraints for speed, reseeds counters, and proves the result with row counts and checksums.
Free tier · no credit card
Compatibility level, and the cardinality estimator
A same-version move is a copy. A version upgrade is not, and the reason is the compatibility level of the restored database. Restoring an old database onto a new instance keeps its original compatibility level, so the upgrade appears to work and none of the new optimizer behaviour applies. Raising it afterwards is the real cutover.
The specific hazard is the cardinality estimator rewritten in compatibility level 120. Plans that were stable for years can change, and the change is not uniformly an improvement — a minority of queries regress badly. This is the single most common cause of an upgrade that is reported as slow, and it is why the level should be raised deliberately, with Query Store capturing plans before and after, rather than as an afterthought.
Orphaned users, every time
Logins live at the server level; users live inside the database and reference a login by SID. Restore or attach the database on a different instance and those SIDs no longer resolve, so the users are orphaned: they exist, they own objects, and nobody can log in as them.
The application then fails to connect with a login error that looks like a password problem and is not. Remapping with ALTER USER ... WITH LOGIN takes seconds once you know, and the fix belongs in the runbook, because it will happen on every single move between instances.
If the target is Azure SQL Database, the constraints change
Azure SQL Database is not a hosted copy of the engine. There is no SQL Server Agent, so scheduled jobs need elastic jobs or an external scheduler. Cross-database queries do not work, so any three-part name reaching into another database has to be restructured. USE is not supported in the way scripts expect.
These are architectural, not syntactic, and they are the reason an on-premises to Azure SQL move is a genuine migration while an on-premises to Azure SQL Managed Instance move is much closer to a lift. Establish which of the two the target actually is before estimating anything.
SQL Server → SQL Server conversion notes
Engine-specific rules baked into the conversion and transfer pipeline — verified by live certification of this exact pair.
- TINYINT is unsigned (0–255) in SQL Server — DBShifts widens it on signed targets so 128–255 don't clip.
- UNIQUEIDENTIFIER, DATETIMEOFFSET, MONEY and NVARCHAR(MAX) all have explicit conversion rules per target.
- Wrapped defaults like ((1)) and (N'foo') are unwrapped to portable literals.
Frequently asked questions
Is SQL Server to SQL Server migration production-ready in DBShifts?
Yes. SQL Server to SQL Server is a certified pair: it passes the live certification suite on real SQL Server and SQL Server servers, which checks schema fidelity, row counts, type-aware checksums and paging across batches.
What changes in a same-engine SQL Server migration?
Structurally nothing changes — types map one-to-one. The risks are operational: half-copied tables, sequences left pointing at 1, and indexes that never got rebuilt. DBShifts reseeds counters to MAX(id)+1, defers then rebuilds constraints and indexes, and proves the copy with row counts and checksums.
Can I keep SQL Server and SQL Server in sync after the initial migration?
Yes, until you cut over. DBShifts reads SQL Server Change Tracking, which has to be enabled on the database and on each table. With zero-downtime mode on, the tracking version is captured before the first row is copied.
Go deeper
How We Live-Certified All 49 Migration Paths
The certification harness behind this page's claims.
Why Row Counts Aren't Enough
How type-aware checksum validation works.
Reference
Compared with other tools
Errors you may hit
Ready to move SQL Server to SQL Server?
Set up in under two minutes. Validation and rollback included.
Start Free Migration