-
Add ability to Merge Static Data
"Take theirs" and "Keep mine" are an all or nothing option, I would like to have more control over this and be able to keep my new records but take the updated, or keep my updated records but take the new records, for example.
17 votes -
Make static data UI sortable / searchable
With 100s or 1000s of tables it becomes quite tricky to find objects in the static data link / unlink UI. Therefore, I suggest adding a search textbox there as well as making the UI columns (name, key, schema) sortable.
7 votes -
Display summary of Static Data differences
When displaying the Static Data differences in SQL Source Control it would be very useful to show the number of records that are Different/Identical/In Database Only/In Source Control Only.
When tables have thousands of records it can be difficult to know the scale of what you’re about to check in or get by just scrolling down a long list. A tab displaying the records for each distinct group would be even better.
3 votes -
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].[tab54Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
-- Identical
INSERT INTO [dbo].[tab54Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
INSERT INTO [dbo].[tab54Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan')
INSERT INTO [dbo].[tab54Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan de')Latest source control version:
-- Only In Source ControlINSERT INTO [dbo].[tab54Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
--…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.
13 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
- Don't see your idea?