Tuesday, May 01, 2012 1:51 PM
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?
- Moved by Forrest GuoModerator Wednesday, May 02, 2012 2:42 AM database project question (From:MSBuild)
Wednesday, May 02, 2012 9:34 AMModerator
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
Vicky Song [MSFT]
MSDN Community Support | Feedback to us
- Marked As Answer by Vicky SongModerator Tuesday, May 08, 2012 3:22 AM