Skip to content
← Customer Feedback for Redgate

Settings and activity

2 results found

  1. BUG: User Defined Table Types with Defaults show as different when they are not.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    pmiskell commented  · 

    In my case, this is caused by "DEFAULT" being passed in as a parameter of the function. Example below:

    Before: fnMySQLFunction(CustomerID, DEFAULT, DEFAULT)
    After: fnMySQLFunction(CustomerID,,)

    Thanks

  2. Add "if exists...drop" option for programability objects

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminRedgate Administrator (Admin, Redgate) responded

    For now, you may be able to use a batch file that executes SQL and drops the objects you want re-created before using the SQL Compare Command Line API. Since the objects are dropped, the synch script will generate CREATE scripts instead of alter.

    If you wanted to create everything from scratch, you could drop and recreate the database, which would generate all CREATE scripts.

    I hope this helps for now.

    pmiskell supported this idea  ·