<p>I'm new to VS DB Edition.  I've toyed around with it for a couple days now, and I'm confused about something.  I may be going about the process all wrong, so please bear with me.<br/><br/>I create a DB project, and I pull down a schema from an existing DB.  Next, I create a DB with the same name on my local instance, point my project at that DB, but when I build the project, it creates an additional DB - this one has a GUID attached to the end of it.<br/><br/>Can someone tell my why I'm getting two DBS?  Seems like I should only need one...</p><hr class="sig">Clint© 2009 Microsoft Corporation. All rights reserved.Wed, 01 Jul 2009 14:34:21 Z65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0bhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0bhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0bNashVegashttp://social.msdn.microsoft.com/Profile/en-US/?user=NashVegas<p>I'm new to VS DB Edition.  I've toyed around with it for a couple days now, and I'm confused about something.  I may be going about the process all wrong, so please bear with me.<br/><br/>I create a DB project, and I pull down a schema from an existing DB.  Next, I create a DB with the same name on my local instance, point my project at that DB, but when I build the project, it creates an additional DB - this one has a GUID attached to the end of it.<br/><br/>Can someone tell my why I'm getting two DBS?  Seems like I should only need one...</p><hr class="sig">ClintTue, 30 Jun 2009 16:19:01 Z2009-06-30T16:19:01Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#0bed8ce3-8531-4483-9a08-1b3b6185c70chttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#0bed8ce3-8531-4483-9a08-1b3b6185c70cJoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFTClint,<br/><br/>Which version of the DB edition are you using? The additional DB with the GUID sounds like VS2005?<br/><br/>Thanks,<br/>JoyceTue, 30 Jun 2009 16:21:45 Z2009-06-30T16:21:45Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#dbc5d6ad-dbc8-44e4-9047-fc9dbb291e17http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#dbc5d6ad-dbc8-44e4-9047-fc9dbb291e17NashVegashttp://social.msdn.microsoft.com/Profile/en-US/?user=NashVegasIt is VS 2008, but we are using SQL Server 2005 Standard Edition.<hr class="sig">ClintTue, 30 Jun 2009 16:43:26 Z2009-06-30T16:43:26Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#7a6882d0-88b4-4f4d-bea0-1bb148f2d4ddhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#7a6882d0-88b4-4f4d-bea0-1bb148f2d4ddJoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFTIs it VS 2008 SP1 without GDR? <br/><br/>If you don't have the GDR installed, it is normal to see the DB with GUID name. That is the design database we were using for design-time validation. We created the design DB when you create a database project. It is not supposed to be change by the users. <br/><br/>You do not need to (manually) create the DB on your target server, in your case, your local instance. The first time you deploy the database project, DB Pro creates the database for you. All following deployments will target to the same database, and only deploy the &quot;diffs&quot; to the server, if you don't change the target database name. <br/><br/>Let us know if you have any further question on this. <br/><br/>Thanks,<br/>Joyce Tue, 30 Jun 2009 17:01:03 Z2009-06-30T17:01:03Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#1857f5f6-f6b5-4969-99a5-875bc6cca191http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#1857f5f6-f6b5-4969-99a5-875bc6cca191NashVegashttp://social.msdn.microsoft.com/Profile/en-US/?user=NashVegasWhat is the best way to tell if I have the GDR version?<hr class="sig">ClintTue, 30 Jun 2009 17:22:28 Z2009-06-30T17:22:28Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#2d47d1ca-6eda-42b2-b5a1-677f364eff11http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#2d47d1ca-6eda-42b2-b5a1-677f364eff11JoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFT<p>In VS main menu, check Help -&gt; About ...<br/><br/>See if you can find Microsoft Visual Studio Team System 2008 Database Edition GDR in the list box.</p>Tue, 30 Jun 2009 17:43:10 Z2009-06-30T17:43:10Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#632367a3-5995-4faa-bb63-2468c8f57c15http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/65b0f7ad-1a78-4b5b-bd84-c20c8aeb8e0b#632367a3-5995-4faa-bb63-2468c8f57c15NashVegashttp://social.msdn.microsoft.com/Profile/en-US/?user=NashVegas<p>thought so, just wanted to make sure.<br/><br/>I don't see it listed, so that must be my problem.</p><hr class="sig">ClintTue, 30 Jun 2009 19:27:07 Z2009-06-30T19:27:07Z