Command line + /project switch + source control data source

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

Command line + /project switch + source control data source

Postby JureP » Fri Jul 19, 2013 6:09 pm

Very simple case:

- I have a small testing database with just a few objects linked to the SVN repository.
- I can compare data between different revisions with GUI just fine
- But when I use this same .sdc file as a /project parameter when running sqldatacompare.exe

I get an error:
Error: Object reference not set to an instance of an object.

It is displayed after phases "Registering databases" and "Mapping".

This is happening when either of sources is set to "source control". Comparison between two physical databases works fine.

So my question is: Am I missing something obvious? :? Has anyone else experienced this?

Posts: 3
Joined: Fri Jul 19, 2013 4:45 pm

Postby Brian Donahue » Mon Jul 22, 2013 11:21 am

Hi Jure,

We have indeed had several reports of this and logged it as bug SDC-1337. The problem seems to be that if you specify a repository from the "linked databases" portion of the source control dropdown, this is correctly saved into the project. If you select the repository using the URL, that is not saved into the project.

So the workaround for now is to run SQL Data Compare (UI) on the same PC as the one where SQL Source Control is installed, and refer to the database linked into SQL Source Control, then save the project and use that project in the command-line version.

I hope this helps!
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest