TFS Database Edition doesn't seem to Script Logins

Question

I'm trying to put all our databases in TFS. For this purpose we're using TFS Database edition - I've seen some of the other Dev teams use it and it seems pretty good.

Problem is that it doesn't seem to script the logins - the users are linked to logins which now break due to the logins not being scripted.

As far as I can tell I can't get around this - the Schemas need the users which in turn need the logins.

How do you handle logins in TFS Database Projects?

This is SQL Server 2008.

Answer 1

I haven't worked with the database projects much but I think the way you handle this is using the server project and adding them there.

This MSDN Magazine article talks about some of the new features in GDR which include server projects.

Here is a link to the faq http://msdn.microsoft.com/en-us/library/dd819149.aspx on msdn that talks about server projects a bit as well.