Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Compare - Schema |
| Version | 18.0 |
When comparing two schemas we receive a lot of objects with diff count = 1. And it seems that only difference between objects is one linefeed between END and GO statements.
---SERVER 1--- END GO ---SERVER 1---
---SERVER 2--- END GO ---SERVER 2---
I'm using Sql Server and ADS 12.0.16. It would be nice if schema compare had option "ignore whitespace" that would consider these procedures equal.
|
|
78 KB
|
|
50 KB
|
|
33 KB
|
938 B
|
|
142 KB
Hi,
Schema Compare has an option to ignore blank lines. You can turn this on by: File -> Options -> Compare -> Schema Compare -> Ignore Blank Lines. See my attached screenshot of this option and the Schema Compare showing a diff count of 0 when the only difference is a blank line.
Thanks, this is it. Works great. However, wouldn't it be better for user to have these options shown in the schema compare screen at the same time when selecting other parameters. Defaults could be taken from options.
Thanks, this is it. Works great. However, wouldn't it be better for user to have these options shown in the schema compare screen at the same time when selecting other parameters. Defaults could be taken from options.
Hi, I've changed the issue to be a usability enhancement request which we will consider for a future release.
Hi, I've changed the issue to be a usability enhancement request which we will consider for a future release.
We have added this feature in v18, So can I mark this issue as verified.
[SP] Yes
We have added this feature in v18, So can I mark this issue as verified.
[SP] Yes
Verified in ADS v18-dev-191. Please refer latest attached screenshot.
Verified in ADS v18-dev-191. Please refer latest attached screenshot.
Verified in ADS 18-rc-19. Please refer latest screenshot and SQLscript.
Verified in ADS 18-rc-19. Please refer latest screenshot and SQLscript.
Issue #8598 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS v18-dev-191 |
| No time estimate |
Hi,
Schema Compare has an option to ignore blank lines. You can turn this on by: File -> Options -> Compare -> Schema Compare -> Ignore Blank Lines. See my attached screenshot of this option and the Schema Compare showing a diff count of 0 when the only difference is a blank line.