Error with Static Data and DDL Triggers

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Error with Static Data and DDL Triggers

Postby gee_cee » Wed Jul 02, 2014 6:26 pm

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â€
Posts: 1
Joined: Wed Jul 02, 2014 5:14 pm

Postby james.billings » Tue Jul 08, 2014 9:42 am

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby GrahamH » Fri Aug 15, 2014 11:19 am

Our latest frequent update should fix this issue. See this page for more information (and the download link for the latest): ... nt-updates

Can you let us know if the fix works for you?
Posts: 6
Joined: Mon Jul 05, 2010 9:59 am

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests