Comments
Sort by recent activity
@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...
@BeckyE, Let me know if you still need assistance. We have been using Data Masker for a few months but not hitting it very hard yet. I'd like to help if I can. / comments
@BeckyE, Let me know if you still need assistance. We have been using Data Masker for a few months but not hitting it very hard yet. I'd like to help if I can.
Great addition @NataliS! Can't wait! [image] / comments
Great addition @NataliS! Can't wait!
@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...
@lpribble, have you reported this to support@red-gate.com? / comments
@lpribble, have you reported this to support@red-gate.com?
It would also be nice if the "Error Handling" configuration would give you a list of errors that are common instead of requiring manually keying them in for the 'Ignore listed errors' / comments
It would also be nice if the "Error Handling" configuration would give you a list of errors that are common instead of requiring manually keying them in for the 'Ignore listed errors'