Work with a Visual Studio Database Project
Can this work if I already have a VS Database project setup? Meaning can this work and interact with a VS Database project so that I can continue working on the actual db in SSMS, but the files get saved to the VS Db Project?
-
Stephen Anslow commented
Looking at the SSDT Videos (Juneau) via the connect surveys (https://connect.microsoft.com/BusinessPlatform/Surveys), SQL Connect and SQL Source Control had better get in on" VS2010 as the ONE-STOP-SHOP" that Microsoft is determinedly heading towards making a reality.
I've been a supporter of Red Gate tools for 6+ years and find them indispensable. HOWEVER, SSDT integration into VS2010 is VERY compelling and, as a SQL Source Control user (SVN, not TFS), I absolutely MUST have integration of SSC into VS2010, cohabiting with SSDT in every possible way.
RED GATE NEEDS TO PUBLISH A ROADMAP THAT ASSURES CURRENT AND PROSPECTIVE CUSTOMERS THAT RG TOOLS WILL BE FULLY INTEGRATED INTO VS2010 FOR SQL 2012. At the very least Red Gate needs to publish illustrated technical papers on the features of VS2010 and SSDT and the integration points SUPPORTED and PLANNED, with dates!
Your public needs to hear from you, Red Gate, with FAR more than the scant "Roadmap" bullet points on the main site. (http://www.red-gate.com/our-company/about/news/ ==> Roadmap)
-
@John - we'll definitely notify everyone if/when we do. In the meantime we're keen to get feedback on SQL Connect and whether this would be a useful extension to Visual Studio. I'd encourage all those who have posted to this forum to take a look and provide feedback - the more use engagement, the easier it is for us to justify database project support! http://www.red-gate.com/products/sql-development/sql-connect/
-
John commented
I would love to have our whole dev team on SQL Source Control, but can't until it supports VS 2010 DB projects. Notify me when it does!
-
@David - Can't you use the schema compare tool in VS to pull changes from your development database to the Database Project? There's no way just yet to sync the files in SQL Source Control with the Database Project files.
-
David Todd commented
We are using the unit testing capabilities of Visual Studio 2010 Premium. If Red Gate cannot support database projects, is there a way to sync the Source Control folder with the DB project in VS?
-
@David - out of interest, what do you currently use for DB unit testing?
-
David Todd commented
This is also essential for us as we are also doing DB unit testing. Without this capability we will have to ditch Red Gate and use the compare tools within TFS.
-
Steve Perry commented
Essential for us since we now have to us VS to unit test most of our database objects.
-
Steve commented
A must have as far as we are concerned
-
Dan-Exceptional DBA 2008 commented
think this would be a great feature offering.
-
Rod commented
Important!!
-
Joey Fortuna commented
To me, this is a no-brainer.Unless you (redgate) are prepared to start building a full-blown competitor to TFS and an rich IDE that can marry DB code and app code, you're creating unnecessary work for engineers that are comfortable with your toolset.
-
John Gagnon commented
I am currently tasked with getting this to work as well on my own. I am guessing no one else has been able to the marry the two technologies up until this point?
-
david commented
A must in my shop. Our developers will not consider using a product that will not work with VS DB project.
-
Eddy White commented
Yes this is a MUST!!
Thanks for considering. -
Peter Schott commented
Love the idea - not sure if it's realistic or not, but I'd be more likely to consider it if this were available.