Activity overview
Latest activity by kenocrates
Indeed, the option is not mentioned in the user documentation either. / comments
Indeed, the option is not mentioned in the user documentation either.
I see the project option new to Compare 8:
Ignore square brackets in object names
Ignore starting and ending square bracket in object names which have been escaped using square brackets. This applies to textual objects such as stored procedures, triggers, etc.
This option allows me to ignore differences I was seeing with Compare 7 where the identifier for a server instance is delimited with square brackets in a query of a stored procedure in only one database being compared. For example, this difference will no longer cause a stored procedure to be considered different:
select * from [dbserver1].dbo.Table1
VS
select * from dbserver1.dbo.Table1
Unfortunately, it is still considered a difference when the delimiter appears in a string to be used in a dynamic query; e.g., the stored procedures containing the following statement will be considered to be different:
set @SQL='select * from [dbserver1].dbo.Table1'; exec (@SQL)
VS
set @SQL='select * from dbserver1.dbo.Table1'; exec (@SQL) / comments
I see the project option new to Compare 8:
Ignore square brackets in object names
Ignore starting and ending square bracket in object names which have been escaped using square brackets. This appl...