SQL Source Control
Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.
If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.
-
Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace is simply not accep
Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace of the tool is not acceptable.
4 votes -
Add Filter to Migration Scripts
Add Filter to Migration Scripts
When you go to create the migration script, you get to choose which commits are part of that script. It would be great to sort the migration script by the product descriptions or tags. When we have multiple commits to a database, and we might commit #project1 and #project 2 back and forth for a month, and instead of having to ctrl click through every other one, it would be great if we could group them together (or filter) and then generate the migration script easier.
4 votes -
Allow users to suppress the commit dependencies warning screen and automatically do not commit the dependencies.
We don't have our schemas in source control so every time we commit code the dependencies screen comes up warning us that the schemas are not in source control. Every time we commit we have to uncheck the box and hit continue. You should allow users to suppress the commit dependencies warning screen and automatically do not commit the dependencies.
1 vote -
Disregard pending changes WITHOUT revert
It can and does happen.. you end up with objects that you know are in production but for whatever reason never got committed and put into a migration script. Or, you just aren't interested in ever putting a certain change live.. maybe they are dev only. Maybe they are irrelevant objects like users. Maybe a naughty dev put stuff live without going through the proper process.
In all the above cases I want to be able to remove the object from my "pending" list *without* reverting. I want to ignore them completely.
I am aware of the ability to filter…
1 vote -
Customize headers, footers and batch footers in migration script
I'm hard pressed to think of any corporation that would take a migration script and run "as is". You will at the minimum have some standard code or comment block to put at the top and bottom of a script.
For example, in our particular place, we check the DB version before running a script (header), and stamp a version on success / error handle (footer).
We also have special statement which we need to put after each batch (where the migration currently places a "GO").
Needless to say, having to manually do this is time consuming. So my suggestion…
2 votes -
On the "Get Latest" page, provide a way to globally un-check all objects
Can you please provide a way to "Uncheck" the entire list of objects on the "Get Latest" tab. I have 100+ objects ( Team of 6 Devs ) to get latest and 3 or 4 objects have issues, so I have to manually uncheck each of the 100 checkboxes and then check just the ones I think are ok to check in
1 vote -
Bug: Changes detected after commit
There are changes detected to a table in the commit screen, but the details show no changes - even after committing this phantom change, the commit screen still shows that table having changes pending. v3.5.6.338 standard. A few things to note about the table that might help to resolve: The table is a partitioned table, with a Geography data type in it, and also has a ColumnStore index.
6 votesHi Brett,
Thanks for reporting this. Could you submit a support request and include the SQL according to our tool as well as that according to SSMS?
http://redgatesupport.red-gate.com/home
Many thanks,
Michael -
Automatic source control migration scripts facilitation/generation/recording.
When using development tools to modify a schema, you can end up having applied a number of changes which cannot be applied without data loss using schema differencing and which need to be included in a migration script.
It would be helpful if there was some form of SQL trace which could monitor schema changes actually applied, and be used to generate a composite migration script.
If I use Enterprise manager, or Red Gate to refactor the schema, it is up to me to remember to save the generated SQL and any other SQL I might write along the way…
1 vote -
right-click context menu
often when right-clicking an object in the Object Explorer, instead of seeing the menu, one of the SQL Source Control objects is 'automatically' selected and triggered.
4 votesHi Aaron,
Are you still seeing this? It sounds strange and not something I’m aware of. If you believe it to be SQL Source Control related please do get in touch with further details to help us reproduce. The easiest way is probably to submit a support request: http://redgatesupport.red-gate.com/homeMichael
-
Add ability to execute all tSQLt tests before commit, if one or more fail abort the commit
Add ability to execute all tSQLt tests when committing the database changes, if one or more fail abort the commit and show error messages.
2 votes -
Ability to commit all databases on a given SQL Instance at one time. No need for per-database commits.
Too much effort involved to commit multiple databases. Need the ability to right-click at the instance-level, and initiate a check-in for all databases with affinity to a source-control provider.
5 votes -
Override the comments italicized text when entering a comment
When committing changes, the text area shows a default message that states: "Type a comment describing your changes..."
It would be ideal if you could override this statement with one of your own in some sort of a configuration file:
Ex: "Comments are required, please reference ticket number before checking in your code..."
Speaking of a configuration file, why isn't there one???
3 votes -
Support SQL Azure for large database development
I know you already declined another request to support SQL Azure on the grounds that you do not recommend using SQL Source Control on a production database, but please reconsider supporting SQL Azure for development.
1 vote -
Git - View Version History in SSMS
Currently we cannot view history of objects from SSMS using Redgate with Git as repository. I think this is a required feature. Also, we cannot add comments while commiting. Can these two features please be considered to be added in future releases.
3 votes -
object revisions
Perhaps this already exists, but I couldn't easily find it by searching. We are using SVN as a backend. When checking in files, the "revision" number seems to be incremental based upon a global revision number, and NOT the actual revision number of the object being checked in.
If I'm creating a brand-new procedure and I check it in, the revision number should be 1??? Not 152 or some other number.
This way, after many changes, of when I want to go back to a prior version, you can easily find it!
Can this please be added?
8 votes -
Allow Filter by object Type
It would be really great if there was an option to filter exclusions from source control by object type in addition to the Schema and Name as it is presently.
3 votes -
Simplify datalink source code repository migration
We recently migrated our svn repo to HTTPS and part of that process was for our devs to update their SQL Source Control datalinks.
We ran into 4 issues:
1) When opening SSMS for the first time, we were inundated by SQL Source Control to update our credentials.
2) After hitting cancel 10 times, we were able to get to the Setup tab. Where we thought we could just edit the existing link, but instead we had to Unlink the database first.
3) After unlinking, all the options on the Setup tab disappeared requiring a restart of SSMS. I can…1 vote -
Support WinMerge for merge process
Hi,
I recently saw the new feature about merging stored procedures in conflicts.
Nice job! Smile
I can see only 2 products supported:
- KDiff3 (Old and with a KDE style UI)
- Beyond Compare 3 (Nice UI but not free)What about supporting WinMerge?
http://winmerge.org/It's Open Source and with a much better UI.
5 votes -
Improve speed of getting latest changes and updating for large databases
It takes 5mins to update the latest changes on my insanely fast computer. Although getting the latest changes are OK but registering base and calculating changes take ages! Please improve :)
28 votes -
prevent timeout on commit changes tab for larger db in shared database model
prevent timeout on commit changes tab for larger db in shared database model
6 votes
- Don't see your idea?
