"CREATE PROCEDURE" vs "CREATE PROC"

Brian Donahue

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
>
>