Hi Alex,
There isn't an option in SQL Compare to ignore the differences in a SQL
statement where you substitute PROC and PROCEDURE. I've passed the
suggestion on, though, and it may appear in a future version if it's
practical to do.
Regards,
Brian Donahue
Red Gate Technical Support
"Alex Rabinovich" <
ARabinovich@agfirst.com> wrote in message
news:
dPxvKpJWEHA.1196@server53...
> SQL Compare considers two stored procedures being different even if the
only
> difference is between "PROCEDURE" and "PROC" keywords as in:
>
> '''''''
> CREATE PROCEDURE usp_myProc
> AS
> SELECT 1
>
> ''''''
> CREATE PROC usp_myProc
> AS
> SELECT 1
>
> Is there any option in SQLCompare to consider "PROCEDURE" and "PROC" to be
> the same keywords?
>
> Thanks
> Alex
>
>
There isn't an option in SQL Compare to ignore the differences in a SQL
statement where you substitute PROC and PROCEDURE. I've passed the
suggestion on, though, and it may appear in a future version if it's
practical to do.
Regards,
Brian Donahue
Red Gate Technical Support
"Alex Rabinovich" <ARabinovich@agfirst.com> wrote in message
news:dPxvKpJWEHA.1196@server53...
> SQL Compare considers two stored procedures being different even if the
only
> difference is between "PROCEDURE" and "PROC" keywords as in:
>
> '''''''
> CREATE PROCEDURE usp_myProc
> AS
> SELECT 1
>
> ''''''
> CREATE PROC usp_myProc
> AS
> SELECT 1
>
> Is there any option in SQLCompare to consider "PROCEDURE" and "PROC" to be
> the same keywords?
>
> Thanks
> Alex
>
>