-
Title
Schema compare tool is not detecting differences in procedure scripts except changes to parameter -
Description
Various situations in which two similar but different procedures are compared, are not picked up as differences when compared in Toad's Schema Compare tool. The only differences that are picked up are differences with the parameter. Other then that, the compare shows that they are the same when they are obviously not.
Ex:
CREATE PROC [dbo].[ToadTest] ( @TestText varchar(50) = 'Toad')
/*************************************************************************************
--Procedure Name: ToadTest
--Tables accessed: None
--Other SP's Called: None
************************************************************************************/
AS
BEGIN
...
Sample attached. -
Cause
Compare is having trouble when there is a hyphen-hyphenapostrophe combination in the script.
-
Resolution
WORKAROUND:
Remove the hyphen-hyphenapostrophe combination.
STATUS:
Waiting for fix in a future version of Toad for SQL Server. -
Attachments