Activity overview
Latest activity by Dan Guzman
SQL Compare command-line bug
I'm using SQL Compare 11.5.7.1288 and ran into the same problem described in http://stackoverflow.com/questions/15664822/redgate-sql-compare-results-differ-using-gui-to-command-line with SQL Compar...
Yes, the alias did the trick. Thanks a lot for your help! / comments
Yes, the alias did the trick. Thanks a lot for your help!
Ambiguous Type Name in System.Threading.dll
I have an application that's trying to use the .NET type System.Collections.Concurrent.ConcurrentQueue, but there seems to be a conflict with a type of the same name in the System.Threading.dll req...
Thanks for the update, Robert. I just installed SQL Source Control 4.0 and didn't see such an option.
The reason I'd like the configurable default is that we have one database that has many partitioned views and member tables. For each view, the number of tables vary by installation target so we only keep a view containing a single table in source control along the member table. These are excluded from visibility using filters. However, developers sometimes forget to uncheck the dependency box when checking in objects that reference partitioned views, and that pulls in the multi-tabled partitioned view and member tables too. I have to routinely clean up the mess. / comments
Thanks for the update, Robert. I just installed SQL Source Control 4.0 and didn't see such an option.
The reason I'd like the configurable default is that we have one database that has many partit...
Is there any more news on this? I too would like the include dependencies default to be configurable.
Thanks. / comments
Is there any more news on this? I too would like the include dependencies default to be configurable.
Thanks.
Sorry, the 100GB in my post was a typo. It should have been 100MB so I corrected it. My apologies for the confusion. / comments
Sorry, the 100GB in my post was a typo. It should have been 100MB so I corrected it. My apologies for the confusion.
System.OutOfMemoryException with large script.
I successfully performed a data compare and saved the script to a file. My next task to run the script using the C# code below but I get an out of memory error when during the BlockLoader.Load met...
Powershell script to update config for change logging
Below is a Powershell script I am sharing with the Redgate community.
This script specifies a change logging database name in the local configuration file so that last Changed By information is not...
Thanks. I'll submit feedback. / comments
Thanks. I'll submit feedback.
Link Static Data with filter?
I have tables that contain a mix of static data and user data. Using the stand-alone SQL Data Compare tool, I can specify filter criteria so that only static rows are included. However, I can't f...