CODEWITHSUNDEEP
visual-studio-2015sql-server-2014database-projectschema-compare
Rohit Nampelli
Rohit Nampelli

Reputation: 31

VS2015 Database Project: Turn off schema checking

I am trying to create a Database Project in VS2015 and get to build it. But I have errors like SQL71501: User: [UserX] has an unresolved reference to Login [UserX] Options are 1. To turn off any schema checking 2. Add Master Database as a Database project and Add it as a database reference.

I am unable to do (1) because I cannot find any options related to Schema Compare in Tools -> Options -> Database Tools I am able to add the Master Database as a project, but VS doesn't let me Import referenced logins (not applicable to master). Btw, I am trying to import a Sql Server 2014 database.

Upvotes: 3

Views: 1881

Answers (1)

Julius
Julius

Reputation: 1

I am able to add the Master Database as a project, but VS doesn't let me Import referenced logins (not applicable to master)

You should try this

  1. go on "master" Database project, right click, then choose "Schema comparison...".
  2. In an opened window click "Options" (gear symbol)
  3. Extract "Non-Application-scoped"
  4. Mark "Logins" and click "OK"

Now Compare and Update

P.S. Of course before all you should choose you master database and do all other needed staff :).

I hope the answer helped (well it helped at least for me)

Upvotes: 0

Related Questions