Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Users are not created when checking out for the first time

I've checked in a database with users, roles, tables, stored procs etc.

I've then created a new database, linked it with the repo, tried to get latest and it throws an error. The script tries to create the roles and assign users to the roles but it never creates the users. Looking through the repo, the scripts to create the users exist, but source control isn't trying to create them.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Philip Flynn shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminPeter_Peart (Admin, Redgate) commented  ·   ·  Report

    Hi Philip,

    Thanks for your post. SQL Source Control should create the users however it won't create logins as these are at the server level rather than the DB level.

    I've opened up a support call for you though and will be in touch with you directly to confirm about the users.