Options

Dropping Schemabinding?

davesbrowndavesbrown Posts: 8 Bronze 1
in SQL Compare
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



Tagged:
· Share on Twitter

Answers

  • Options
    Pete_RuizPete_Ruiz Posts: 123 Silver 4

    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
    · Share on Twitter
  • Options
    davesbrowndavesbrown Posts: 8 Bronze 1
    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
    · Share on Twitter
  • Options
    Pete_RuizPete_Ruiz Posts: 123 Silver 4

    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

    · Share on Twitter
Sign In or Register to comment.