Home Forums Programming SSDT SSDT Not Updating Database RE: SSDT Not Updating Database

  • Chris Wooding (9/23/2015)


    Yes, we've noticed that it frequently puts superfluous brackets around the default expression in the script so that the resulting constraint in the database doesn't match the project and gets detected as a difference each time.

    The schema compare tool certainly has its idiosyncrasies. It frequently used to identify differences where there were none. I once even used a hex editor to look for differences. Still nothing.

    Also, when updating the target (database --> project) it will often add in a few 'create schema' files, just for a laugh. Even though

    a) They did not appear in the graphical schema comparison window before hitting update, and

    b) There was no difference between source and target (apart from some trailing white space ('ignore whitespace' was selected, BTW))

    The icing on the cake? Create a deployment script and examine it: there is nothing to do with schemas on it. That's a whole load of superfluous fluff, for no apparent reason other than to waste people's time.

    But I still love SSDT 🙂

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.