After I imported a database this option is not enabled, I guess that I should import the latest version database and in the project properties, I select the version the Client has, in that way when I deploy it will generated the SCRIPT with the differences only, right?<br/><br/><hr class="sig">MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/© 2009 Microsoft Corporation. All rights reserved.Tue, 30 Jun 2009 16:26:25 Z8782ae21-a858-4650-be55-ed1b7a2c1c92http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#8782ae21-a858-4650-be55-ed1b7a2c1c92http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#8782ae21-a858-4650-be55-ed1b7a2c1c92Luis Esteban Valencia Muñozhttp://social.msdn.microsoft.com/Profile/en-US/?user=Luis%20Esteban%20Valencia%20Mu%u00f1ozAfter I imported a database this option is not enabled, I guess that I should import the latest version database and in the project properties, I select the version the Client has, in that way when I deploy it will generated the SCRIPT with the differences only, right?<br/><br/><hr class="sig">MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/Tue, 30 Jun 2009 13:52:10 Z2009-06-30T13:52:10Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#56a76016-2520-4891-b03b-7ebb6a109203http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#56a76016-2520-4891-b03b-7ebb6a109203JoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFT<p>Luis,<br/><br/>We only allow to import a live database into an empty database project, so this option won't be enabled if you've imported once, or you have existing schema objects in the project. <br/><br/>When you deploy, you have to specify the target server and database (connection) in the project properties. Depending on the status of your project and the target database, the deployment engine compares these two, and generates the diff script for you.  If the target database does not exist on the server at the time of your deployment, the deployment engine will generate the script to create the database. There are also numerous options you can set in the project properties that could affect the actual deployment scripts. <br/><br/>Let us know if you have another other question. <br/><br/>-- Joyce </p>Tue, 30 Jun 2009 15:53:27 Z2009-06-30T15:53:27Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#53e53070-58e9-48c3-9b3f-df48c1cbbd36http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#53e53070-58e9-48c3-9b3f-df48c1cbbd36Luis Esteban Valencia Muñozhttp://social.msdn.microsoft.com/Profile/en-US/?user=Luis%20Esteban%20Valencia%20Mu%u00f1ozwhat about if there are new objects I need to import to the project, what should I do? so far, today in the morning I have had to create 5 different databse projects cause I havent find how to<br/><br/>thx<hr class="sig">MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/Tue, 30 Jun 2009 16:09:14 Z2009-06-30T16:09:14Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#b781bd91-1690-41fe-a927-9eba542ed51dhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#b781bd91-1690-41fe-a927-9eba542ed51dJoyceWang_MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=JoyceWang_MSFTYes, you can do it by importing into a new database project. Or, you can script out your new objects from SQL Server side, and use Import Scripts... although this is not a recommended way.  I assume you are still trying to establish your baseline project. <br/><br/>Ideally once you get your baseline project ready, you will do all your database development on the project side, and deploy your changes back to the server, not the other way around. Tue, 30 Jun 2009 16:19:28 Z2009-06-30T16:19:28Zhttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#8b238e56-4de1-4259-bc83-f0ec1ec41676http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/8782ae21-a858-4650-be55-ed1b7a2c1c92#8b238e56-4de1-4259-bc83-f0ec1ec41676Luis Esteban Valencia Muñozhttp://social.msdn.microsoft.com/Profile/en-US/?user=Luis%20Esteban%20Valencia%20Mu%u00f1ozGot It.  Thats a very good idea we were using sql management studio to alter procedures, etc<br/> <br/> Thanks<br/><hr class="sig">MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/Tue, 30 Jun 2009 16:21:18 Z2009-06-30T16:21:18Z