May 22, 2009 at 2:57 pm
This may be a noob question, but I'm looking for a good solution:
We have all our DB objects scripted out and stored in TFS. We would like to be able to check them out, make changes to them, test them against the database, and check them back in all from the same spot. Opening the SQL in Visual Studio from TFS is no problem, BUT, is there a way to open them from Source Control explorer into SSMS, or something similar, so we can run them against the DB and see the results? Or maybe an easy way to achieve similar results within Visual Studio? I know we can execute the stored procs via server explorer, and see results, but getting it from there directly into TFS...I can't seem to figure it out.
Thanks!
May 22, 2009 at 3:07 pm
Visual Studio 2008 Database Edition
A.J.
DBA with an attitude
May 22, 2009 at 4:18 pm
You could also do it with Team Suites it is all the Team Development editions in one.
Kind regards,
Gift Peddie
October 18, 2016 at 11:48 am
Note this is a new response on a very old thread. TFS, Visual Studio, and SSMS integration seems to be a holy grail. I haven't found answers anywhere, especially for ss 2012 or 2014.
I like using VS and TFS to pick files and check in/out files but I like using SSMS for editing because I use Sql Complete which is a very handy tool. My solution is to double-click a sql file in a VS database solution and have it open in SSMS automatically. To accomplish this just right-click a sql file in VS and choose "open with". Add a new type "explorer.exe" and give it a friendly name of "ssms" and set it as default. This assumes, of course, that you registered "sql" extensions with ssms in explorer.
Hope this helps.
October 18, 2016 at 3:18 pm
That sounds like it could work! My previous team abandoned this pursuit a long time ago, and I've since switched jobs. However, this may come in handy at the new place...
Thanks!
October 20, 2016 at 6:58 pm
When you open SSMS 2012 and up , there on the splash screen I have seen 'powered by visual studio.' I've not use this version but simply imagined there is TFS integration already there , at least an enhanced TFS plug in to do the SQL development and source control functions from the same environment.
----------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply