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.
Moving a Database to New Hardware With Little Downtime
Moving a database to new hardware with little downtime uses early restore, a maintained log chain, final synchronization, and a tested client switch.
Translating Oracle CONNECT BY Queries to Recursive CTEs
Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.
DACPAC vs BACPAC Quiz: Which File Carries Your Data?
This DACPAC vs BACPAC Quiz asks which file moves a database with its rows to Azure SQL Database. The answer is the BACPAC. A tested script shows what each file describes, and the SqlPackage commands show how to use them.
Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences
Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.