TFS Project path

Question

My requirement is to automatically deploy my project in a remote machine. Currently my project resides in the TFS server.

In my project I have a folder named Database and I used to add the sql scripts to this folder and checked in the complete solution to TFS. In order to run the script for the remote machine I need to get the latest script from the TFS. So how can get the path of Database folder and associated file (.sql file). I am using tfs api to retrieve the information about project from tfs.

score 0 · Answer 1 · edited May 23 '17 at 12:12

0

I would recommended using Visual Studio DB professional to do that not just a folder in a source control.

See this post

How do I share a database with TFS?

but if you still want to do this with your folder you can use Workspace.Get() with appropriate option

Workspace.Get()

Fore more information see this article

http://msdn.microsoft.com/en-us/library/microsoft.teamfoundation.versioncontrol.client.workspace.get.aspx

edited May 23 '17 at 12:12

Community

1
1

answered Apr 18 '12 at 13:16

Mohamed.Radwan -MVP

2,724
2
16
24

There is no longer a "Visual Studio DB Professional". That functionality is now part of Visual Studio Premium (maybe also "Professional", I'm not sure). – John Saunders Apr 18 '12 at 14:52

score 0 · Answer 2 · answered Apr 18 '12 at 17:52

SQL Server Data Tools 2012 is the latest addition to the Microsoft suite for automatic deployment and synchronization of SQL Schema's.

The Database development tools that ship with Visual Studio are now only part of Visual Studio 2010 Premium and Ultimate.

TFS Project path

2 Answers2