Exception Comparing Snapshots via Command Line

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

Exception Comparing Snapshots via Command Line

Postby farreachjason » Mon Jun 18, 2012 8:12 pm

I get the following error when trying to compare snapshots via command line:

Registering data sources
Creating mappings
Comparing
Applying Command Line Items
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 #namb.#tamb.#q1r(ExitCodes #M6rc, Exception #9Z)
at RedGate.SQLToolsCommandLine.CommandProcessor.#Acmb(Exception #9Z)
at RedGate.SQLToolsCommandLine.CommandProcessor.#Acmb()
at RedGate.SQLToolsCommandLine.CommandProcessor.#ZjD()
at RedGate.SQLToolsCommandLine.CommandProcessor.#kcmb()
at #i9G.#wamb.#kcmb()
at RedGate.SQLToolsCommandLine.CommandProcessor.#OUb()


The command line I am running is as follows:

C:\\PROGRA~2\\REDGAT~1\\SQLCOM~1\\SQLCOM~1.EXE /sn1:"C:\\TeamCity\\AccessSentry\\ChangeScripts\\1.0.803\\After_1.0.803.snp" /sn2:"C:\\TeamCity\\AccessSentry\\ChangeScripts\\1.0.803\\Before_1.0.803.snp" /sf:"C:\\TeamCity\\AccessSentry\\ChangeScripts\\1.0.803\\Schema_Changes_1.0.803.sql"

One thing to note is there are no acutal differences, so I don't know if that is what is causing the issue.

Any ideas on what would be causing this exception?

Thanks.

Jason
farreachjason
 
Posts: 2
Joined: Mon Jun 18, 2012 8:05 pm

Postby farreachjason » Wed Jun 20, 2012 9:04 pm

I determined it was the quotes that I had put around the file paths that was causing the issue. Once I removed the quotes it executed successfully.
farreachjason
 
Posts: 2
Joined: Mon Jun 18, 2012 8:05 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests