SSDT Project synchronization

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

SSDT Project synchronization

Postby chadhattabaugh » Wed Apr 30, 2014 9:32 pm

I am trying to use SQLCompare to synchronize a database project for a very large database (over 10K scripts) When I try to load the project in Visual Studio after the compare I receive the following error: " : error : Length cannot be less than zero.
Parameter name: length"

I am running VS2013 V. 12.0.30110.00
and SSDT V 12.0.40403.0
chadhattabaugh
 
Posts: 12
Joined: Wed Apr 30, 2014 9:23 pm
Location: Samtec

Postby eddie davis » Mon May 05, 2014 10:38 am

Thank you for your forum post.

Are you able to reply with the complete details of the exception?

I suspect that deployment phase of SQL Compare has modified a path to an object or folder that your Visual Studio project cannot find. Can you please explain in some more detail how you use SQL Compare?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

more detail...

Postby chadhattabaugh » Tue May 06, 2014 10:25 pm

I am trying to populate a new SSDT project with objects using SQL Compare. I compare my source to the project and apply changes to the project. creates the objects, and adds them to the .sqlproj file, but when I try to open the project I get the following message:

error : Length cannot be less than zero. Parameter name: length in the output window of SSDT

I have screen shots but there is no way to add them to the forum

Incidently, this is not an issue going the other way. I can compare an existing project to a database and push changes.

Chad
chadhattabaugh
 
Posts: 12
Joined: Wed Apr 30, 2014 9:23 pm
Location: Samtec


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest