Dropping Schemabinding?

davesbrown

We have some functions that are defined "With Schemabinding" and when deploying including dependencies, RG Compare creates scripts such as

PRINT N'Removing schema binding from ...

...

ALTER FUNCTION ...

(

...

)

RETURNS Table
WITH
RETURN
(
    SELECT

...

But this is obviously a syntax error.  Am I missing some options somewhere?  Thanks

Pete_Ruiz

Hello @davesbrown

Thanks for reaching out and sorry that you're having trouble with SQL Compare.

I tried a few scenarios on my end to try to try to replicate this but no luck.

Can you please provide CREATE scripts for the function as it appears in the source as well as in the target so we can try and replicate this?

Kind regards,

Pete Ruiz

Product Support Engineer

davesbrown

He @Pete_Ruiz

Thanks for the reply.  I think we solved the issue with some overlooked filters and checking deploy with dependencies; we had some dependent views.

Thanks,
Dave

Pete_Ruiz

Hello @davesbrown

That's great news. Glad you were able to resolve the issue.

Please reach back out if anything else comes up.

Cheers,

Pete Ruiz

Product Support Engineer