TFS Continious Integration

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

TFS Continious Integration

Postby ktrainer » Thu Jun 07, 2012 7:42 pm

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>
<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?
ktrainer
 
Posts: 4
Joined: Thu Jun 07, 2012 7:35 pm

Postby GFritchey » Fri Jun 08, 2012 3:22 pm

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.
GFritchey
 
Posts: 7
Joined: Mon Nov 29, 2010 3:27 pm
Location: Massachusetts

Postby ktrainer » Fri Jun 08, 2012 5:55 pm

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.
ktrainer
 
Posts: 4
Joined: Thu Jun 07, 2012 7:35 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 2 guests