What are the challenges you face when working across database platforms? Take the survey
Options

Dropping Schemabinding?

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



Answers

  • Options

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

    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

Sign In or Register to comment.