Settings and activity
17 results found
-
225 votes
We've had a few requests for supporting MERGE statements - https://redgate.uservoice.com/redirect/suggestions/3100622. Would MERGE help this or are you still looking for IF EXISTS on INSERTS? If you'd like to chat about this, please reply.
An error occurred while saving the comment Claudio supported this idea ·An error occurred while saving the comment Claudio commentedWhat's the point of have a "User Voice" section if the most upvoted suggestion was not considered after so many years?
-
52 votesClaudio supported this idea ·
-
72 votesClaudio supported this idea ·
An error occurred while saving the comment Claudio commentedSSMS has serious memory limitations when dealing with large scripts. Making smaller scripts is a must.
-
212 votes
An error occurred while saving the comment Claudio commentedThe same behaviour as F12 shortcut from Sql Prompt would be great
Claudio supported this idea · -
100 votesClaudio supported this idea ·
-
345 votesClaudio supported this idea ·
-
35 votesClaudio supported this idea ·
-
168 votesClaudio supported this idea ·
-
46 votes
-
57 votesClaudio supported this idea ·
-
153 votesClaudio supported this idea ·
-
37 votesClaudio supported this idea ·
-
636 votes
Hi everyone. I have merged some User Voice items on this topic of “filtered” static data, as there was significant overlap. I want to share our current guidance on handling scenarios where you need to version a subset of the columns and/or rows in the table.
With SQL Source control, the best option at this point is to use a post-deployment script for this purpose.
SQL Source Control introduced pre- and post- scripts in v6.3.
A post-deployment script gives you a good amount of flexibility over exactly which rows or columns of data you want to include in your project. Example post-deployment scripts for static data are here: https://documentation.red-gate.com/soc7/common-tasks/working-with-pre-post-deployment-scripts/static-data
If you make heavy use of Static Data, we have stronger support for this in SQL Change Automation.
SQL Change Automation:
- Supports column filtered static data tables in the SCA plugin in SSMS
- Supports multiple post-deployment scripts, in case there is…
Claudio supported this idea · -
18 votesClaudio supported this idea ·
-
86 votesClaudio supported this idea ·
-
18 votesClaudio supported this idea ·
-
131 votesClaudio supported this idea ·
Stephanie, merge is not the same thing.
This "if not exists" is THE most asked feature to Data Compare, EVER.
If it is so important to the users, and it is so easy to do... why don't you just do it?