Sharing sdc files

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Sharing sdc files

Postby sroslyn » Tue Nov 15, 2011 4:29 pm

I have created a number projects which I have placed in a folder on a corporate network so they can be shared among team members.

When I open an sdc file, it works fine, but when a teammate does the same, and press the "Compare Now" button, they receive an error about "Registering databases" and "Reading constraints".

They have the same access to the database that I have, so that is not the problem.

Any ideas? Thank you!
sroslyn
 
Posts: 2
Joined: Tue Nov 15, 2011 4:19 pm

Postby james.billings » Tue Nov 15, 2011 5:30 pm

Without the error, it's hard to say. Can you supply some more information as to the error you get, and whether it only happens when users try to run the comparison at the same time?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby sroslyn » Tue Nov 15, 2011 5:47 pm

I've tried to attach a screen shot but an not sure if will work or not.

The errors comes up in a dialog box and says: "Tasks cannot be completed" Then a red X icon and "Registering databases" then underneath that the server name and the name of the first database followed by "Reading constraints"

At the bottom of the dialog box there is also an 'i' in a quote bubble icon, and the message "Unable to cast object of type 'System.DBNull' to type 'System.String'.

Only one user is trying it a time.

Thanks James!

[img]C:\\Documents%20and%20Settings\\roslysh\\Desktop[/img]
sroslyn
 
Posts: 2
Joined: Tue Nov 15, 2011 4:19 pm

Postby james.billings » Tue Nov 15, 2011 5:49 pm

The screenshot didn't work - it may be easier for you to email support directly, as we have a ticket open for this. You can email support@red-gate.com quoting F0054299 in the subject line.

One thing to also check is permissions - is the user(s) getting the error connecting with enough permissions? If they use 'sa' does it work?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests