Red Gate forums :: View topic - Feature Suggestion (Source Control)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Feature Suggestion (Source Control)

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
steve@powell.net



Joined: 16 Sep 2009
Posts: 5

PostPosted: Wed Jan 30, 2013 5:41 pm    Post subject: Feature Suggestion (Source Control) Reply with quote

How about a simple write all the scripts out onto disk?

I'm having a hellish time getting TFS to work. Could be SourceControl Could be SSMS and the fact I'm trying to integrate it into TFS2012.

My visual studio poject is submitting to TFS just fine. It includes lots of directories with the SSIS project, SSAS project etc... in (Can you tell that its a BI solution?)

So I wondered why not just write all the scripts out to another directory alongside the SSIS/SSAS project and then I could submit that via Visual Studio.

But SQL Source Control doen't have the option. This should be a piece of cake to do as its just writing the stuff out to disk and then don't execute a commit hook.

As a brute force way of getting a copy of the DB scripts this would be a great fall back position to have

regards

Steve
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Fri Feb 01, 2013 6:03 pm    Post subject: Reply with quote

Is it the linking of the database to your TFS folder? If so, what is the error message?

It might help if you described to us your folder structures.

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
steve@powell.net



Joined: 16 Sep 2009
Posts: 5

PostPosted: Fri Feb 01, 2013 9:01 pm    Post subject: Reply with quote

The issue linking my DB to TFS seems to be that SSMS for 2008R2 SP1 is choking when it tries to connect to TFS. Its giving me an error

TF400324: Team Foundation services are not available from the server

https://myname.visualstudio.com:8080/defaultcollection
Unable to connect to the remote server.

I have edited the config file as instructed though the instructions are frankly a bit rubbish. Seriously, read that page and see how much sense it makes.

Look at Andy Leonards blog post about it

http://sqlblog.com/blogs/andy_leonard/archive/2012/10/08/redgate-sql-source-control-and-tfspreview.aspx

This is much clearer about what the config file should look like once you're done.

The URL I am using is identical to the one that is working in Visual Studio team Explorer.


Actually I just tried something stupid. I removed the port number from the URL and it now seems to be working. Very Happy

I am such an idiot! :oops
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group