TFS Continious Integration

ktrainer

I am setting up continious integration using TFS. I not clear on how I can use SQL COmpare command line to compare a DB in TFS to a target DB Environment. I tried:

sqlcompare.exe /sourcecontrol1 /versionusername1:<myuser> /versionpassword1:<mypwd> /revision1:head /scriptsfolderxml:testSC.xml /mksnap:tale.snp

Contents of testSC.xml:
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="TfsLocation">
<ServerUrl>http://gdcdevtfs01:8080/tfs/genesis</ServerUrl&gt;
<SourceControlFolder>$/Everest/Main/DB/Tale</SourceControlFolder>
</ISOCCompareLocation>

I get the following error:
Unexpected error: Object reference not set to an instance of an object.
Object reference not set to an instance of an object.
System.NullReferenceException
at #i9G.#n9G.#1tD(String #p9rc, DataSource #ovUb, Options #5OPb, Boolean #q9rc)
at #i9G.#wamb.#lMPb()
at #i9G.#wamb.#kcmb()
at RedGate.SQLToolsCommandLine.CommandProcessor.#OUb()
at #i9G.#OsPb.#6sc(String[] #ead)
Obviously I am missing something. Any ideas?

GFritchey

I'm just getting going on a few of these things myself. I noticed this right away:
http://www.red-gate.com/messageboard/vi ... sfolderxml

You might want to update real quick. This only came out yesterday.

ktrainer

Thanks. I saw that yesterday as well and upgraded. The problem seemed to be the MKSNap switch in the older version which was fixed in the new version. I have things working now and am still exploring...

I seem to be having weird connection issues when I try and access the DB, it says it logs in but nothing on the other end. But I think that maybe something related to the DB.