Setting up Partial Database Projects in Visual Studio 2010 for SQL 2012

Question

I have an old setup where I need 2 copies of a database, one a transaction database and one a replicated database.  In Visual Studio 2010, pointed to SQL 2008 R2 prior to installing SSDT for SQL 2012, I was able to create a partial database project so that I could maintain one set of scripts and deploy the changes to both databases.  However, once SSDT for 2012 was installed, that option disappeared.  I then found a link to a site that looked like an answer (http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/17efb58c-cc12-4fac-8398-496517c2d998), but after following these steps and deploying, the objects aren't being referenced from the original project at all. 

Is there some more detail to this process that I need to know about to actually get this to work?
When will partial projects be available in SQL 2012 deployments through Visual Studio 2010/11?

Answer 1

Hello Gary,

Firstly, as far as I know that in order to "publish" your database project to SQL2012, you need to install SSDT:http://msdn.microsoft.com/en-us/data/hh297027 . Once you installed it successfully, when you click the database project in the VS, you will find an option: Convert to SQL Server Database project... With that option, you can covert your database project to SSDT project. However, once you converted, the Export As Partial Project... option is missing.  

I am sorry that I can't find you any offical document offer us more information when the partial project feature will be avaliable for SSDT project. And I think maybe you can submit one feedback on the Microsoft Connect site to ask the PG group to add this feature back: https://connect.microsoft.com/VisualStudio/content/content.aspx?ContentID=27774

Thanks,

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us