Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
Comparing Two Copies of a Table With CHECKSUM_AGG and HASHBYTES
Use CHECKSUM_AGG for a quick table-copy signal, then compare canonical HASHBYTES values and key ranges to locate real data differences.
BACPAC or Backup: When an Export Is the Wrong Tool
A BACPAC export has rows in it, but it is not a recovery backup. Here is a small demo that shows the difference.
Moving Databases to a New Server Behind a SQL Server Alias
Move databases behind a SQL Server alias or DNS CNAME by planning name redirection, backup and restore, Kerberos SPNs, and connection tests.
Moving From LocalDB to a Real Instance
Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.
Explicit Identity Values: Loading Rows With Their Old Keys
Moving rows and keeping their old keys? Here is the safe order of steps, and the counter check that saves you from a collision.