I'm experimenting with a Database Project in Visual Studio 2003. It looks like SQL Enterprise Manager, more or less. Does VS add anything that I can't do in Enterprise Manager (version control of DDL, for example)? Dave
Hi Dave Database Projects offer the ability to store SQL files and Query files in a Visual Studio Project structure which you can add to source control such as Visual Sourcesafe. It also allows you to add a Database Reference to the project to allow running of the scripts against a connection to a live database. For more information about Database Projects, take a look at the following link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vxoriDatabaseProjects.asp?frame=true I hope this helps Mike Visual Studio Data Team http://blogs.msdn.com/vsdata/ This posting is provided "AS IS" with no warranties, and confers no rights. -----Original Message----- From: davem Posted At: Thursday, January 05, 2006 8:01 AM Posted To: microsoft.public.dotnet.datatools Conversation: Database project useful? Subject: Database project useful? I'm experimenting with a Database Project in Visual Studio 2003. It looks like SQL Enterprise Manager, more or less. Does VS add anything that I can't do in Enterprise Manager (version control of DDL, for example)? Dave