Comments
Sort by recent activity
Thank you both for your input.
Brian Donahue, I have located the "disable foreign keys" option and unchecked it. Thank you. Will this cause any foreseeable problems besides the sync failure? Does this mean that I will have to manually select the tables to compare? IE select the dependent tables first, then go back and select the rest of the tables that depended on the first set of tables... or will Data Compare be smart enough to handle that part?
Michelle Taylor, Thank you for this manual fix. There is a really large number of tables and it would be very time consuming to setup. I'm assuming that this is what SQL Compare 6 is doing. Until now, what I've done is created an up to date backup of the existing database that I'm going to data compare into, then perform the data compare against the remote database, then perform a SQL compare between the backup and the original -- fixing the changes made to original.
--John / comments
Thank you both for your input.
Brian Donahue, I have located the "disable foreign keys" option and unchecked it. Thank you. Will this cause any foreseeable problems besides the sync failure? Doe...
Dude, that's awesome! Thank you!!! / comments
Dude, that's awesome! Thank you!!!
Thanks for the suggestion... that did not work however it made me think about the problem a bit more.
I am running windows vista business and the windows firewall is very subjective.
To fix this problem I had to go to the control panel, security center, windows firewall, "Allow a program through windows Firewall", "add program", browse for "C:\Program Files\Red Gate\SQL Data Compare 7\RedGate.SQLDataCompare.UI.exe", make sure that it now has a 'check mark' next to it to be allowed, click 'ok' to save and... done.
Everything is now connecting in Data Compare 7.
Thanks,
John / comments
Thanks for the suggestion... that did not work however it made me think about the problem a bit more.
I am running windows vista business and the windows firewall is very subjective.
To fix this pr...
chris.buckingham, this would normally be an issue however version 6 connects fine.
Michelle Taylor,
Yes, Data Compare 6 works fine.
Protocols are named pipes and TCP on the remote SQL 2005 instance. / comments
chris.buckingham, this would normally be an issue however version 6 connects fine.
Michelle Taylor,
Yes, Data Compare 6 works fine.
Protocols are named pipes and TCP on the remote SQL 2005 instance.