I'm looking for a way to move all our SQL Server databases (on one server) into source control.
I tried creating a solution, and then adding VS database projects to the solution that correspond to the SQL Server databases.
As I was creating the projects (via importing existing databases) I chose to import security objects.
These security objects are users that need to reference logins of some kind. i.e. in a database project I have a folder
Security with the SQL script:
CREATE USER xxx. The VS debugger underlines this in red and warns me:
SQL71501: User: xxx has an unresolved reference to Login xxx.
To fix this I tried creating a new project called
SERVER, in which I would include server-related SQL files.
- How do I reference this new project from the other database project?