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.

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

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.

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.

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 files

Sometimes I need to write scripts to run before and after a SQL Data Compare.

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.

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.

Add a filter for static data, similar to the feature available in SQL Data Compare. This will facilitate source controlling data for tables that contain a mix of static system data and user content.

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".

allow copy names from result Cell by Cell
Like if we want to copy only object name it should allow.

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!

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

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.

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.

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.

If a table is linked as static data, any changes to the data should automatically be included in the migration script, just as changes to the schema are. Having to write a manual script or use the separate compare tool is extra work, and small changes are easy to miss.