Shared "SQL Server 2005 Project" in Visual Studio 2008 Database Edition GDR 2
Hi after working with SQL Server 2005 databases, I pointed out the GDR 2 extension for Visual Studio 2008 database (our Microsoft representative), which allows you to create SQL Server 2005 Server Project.
As I understand it, this allows you to create a project with all the shared objects (logins that are most useful to me) of the Dev instance. Then, when you create the "SQL Server 2005 Database Project", you can reference the "SharedDev" project and all objects (logins, etc.) will be accessible from your database project (say, MyNorthwind).
I don't understand, when I create a SharedDev project of a SQL Server 2005 Server Project, should I create it from Master on my Dev instance or from Northwind Dev instance?
Anyone have any experience? Searches on MSDN brings up really thin documents. http://msdn.microsoft.com/en-us/library/dd193425.aspx
Perhaps I am over complicating the situation. Thanks to everyone who can tell a little about this.
source to share
You want to create your database from "Northwind" db not from Master. This should result in your project containing scripts that will generate logins on deployment.
The best resource for VSTSDB is here:
http://social.msdn.microsoft.com/Forums/en-US/vstsdb/threads
For what it's worth: Logins are a bit tricky VSTSDB 2008. The tool really shines with object management.
source to share