Activity overview
Latest activity by tprudence
Thanks for your response Eddie. I understand we are on the older version; however, we were not encountering this issue before upgrading from 11 to 12. I thought there might be something simple to get it working in version 12 but in the meantime we have implemented a simple workaround which is to implement a filter excluding all XML schema collection. My company already spends a lot on Red Gate licenses. We have licenses for earlier version of SQL Toolbelt including SQL Compare 12, which is what I am using for this process. We also have licenses for SQL Compare 13 standalone; however I was not able to get it working at all with that version because the sqlcompare.exe process crashes completely. Sergio told me it's because I need to use the automation pack for 13, part of the toolbelt, but unfortunately it's not included in my license for 13. At this point, I cannot justify the cost of acquiring additional licenses for this issue. We will live with the workaround. / comments
Thanks for your response Eddie. I understand we are on the older version; however, we were not encountering this issue before upgrading from 11 to 12. I thought there might be something simple to...
XML Schema Collections always show difference when comparing from snapshot with version 12?
We are using version 12 to compare from snapshot to database and to update our databases. It's working well except for XML Schema Collections, which are always showing up a differences and every u...
Sergio, How can we download previous versions of SQL Toolbelt? I got it working by installing latest version of the Toolbelt but it's on trial. I tried activating the license but it won't work with this latest version. Looks like I need to install a previous version but the FTP site doesn't seem to be working. / comments
Sergio, How can we download previous versions of SQL Toolbelt? I got it working by installing latest version of the Toolbelt but it's on trial. I tried activating the license but it won't work wi...
Thanks Sergio! I did get it working by installing the SQL Compare Automation Powershell component of the SQL Toolbelt and then launching SQLCompare.exe from that path. It appears that this is the only component we need on our build server and I can remove full version of SQL Compare (and free that license for a developer).' Might want to work on that error message [image] / comments
Thanks Sergio! I did get it working by installing the SQL Compare Automation Powershell component of the SQL Toolbelt and then launching SQLCompare.exe from that path. It appears that this is the...
Yes we are comparing a SQL server to a snapshot. The GUI tool works fine and we can also run the same process manually and that works as well. This crash only happens when it's kicked off by our automated build process, which uses a service user account which is an administrator on the machine. I enabled log generation and put it below, looks like it happens almost immediately just after the command line arguments are printed. 20:29:33.147|Verbose|Command Line |1 |Argument /filter has value <redacted> 20:29:33.147|Verbose|Command Line |1 |Argument /snapshot1 has value <redacted> 20:29:33.147|Verbose|Command Line |1 |Argument /server2 has value <redacted> 20:29:33.147|Verbose|Command Line |1 |Argument /database2 has value <redacted> 20:29:33.163|Verbose|Command Line |1 |Argument /report has value <redacted> 20:29:33.163|Verbose|Command Line |1 |Argument /reporttype has value 'Interactive' 20:29:33.163|Verbose|Command Line |1 |Argument /scriptfile has value <redacted> 20:29:33.163|Verbose|Command Line |1 |Argument /force has value 'True' 20:29:33.163|Verbose|Command Line |1 |Argument /verbose has value 'True' 20:29:33.163|Verbose|Command Line |1 |Argument /options has value 'DecryptPost2kEncryptedObjects;IgnoreFillFactor;IgnoreWhiteSpace;IgnoreFileGroups;IgnoreUserProperties;IgnoreWithElementOrder;IgnoreDatabaseAndServerName;IgnorePermissions;IgnoreUsersPermissionsAndRoleMemberships;IgnoreSquareBrackets' 20:29:33.163|Verbose|Command Line |1 |Argument /include has value 'Identical' 20:29:33.163|Verbose|Command Line |1 |Argument /logLevel has value 'Verbose' 20:29:33.163|Verbose|Command Line |1 | / comments
Yes we are comparing a SQL server to a snapshot. The GUI tool works fine and we can also run the same process manually and that works as well. This crash only happens when it's kicked off by our ...