Options

Error with Static Data and DDL Triggers

gee_ceegee_cee Posts: 2
edited August 15, 2014 7:19AM in SQL Source Control Previous Versions
We recently added some DDL triggers to our database and noticed SQL Source Control's script generation when syncing static data has incorrect syntax in it. This means every time we need to update our database static data we have to fail and manually edit the scripts. Attached shows the incorrect syntax and bug happening.

Steps to reproduce and fix:
1. You see new static data is available when you hit “Get Latestâ€
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for posting this. I've run through the same steps and I do indeed get the same problem, therefore I've logged a bug (SOC-6102) to get it looked into.
    You're right that we currently don't expose the Data Compare options in SQL Source Control (although this is something we're investigating adding). For now, I think you'll need to continue manually amending the update script.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • Options
    GrahamHGrahamH Posts: 13 Bronze 5
    Our latest frequent update 3.7.3.177 should fix this issue. See this page for more information (and the download link for the latest):
    http://www.red-gate.com/products/sql-de ... nt-updates

    Can you let us know if the fix works for you?
    · Share on Twitter
Sign In or Register to comment.