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.
To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates
-
Agent jobs could be source controlled if we were able to select system tables as static data.
To allow us to add SQL Server Agent jobs into source control, allow us to select system tables as static data.
At least dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules in msdb1 vote -
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 -
Include sys.message custom messages in static data
The deprecated RAISERROR, and newer THROW T-SQL instructions can use custom (user-defined) messages written into the sys.messages table using sp_addmessage.
Since these are part of the "source" of a database in SQL Server, and should be syncronised across developers and implemented in production, it would be nice if the custom messages saved in this table can also be added to the static data in a repository.5 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 -
Allow SQL Source Control to visualize static data potentially hidden by Row-Level Security
While comparing static data in SQL Compare, there might occur a "red herring" issue where SQL Source Control cannot see filtered table-data due to being read by a user unprivileged for Row-Level Security. Since SQL Source Control cannot see the table-data, it will then suggest to either
a) Fetch all table-data from the linked repository (causing all kinds of PK- and other constraint issues)
or
b) Commit the deletion of all table-data to the linked repositoryWe don't want to do either of these actions. Although bypassing Row-Level Security for an unprivileged user isn't possible, it is still possible for…
1 vote -
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 -
Keeps detecting changes for value s'
Hello,
I have a table with only one PK column of type nvarchar(200) which contains static data.
Source Control keeps telling that there are changes even after saving the changes. It seems that it has some issues with the value s'Database version:
-- Only In DatabaseINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
-- Identical
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan')
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan de')Latest source control version:
-- Only In Source ControlINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
-- IdenticalINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
INSERT INTO [dbo].[tab_54_Voorvoegsels]…3 votes -
Hide columns for System Version Tables
We are using System Versioned Tables, and on these tables SQL server adds 2 new columns SysStartTime and SysEndTime. These columns are typically marked as hidden and we need a way to ignore comparison for these. Either by a column level filter, or an option to ignore system versioning columns
3 votes -
I would like to be able to pause scanning a database for changes. It is trying to do 3 at the same time with on being really.
I would like to be able to pause/start scanning a database for changes as will. It is trying to do several at the same time right now and one of them is huge which is taking longer than it should. If I could only scan the one I am working with at the moment it would save me time system resources.
1 vote -
Exporting Multiple Tables from the results pane to seperate Excel Tabs
The open in excel feature is impressive and I love to use it for ad-hoc extracts. Having the ability to extract multiple results in 1 go to a single Excel file with different sheets would be great.
1 vote -
Support unicode characters in data scripts Arabic for example
When linking static data to source control the unicode characters are appearing as question marks
so please add the support for the unicode characters in the script files10 votes -
Allow a pre and post scrip to run on SQL Data Compare
Sometimes I need to write scripts to run before and after a SQL Data Compare.
10 votes -
Functionality after restore from command
After we have run a restore database command, the source control do not notice, that some, earlier loaded stored procedures from lastest version are after that newly out of date.
Source countrol should recognize a restore and scan completely new for the latest changes.4 votes -
5 votes
-
Warn when adding static data tables that have foreign keys
When adding a static data table to source control, there should be a warning if that table has a foreign key constraint on another table and give the option to include that table as static data also. As it is the error you get in SQLCI is quite hard to decipher when SQL Source Control is used in conjuction with SQLCI.
3 votes -
Removing column does not generate update in static data
If a table is setup for static data, and you remove one or more columns from that table, the static data is not updated in the working directory when "Saving changes".
7 votes -
allow copy names from result Cell by Cell
allow copy names from result Cell by Cell
Like if we want to copy only object name it should allow.3 votes -
Show number of rows and columns when adding static data
When adding static data from a large system it would be wonderful to be able to sort on a column stating how many rows the table contains!
3 votes -
some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.
We have thousands of tables (some with millions of rows) with only 90-100 static data tables.
At the moment, I have to edit the project; untick all then tick 90-100 manually which is very time consuming.
If there was some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.
Thanks for your response.
Regards
11 votes -
Remove <Count> node under <DataFileSet> for static data files
Currently the RedGateDatabaseInfo.xml file has a node called <DataFileSet>, underneath which is a node (<DataFile>) for each table that is static data tracked.
The top node under the <DataFileSet> (before the individual <DataFile>'s) is a count of all the <DataFile> nodes below.
Can this count be done in the code?
I am forever solving merge conflict that are just that count node having the wrong value.
6 votes
- Don't see your idea?