Comments
Sort by recent activity
@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?
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below... <?xml version="1.0" encoding="UTF-8"?> <span><commandline><br></span> <span> <database1>database1</database1><br></span> <span> <username1>username1</username1><br></span> <span> <password1>password1</password1><br></span> <span> <server1>server1</server1><br></span> <span> <database2>database2</database2><br></span> <span> <username2>username2</username2><br></span> <span> <password2>password2</password2><br></span> <span> <server2>server2</server2><br></span> <span> <options>Default</options><br></span> <span> <options>DisableAndReenableDDLTriggers</options><br></span> <span> <options>DisableAndReenableDMLTriggers</options><br></span> <span> <synchronize/><br></span> <span> <include>Table</include><br></span> <span> <include>Table:\[Yadda\]</include><br></span> <span> <include>Table:\[Yadda1\]</include><br></span> <span> <include>Table:\[Yadda2\]</include><br></span> <span> <include>Table:\[Yadda3\]</include><br></span> <ExcludeColumns>Yadda3]$:Status</ExcludeColumns> <b><force/></b><br> </commandline> / comments
Can you try adding the <force/> tag to your XML and see if that fixes your issue? See the bolded text below...<?xml version="1.0" encoding="UTF-8"?><span><commandline><br></span><span> <data...
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details. / comments
@mattkollar can you send me what your command line looks with the argfile switch contents? I have done some work like this so I could probably help if you could give me some additional details.
@jjj, have you reported this to support@red-gate.com? / comments
@jjj, have you reported this to support@red-gate.com?
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt / comments
@Yev, you may want to post this on SQL Prompt's UserVoice. Here's the link: https://redgate.uservoice.com/forums/94413-sql-prompt
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between your source and target and export a report file of the objects that are changing. / comments
There really isn't a way to accomplish this that I know of in SQL Source Control. However, if you have SQL Compare and/or SQL Data Compare, you can use the Command Line tool to compare between you...
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you need? / comments
Yes, you can do this in the Options screen of the Project you setup. There is an option to 'Ignore DML triggers' I do not see an option for ignoring DDL triggers though, but maybe DML is all you ...