Replicating SQL Server Logins to Cloud SQL
🔒 This post explains why Database Migration Service (DMS) does not migrate SQL Server instance-level logins and how to migrate them safely. It outlines the security, compliance, and identity-modernization reasons behind that design decision and shows a practical three-step approach using Microsoft's sp_help_revlogin script. The guide covers generating hashed-password CREATE LOGIN statements, applying them to Cloud SQL, and resolving orphaned users, while recommending migration to Customer-Managed Active Directory where possible.
