ALZDBA (6/24/2009)

---

- Be sure to add GDR R2 to your vstedba (datadude) because it adds some nice db-features.
( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed )

FYI: The Datadude's lair: http://blogs.msdn.com/gertd/default.aspx

I'm not yet a user, but I think if you get the grip, you'll be hooked in a positive way

There's more to datadude than only the schema !

Florian Reischl (6/24/2009)

---

Nice article Grant.

I'm still not the best friend of SQL integration in Visual Studio but I think the new database projects become better and better and it seems to be a good way to maintain base structure. Anyway I hope it will become better in Visual Studio 2010 and/or SQL Server 2011...

Thanks

Alexander Kuznetsov (6/24/2009)

---

Grant,

What do I need Active solution configuration and Active solution platform for?
This is a database project, not a C# one, so why am I exposed to and maybe even allowed to select Any CPU/x86/64 at all? These settings are completely irrelevant to my database development, are they not?

How does creating a server project speed up my development?
Could it be faster not to create it at all?

Grant Fritchey (6/24/2009)

---

Yes, the CPU is irrelevant to your project (although I've never tried switching it). But the configuration works to allow you to set up environments and have the settings change on projects to match the environments.

Creating a server project doesn't speed or slow your development. It acts as a placehoder for server level objects, such as Logins. When you make a compound project using the server project, you can then create users that map to logins without errors within the project. Otherwise, if you try to map users to logins, you will get errors.

Alexander Kuznetsov (6/24/2009)

---

I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste my time to "have the settings change on projects to match the environments." Who cares?