Comments
Sort by recent activity
Can you give a little more detail on what's happening here...
How are you creating the script? Is this via SQL Compare from a DB with the objects to a DB without? There are options in Compare to ignore constraints and keys and so on, but it's difficult to know if this will help you without a more defined example of the problem. / comments
Can you give a little more detail on what's happening here...
How are you creating the script? Is this via SQL Compare from a DB with the objects to a DB without? There are options in Compare to ig...
I'm not sure there is an easy way to work around this issue with Compare unfortunately.
Generally, the recommendation appears to be to specify your constraint names to avoid this issue occurring (see here: http://www.sqlservercentral.com/articles/Naming+Standards/sysgenconstraintnames/765/)
Although SQL Compare has an ignore option for constraint names, this only affects the comparison stage - meaning that if you tick the option and the only difference between two tables is the constraint, then the objects won't be seen as different. However any other change (which leads to the object getting scripted as a difference) will still include the constraints. There isn't a way to exclude them from the sync step. / comments
I'm not sure there is an easy way to work around this issue with Compare unfortunately.
Generally, the recommendation appears to be to specify your constraint names to avoid this issue occurring (s...
Thanks for your post. We already have a feature request to include columns in the sync that were excluded from the comparison, which it sounds like would help here. I don't have a release date or version for this yet I'm afraid, although I think it will be investigated for version 9. / comments
Thanks for your post. We already have a feature request to include columns in the sync that were excluded from the comparison, which it sounds like would help here. I don't have a release date or v...
Unfortunately, I don't believe you can do this right now. We only enable the option on User DBs.
I'd suggest you visit our UserVoice page for Source Control and suggest the feature - if enough other users vote for it, then we can look at adding it in the future. You'll find the page here / comments
Unfortunately, I don't believe you can do this right now. We only enable the option on User DBs.
I'd suggest you visit our UserVoice page for Source Control and suggest the feature - if enough othe...
DIF1891 wrote:
I have this problem. Using SQL Compare version 8.50.12.18.
I'm using an XML arguments file that specifies snapshot1, snapshot2 and scriptfile. SQLCompare does not complain, but no script file is being generated. [image]
If you check molnara's post above, you'll see this was fixed in the 8.50.25.20 version which is newer than the one you have. Please try the latest cumulative patch in the post here: http://www.red-gate.com/messageboard/vi ... hp?t=11077 to see if it helps out. / comments
DIF1891 wrote:
I have this problem. Using SQL Compare version 8.50.12.18.
I'm using an XML arguments file that specifies snapshot1, snapshot2 and scriptfile. SQLCompare does not complain, but no...
No problem, thanks for letting us know! / comments
No problem, thanks for letting us know!
isuruceanu wrote:
I have same issue. Just need diff file. Could some one tell a work around if exists.
Hi,
If you're referring to the "hanging at the end" issue, then the latest patch build should sort that out. Can you download the latest release from the Cumulative Patch stickied thread and see if it helps? / comments
isuruceanu wrote:
I have same issue. Just need diff file. Could some one tell a work around if exists.
Hi,
If you're referring to the "hanging at the end" issue, then the latest patch build sh...
It should do, yes. The other user reported that it resolved the problem, and we've not had other occurrences of this in the new patch as yet. / comments
It should do, yes. The other user reported that it resolved the problem, and we've not had other occurrences of this in the new patch as yet.
Could you post an example of your commandline with all the switches you're using so I can see if I can replicate the problem? If you prefer to contact us directly, please email support@red-gate.com quoting F0041797 in the subject line / comments
Could you post an example of your commandline with all the switches you're using so I can see if I can replicate the problem? If you prefer to contact us directly, please email support@red-gate.com...
OK, so you are comparing the root of svn with a folder stored somewhere else? I'll need to try and replicate this here.
In the meantime, could you increase logging and mail the file over to us? To increase logging, right-click the SQL Compare main window title-bar, and choose "Minimum Log level", then "Verbose".
Re-start the program, then preoduce the error. Now right click again, locate the latest log, and mail it to support@red-gate.com with F0041796 in the subject line.
Thanks! / comments
OK, so you are comparing the root of svn with a folder stored somewhere else? I'll need to try and replicate this here.
In the meantime, could you increase logging and mail the file over to us? To...