Comments
Sort by recent activity
Hi @..., Thanks for letting us know. I haven't seen this issue personally but am sorry to hear it's happened to you. The survey has finished up, and a release to remove the survey has gone out to the SQL Source Control "Frequent Updates" channel. If you enable frequent updates, I think you will be able to upgrade to a version where the banner goes away. If you're already on frequent updates or the banner blocks you from updating, please let us know. Kendra / comments
Hi @...,Thanks for letting us know. I haven't seen this issue personally but am sorry to hear it's happened to you. The survey has finished up, and a release to remove the survey has gone out to t...
Update -- I added an example to the page on Filtering itself which describes how to do this - https://documentation.red-gate.com/display/sca4/Filtering Hopefully that helps others in the future. / comments
Update -- I added an example to the page on Filtering itself which describes how to do this - https://documentation.red-gate.com/display/sca4/FilteringHopefully that helps others in the future.
Hi @nharris18, There are two configuration changes you might wish to make: 1) Add a filter file to exclude users. This will prevent SQL Change Automation from scripting users out from the database. I've attached a sample SQL Compare file if that saves you time. 2) Set the project option SyncOptionIgnoreUsersPermissionsAndRoleMemberships to True (default is False / do not ignore these) in your sqlproj file. This will prevent SQL Change Automation from scripting out GRANT scripts for users who are members of roles. If you don't want the users scripted, you probably also don't want their role permissions scripted. Hope this helps and I'll have a look at the documentation to see if there's a sensible place to add this which might show up for folks in search results when they hit this question. Kendra / comments
Hi @nharris18,There are two configuration changes you might wish to make:1) Add a filter file to exclude users. This will prevent SQL Change Automation from scripting users out from the database. I...
Hi @Danr, We don't recommend SQL Source Control for large static data tables. At the heart of the challenge is that data comparison gets slower as the tables you are comparing get larger and wider. This can lead for the plugin to need to use a lot of CPU and memory and also cause the user to wait longer periods for the comparison to complete. For larger static data tables, SQL Change Automation has a "seed data" option which can work well in many scenarios. SQL Change Automation is available as part of the SQL Toolbelt. If you don't have the SQL Toolbelt, you could implement a similar methodology to the seed data option with Flyway if desired. Hope this helps, Kendra / comments
Hi @Danr,We don't recommend SQL Source Control for large static data tables. At the heart of the challenge is that data comparison gets slower as the tables you are comparing get larger and wider. ...