HowTo: create users and logins on an SQL server via SSDT

This is the article I was searching for when I was creating my database solutions as code, maybe it is out there written by someone else. Ever since I’m am developing databases and server-side processes for SQL server, I wanted to have all my definitions and configurations in a repository. The goal is to have the complete SQL server solution as code. Ultimately to deploy it with literally one click.

For SQL Server I use the SSDT from Microsoft, really an impressive solution to the aforementioned task. One thing I was always…