 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
Schema comparison - Ignore |
|
There's an item in Ignore section for schema comparison called Delimiters
What is that and how is it supposed to work? My assumption was that it should ignore differences for scripts that refer to objects with the same name but using or not using delimiters like dbo.whatever vs. [dbo].[whatever] but it doesn't seem to do that. Comparison still yields codes marking such as these as (the only) differences.
|
|
Wed Apr 05, 2017 7:17 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I'm not clear on that too. I asked for help and will respond to your question as soon as I get an answer.
|
|
Wed Apr 05, 2017 1:17 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
It should treat dbo.whatever and [dbo].[whatever] as equal if Ignore -> Delimiters is ticket. what's not clear yet, if that's supposed to work like that for object names in definitions only or referenced within procedural code too.
Here is what I mean
declaration:
 |
 |
CREATE PROCEDURE dbo.whatever ... |
vs.
 |
 |
CREATE PROCEDURE [dbo].[whatever] |
procedural code:
 |
 |
...
BEGIN
SELECT * FROM dbo.whatever
END |
vs.
 |
 |
...
BEGIN
SELECT * FROM [dbo].[whatever]
END
|
I'm still trying to get more details on that.
|
|
Thu Apr 06, 2017 1:33 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|