A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith
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 6:14 pm
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: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 1 guest