Migrating an on-site TFS project to Visual Studio Team Services

Pre-reqs:

• You need git on your PC.
• You also must install the git-tfs tool (https://github.com/git-tfs/git-tfs)

 

 

In Visual Studio Team Services create a new git repository.

The TFS project must be a branch – if not open Source Code Explorer, right click   the project and select “Branching and Merging …” and then select “Convert to branch”

On your PC create a new empty folder.

Open a command prompt, and use the git-tfs utility to create a new local git repo of your TFS project:

C:\ts\temp>  git-tfs clone -d http://yourtfsserver:8080/tfs/yourcollection/ "$/pathtoyourbranch" .

Where http://yourtfsserver:8080/tfs/yourcollection/ is the URL of your TFS collection.

Where $/pathtoyourbranch is the source location of your branch within TFS (get from Source Code Explorer)

Then connect this to your VSTS repo:

C:\ts\temp>git remote add origin https://your.visualstudio.com/xyz/_git/yourrepo

Where https://your.visualstudio.com/xyz/_git/yourrepo is the URL of your new git repo in VSTS.

And push to the repo with this command:

C:\ts\temp>git push -u origin --all

Your code is now uploaded.

 

 

SqlLocalDB.exe

I have SQL Server 2016 installed with Visual Studio 2017.

 

The location of SqlLocalDB.exe is C:\Program Files\Microsoft SQL Server\130\Tools\Binn\

To list instance of Local DB:

sqllocaldb i

To get more detailed status of an instance just add instance name:

sqllocaldb i MSSQLLocalDB

SQLPackage.exe location on VSTS hosted build agent

These locations are too hard to find.

This would be a good place: http://listofsoftwareontfshostedbuildserver.azurewebsites.net/

But failing that, these paths worked for me….

VS2017 agent

C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\140\SqlPackage.exe

VS2015 agent

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe