Comments
Sort by recent activity
@Jon_Kirkwood I just updated to 4.1.21 and it's still throwing the same error message for coverage in SQL Test. Can you escalate to your team to investigate? Thanks! / comments
@Jon_Kirkwood I just updated to 4.1.21 and it's still throwing the same error message for coverage in SQL Test. Can you escalate to your team to investigate? Thanks!
@Jon_Kirkwood thanks for the response. That answered my question. I think I overlooked it because I thought it was already enabled. As you can see from the screenshot below the radio button looks active but the checkbox isn't checked. Could you have your team correct it so that it appears like the `Add/remove square brackets` when it isn't checked so that the radio buttons are disabled? It's not a huge thing, but would make it look consistent. Thanks again for your help! --Adam [image] / comments
@Jon_Kirkwood thanks for the response. That answered my question. I think I overlooked it because I thought it was already enabled. As you can see from the screenshot below the radio button look...
Who have you been working with at Redgate? / comments
Who have you been working with at Redgate?
@jduval, were you able to get this resolved? / comments
@jduval, were you able to get this resolved?
@rferraton, it looks like they added the ability to filter out those extended properties in SQL Compare 13.6.14.9174, but that version of the compare engine wasn't incorporated until the 7.0.10.8879 build of SQL Source Control. If you upgrade to 7.0.10.8879 or above it should respect those settings. Hope that helps! / comments
@rferraton, it looks like they added the ability to filter out those extended properties in SQL Compare 13.6.14.9174, but that version of the compare engine wasn't incorporated until the 7.0.10.887...
@Ozzie , Can you clarify if you are trying to install it in SSMS or Visual Studio? If you are trying to install it in SSMS 2008, it won't work as that is no longer supported, but you can access it via SSMS 2012/2017 and connect to your 2008 server. Here is a link to the requirements page for SQL Prompt to show you which versions are supported: https://documentation.red-gate.com/sp9/getting-started/requirements / comments
@Ozzie , Can you clarify if you are trying to install it in SSMS or Visual Studio? If you are trying to install it in SSMS 2008, it won't work as that is no longer supported, but you can access it...
@JayVEE, If you are doing this in an automated fashion, like your post suggests (TC/OD) I would then assume you would use DLM Automation plugins to capture the changes and build the deployments that would get promoted to your upstream environments. I believe that is the piece you are missing, if I am understanding your question correctly. If not, please expand on your question. Thanks! / comments
@JayVEE, If you are doing this in an automated fashion, like your post suggests (TC/OD) I would then assume you would use DLM Automation plugins to capture the changes and build the deployments tha...
@Morris, We use TFS + SOC where I work and it is very helpful. It streamlines the tedious tasks of generating and checking in objects. It also helps in identifying objects that have changed. One thing that I would strongly suggest is using the 'Dedicated' model for source control. The 'shared' model seems simple, but it really only works well with very few developers or if code is handled in silos between developers (ie Bob only changes certain tables/procs, Erin only works on other certain tables/procs, and neither Bob or Erin work on the same stuff at the same time). Dedicated does mean you have to figure out how to provide your developers with SQL Server instances, either locally on the developer workstations or somewhere else (server, cloud, etc), but you can generally get that figured out with the Developer Edition of SQL Server for local installs. It's worth it in the long run by not having to worry about people changing the same objects at the same time with different changes. You will really want to understanding branching/merging/conflict resolution as that is a somewhat difficult task, but I can't say if it is better or worse than without SOC. Either way they happen, it just depends on how you coordinate the communication within your team to resolve the changes. / comments
@Morris, We use TFS + SOC where I work and it is very helpful. It streamlines the tedious tasks of generating and checking in objects. It also helps in identifying objects that have changed. One...
@derekt, I think SQL Compare is really the best place to do what you are asking. You could probably figure out a way to manipulate the contents of your transient/working base folders so that you could get the results you are looking for, but it would be problematic and would require you to reset everything afterwards to put it back in a working state. / comments
@derekt, I think SQL Compare is really the best place to do what you are asking. You could probably figure out a way to manipulate the contents of your transient/working base folders so that you c...
@smcpike,The Tab History is stored in %localappdata%\Red Gate\SQL Prompt 9\SavedTabs.db. You could definitely back this file to a OneDrive location, but I don't believe there is a way to permanently store it on OneDrive. Maybe you could change where Windows stored the %localappdata% directory to point to your OneDrive, but I haven't tested that. If you do that, every app that stores data in %localappdata% would store it in that location though. It may or may not work, but thought it was worth suggesting. / comments
@smcpike,The Tab History is stored in %localappdata%\Red Gate\SQL Prompt 9\SavedTabs.db. You could definitely back this file to a OneDrive location, but I don't believe there is a way to permanent...