587 results found
-
Commandline Source control
It would be great if we could integrate SQL Source Control with our build scripts. For example a simple command line command to get the latest changes and apply (or script) them to our staging environment would be great. Or a command to commit all changes to source control.
5 votes -
Export / import Link Database configuration setting for shared mode
It is very hard to do manual database link to repository/SVN if dealing with large number of databases (200 plus within one team) across large number of source control group. Every team member has to spend time and carefully map repository folder.
One user perform manual link to repository and his/her/ setting validated by QA Team before distributing link config file (xml) to the user group.
The basic requirement is user should be connected with the DB server and pass the repository path and credential. you may design few screen to navigate and collect user input based on provider input…
11 votes -
Pay attention to case changes in static data tables even if case insensitive collation used
SQL Source Control will not notice case-only changes to data if the column has a Case Insensitive collation (which is the default out-of-the-box for most SQL Server installations). This bit me when I needed to "sentence case" some "ALL CAPS" data but SQL Source Control didn't even notice until I forced the collation on these columns to be SQLLatin1GeneralCP1CS_AS, which seems unnecessary. Maybe a per-table static data option?
44 votes -
Changing a data type used in a SP creates problems
When changing a data type used in a SP (e.g. add a new column to it and commit it). getting latest fails on other linked DBs. You have to drop the SP on the target DB.
The weird thing is that sometimes it works, but most of the times it doesn't. Not sure why the behavior is not the same all of the times...3 votes -
Enable quick access to the source control log
Currently accessing the log of the version control system is very slow.
On a good computer it takes me 20 seconds to open the view history from your menu.To open the same log through tortoise svn it takes me 2 seconds to lokate the ex. "Open working base" under the "Under the hood menu" in Setup and 1 second to launch the tortoise SVN log viewer for the project.
Could you please consider adding a possibility to either open the history quicker, or alternatively allowing the user to open the version control log in an external viewer.
Maybe there…
3 votes -
Unlinking database from source control takes forever
When I unlink the database from redgate source contriol SSMS does not respond and it takes more than 10 mins to do.
6 votes -
Need to disable Source Control.
Need to disable Source Control. It causes way too many errors and slowness. I only actually need to use it once every 2 weeks when we commit our work, but it runs all the time, and causes a lot of frustration.
30 votes -
share information about environment between red-gate tools
SQL Source Control and SQL Prompt may not know about an environment (i.e. a developer not having access to staging or production server) and there's not really a facility in either tool to store information about the version of any environment.
Thus, SQL Source Control has to ensure backward and forward compatibility when creating migration scripts - which then triggers Code Analysis Errors in SQL Prompt...! It is a mess to clean up, and frankly a waste of time.
I suggest a feature where I can define my environments in the Tab Coloring in SQL Prompt including a listing of…
1 vote -
Upgrade AppData path when installing Upgrade
I've been told this is by design: When upgrading SQL Source control from say v5 to v6 all of the source control linked db configs are left behind in the previous AppData folder (%localAppData%\Red Gate\ SQL Source Control 5\ in my example) not moved to the new upgrade version folder (%localAppData%\Red Gate\ SQL Source Control 6)
This leaves a history of folders in every users profile, and for us 'from the beginning' users I've got v3-v6 folders that I shouldn't need.
I'm told this is for Network and rollback reasons.
I suggest a checkbox or some such thing during the…
3 votes -
Source Control Migration Scripts - Ability to add before or after main block
Presently a standalone migration script runs before the main block. This seems odd as the point is to migrate data and for that you need schema to be in place.
I would like to be able to add standalone migration scripts to the end of the main block.
We ship databases with some data populated. (This is not simple static data that can be managed using linked tables). We ship for example some out the box entities such as Roles, A base User, a base Organization etc. They have circular references so to insert we have to turn off table…
10 votes -
Change the icon in ssms for the tables that are linked as static data.
When you link a table as static data in Sql Source control it would be nice if the static tables were easily identifiable under the tables node in management studio.
28 votes -
Option to disable object locking from the GUI
We have found that Source Control object locking can cause severe lag and even instability in SSMS for distant servers. The additional lag affects the SSMS Object Explorer contextual dialogs (right-click). Often the dialog will timeout and fail to render or multiple tries. Although we are able to disable object locking via the RedGateSQLSourceControlEngine_EngineOptions.xml file it would be much nicer to have control from the GUI. This could be in the form of a global on/off switch, or could even add functionality to blacklist certain servers. Alternatively, you could build in some kind of functionality to detect servers…
1 vote -
Allow filter rule changes to be undone or a filter to be enabled\disabled
Changing a filter adds it to the commit tab, but the filter changes cannot be undone - which is a catch 22. If you ever want to undo filters so you can do some manipulation you should be able to undo these changes.
So, the suggestion is either
1. Add undo functionality on a filter
or
2. Add enable\disable functionality to filterI think undo should be there, because once it's in the commit changes tab there is no way out - unless you either unlink and link again or just commit or even worse, put the changes back manually
12 votes -
Refresh SQLPrompt after get latest
After running get latest refresh intellisense and sql prompt cache.
3 votes -
Stop forcing acceptance of Database Comparison options in Get Latest tab
Long time user of Redgate Source Control and a really annoying feature is when I'm on the Get Latest tab and there is a change to the Database Comparison options in source control. I can only select the Database Options changes to Get Latest. I cannot opt to get any of the other objects until I 'get' the database options from source control. This is not what is needed. The choice of whether I get the database options should be down to me and I shouldn't be forced to do it. Please make it the same as all other objects…
4 votes -
Allow selection of which SSMS instances to install SQL Source Control
Given the size of our databases, SQL Source Control is VERY slow, frequently locking up SSMS for a minute or more.
As a result I'd like to (say) use SSMS 2014 for SQL Source Control, leaving SSMS 2017 free to work with.
Could we please have the option of choosing which SSMS instances to install it against?
4 votes -
Add a "Check Static Data" now button to the "Get Latest" tab when auto-check of static data is unselected
We have a rather large schema with numerous static data linked...
When I turn off the automatic check of static data, the Get Latest and commit refresh operations take only seconds!! (Awesome!)
When i turn ON auto check of static data, it takes almost a minute (yawn!).It would be really great if I could have the best of both worlds... Do not automatically check static data, but manually check it as I see fit with a separate button on the GetLatest tab that says "check static data now" or something.
4 votes -
SQL Source Control - Filter
We are a shop that have multiple systems for clients that we managed from within a single database, using a separate Schema for each system.
I would like to be able to link a TFS database to a filtered list of objects (preferably) an entire schema but I could see where others might like just a subset of other objects.
If this is currently possible please let me know but I do not see a way to accomplish this without having a separate database for each system per client.
14 votesThis is possible using filters.
-
migration scripts
When re-linking databases to source control, there is a warning message about loosing all uncommitted migration scripts, with only a OK/Cancel option. It's seems there should be an option for 'take me to the commit page' so that I can commit those scripts, then re-link.
2 votes -
Add the ability to use windows certificate store to avoid error "A certificate is required o complete client authentication"
Bitbucket allow to use Selfsigned certificate but you need to add on the server trusted store. With the Bitbucket version 5.3.1 the Source control when push is throwing an error "failed to send request: A certificate is required o complete client authentication". and souce control doesn't have the ability to use trusted store.
5 votes
- Don't see your idea?