VS 2013 SSDT Cannot build database project.... RRS feed

  • Question

  • I'm using VS 2013 with SSDT Tools for SQL Server 2014. I've imported a database without the login permissions. I removed the create login scripts, but i have schemas associated to logins (CREATE SCHEMA ... AUTHORIZATION loginname)....Anyways. If i remove the schema scripts, then when building with TFS, its going to think i want to drop the schemas.  If i add the schemas along with the logins I get a build error saying SQL71501: User: [] has an unresolved reference to login loginname. I don't want to use the schema compare tool because i want TFS/Build Server to build the scripts/packages for me. Please help.

    Monday, April 28, 2014 10:50 PM

All replies