How can we help you today? How can we help you today?
vincentj
Activity overview Badges (0) Posts (11) Comments (25)

Activity overview

Latest activity by vincentj

Our script checks out the branch from Subversion and then runs a command line comparison to generate the report. The command line looks something like this (with NAnt variable placeholders): "D:\Red Gate\SQL Compare 10\SQLCompare.exe" /f /loglevel:Verbose /scr1:d:\build\Database\trunk\Standard /server2:${sqlcompare.server2} /database2:${sqlcompare.database2} /username2:${sqlcompare.username2} /password2:${sqlcompare.password2} /options:Default,IgnoreIdentitySeedAndIncrement,IgnoreStatistics /reporttype:Interactive /report:${report.filename} Thanks for the tip about the log file. The report ran fine the past few days but we had another failure this morning. The log file doesn't seem to contain any information to help me identify which object is viewed as a duplicate. I looked at the extensive list of files that were processed and there are no duplicates there. Here is a snippet from the log file, maybe it's useful to somone at Redgate? 10:16:21.194|Verbose|Command Line |1 |Argument /force has value 'True' 10:16:21.194|Verbose|Command Line |1 |Argument /logLevel has value 'Verbose' 10:16:21.194|Verbose|Command Line |1 |Argument /filter has value 'D:\build\Database\filters\comparefilter.scpf' 10:16:21.194|Verbose|Command Line |1 |Argument /scripts1 has value 'D:\build\Database\DBReport\Standard' 10:16:21.194|Verbose|Command Line |1 |Argument /server2 has value 'server3' 10:16:21.194|Verbose|Command Line |1 |Argument /database2 has value 'prod3 10:16:21.194|Verbose|Command Line |1 |Argument /username2 has value 'user' 10:16:21.194|Verbose|Command Line |1 |Argument /password2 has value 'pw' 10:16:21.194|Verbose|Command Line |1 |Argument /options has value 'Default;IgnoreIdentitySeedAndIncrement;IgnoreStatistics' 10:16:21.194|Verbose|Command Line |1 |Argument /reporttype has value 'Interactive' 10:16:21.194|Verbose|Command Line |1 |Argument /report has value 'D:\ReportArchive\reports_2013-03-29_10-07\trunk-server3.prod3.html' 10:16:21.194|Verbose|Command Line |1 | 10:16:21.397|Verbose|Command Line |1 |SQL Compare running with option: Default (OK). 10:16:21.397|Verbose|Command Line |1 |SQL Compare running with option: IgnoreIdentitySeedAndIncrement (OK). 10:16:21.397|Verbose|Command Line |1 |SQL Compare running with option: IgnoreStatistics (OK). 10:16:21.444|Verbose|Command Line |1 |Comparing database Scripts.Standard with database server3.prod3... 10:16:24.085|Trace |Source Control Link |5 |SQL Source control link successfully created 10:16:24.085|Info |SQL Compare Engine |5 |Register folder start: D:\build\Database\DBReport\Standard 10:16:24.100|Info |SQL Compare Engine |5 |Script folder database version: SqlServer2008 10:16:24.100|Info |SQL Compare Engine |5 |Script folder database collation: SQL_Latin1_General_CP1_CI_AS 10:16:24.194|Info |SQL Compare Engine |5 |Populate Folder Start. [...processing files...] 10:16:40.774|Info |SQL Compare Engine |5 |Populate Folder postprocessing. 10:16:40.883|Warn |SQL Compare Engine |5 |DBScriptResolver Warning db or server set, not resolving: server1.prod1.dbo.subscriber_to_event 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing triggers. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing functions. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing stored procs. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing #8rg.#Bsg triggers. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing #8rg.#2zg triggers. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing ddl triggers. 10:16:41.227|Info |SQL Compare Engine |5 |Populate Folder postprocessing permissions. 10:16:41.243|Info |SQL Compare Engine |5 |Populate Folder postprocessing bindings. 10:16:41.243|Info |SQL Compare Engine |5 |Populate Folder postprocessing udt fields and params. 10:16:42.055|Info |SQL Compare Engine |5 |Populate Folder postprocessing partition schemes. 10:16:42.055|Info |SQL Compare Engine |5 |Populate Folder postprocessing tables. 10:16:42.071|Info |SQL Compare Engine |5 |Populate Folder postprocessing indexes. 10:16:42.134|Info |SQL Compare Engine |5 |Populate Folder postprocessing fulltext columns. 10:16:42.149|Info |SQL Compare Engine |5 |Populate Folder postprocessing udt scale and precision. 10:16:42.149|Info |SQL Compare Engine |5 |Populate Folder postprocessing assembly dependancies. 10:16:42.165|Info |SQL Compare Engine |5 |Populate Folder postprocessing foreign keys. 10:16:42.165|Info |SQL Compare Engine |5 |Populate Folder postprocessing foreign key fields. 10:16:42.165|Info |SQL Compare Engine |5 |Populate Folder postprocessing trigger order. 10:16:42.165|Info |SQL Compare Engine |5 |Populate Folder postprocessing ddl trigger patchup. 10:16:42.165|Info |SQL Compare Engine |5 |Populate Folder postprocessing role membership. 10:16:42.180|Info |SQL Compare Engine |5 |Populate Folder postprocessing synonym dependancies. 10:16:42.180|Info |SQL Compare Engine |5 |Populate Folder postprocessing dependency stacks. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing messagetypes. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing contracts. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing queue event notifications. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing queues. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing services. 10:16:42.274|Info |SQL Compare Engine |5 |Populate Folder postprocessing extended properties. 10:16:42.305|Info |SQL Compare Engine |5 |Populate Folder postprocessing sanitize dependencies. 10:16:42.337|Info |SQL Compare Engine |5 |Register folder finished: D:\build\Database\DBReport\Standard 10:16:42.462|Trace |Source Control Link |5 |SQL Source control link successfully created 10:16:42.462|Info |SQL Compare Engine |5 |Register live database start: prod3 10:16:42.477|Info |SQL Compare Engine |5 |Populate Live Start, popoptions: DatabaseCollation, DecryptPost2kEncryptedObjects 10:16:42.493|Info |SQL Compare Engine |5 |Populate Live Start, options: Default, IgnoreIdentitySeedAndIncrement, IgnoreStatistics 10:16:42.634|Info |SQL Compare Engine |5 |Populate major version: SqlServer2005 10:16:42.649|Info |SQL Compare Engine |5 |Populate got casing: False 10:16:42.649|Info |SQL Compare Engine |5 |Populate Case Sensitive: False 10:16:44.165|Info |SQL Compare Engine |5 |Populate FulltextCatalogs start. 10:16:44.181|Info |SQL Compare Engine |5 |Populate Fulltext Stoplists start. 10:16:44.181|Info |SQL Compare Engine |5 |Populate Fulltext Stopwords start. 10:16:44.196|Info |SQL Compare Engine |5 |Populate ObjectNames start. 10:16:50.181|Error |SQL Compare Engine |5 |SqlCompareException: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at #8rg.#Ssg.#Glh() at #8rg.#Ssg.#vl(DBPopulationOptions #WXrc) 10:16:50.275|Fatal |Command Line |1 |A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. RedGate.Shared.Utils.CommandLine.FatalExecutionException: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. ---> RedGate.SQLCompare.Engine.SqlCompareException: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. ---> System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at #8rg.#Ssg.#Glh() at #8rg.#Ssg.#vl(DBPopulationOptions #WXrc) --- End of inner exception stack trace --- at #8rg.#Ssg.#vl(DBPopulationOptions #WXrc) at RedGate.SQLCompare.Engine.Database.#crc(ConnectionProperties #Ap8b, #en #5OPb) at RedGate.SQLCompare.Common.CompareEngineExecutor.#DaH(Database #RHc, LiveDatabaseSource #ovUb) at RedGate.SQLCompare.Common.CompareEngineExecutor.#DaH(Database #RHc, DataSource #ovUb) at RedGate.SQLCompare.Common.CompareEngineExecutor.#8bH() at #dRb.#8Rb.#kco() at #dRb.#eRb.#Pao() --- End of inner exception stack trace --- at #namb.#tamb.#q1r(ExitCodes #M6rc, Exception #9Z) at RedGate.SQLToolsCommandLine.CommandProcessor.#Acmb(Exception #9Z) at RedGate.SQLToolsCommandLine.CommandProcessor.#Acmb() at RedGate.SQLToolsCommandLine.CommandProcessor.#ZjD() at RedGate.SQLToolsCommandLine.CommandProcessor.#kcmb() at RedGate.SQLCompare.CommandLine.CommandProcessor.#kcmb() at RedGate.SQLToolsCommandLine.CommandProcessor.#OUb() / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Random error: A duplicate object name has been found
Our script checks out the branch from Subversion and then runs a command line comparison to generate the report. The command line looks something like this (with NAnt variable placeholders):"D:\Re...
0 votes
Random error: A duplicate object name has been found
  1. Community
  2. SQL Compare Previous Versions
We have a script that runs a comparison report between SVN and our production databases to make sure they stay in sync. However, it fails over 40% of the time with this error: A duplicate object ...
2 followers 3 comments 0 votes
Great, thanks! At some point I would like to use the new /include:StaticData feature because it'll help speed up our deployments. Am I going to run into the same error if I try to use that with my filter files? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. can't exclude identical objects?!
Great, thanks! At some point I would like to use the new /include:StaticData feature because it'll help speed up our deployments. Am I going to run into the same error if I try to use that with my...
0 votes
can't exclude identical objects?!
  1. Community
  2. SQL Compare Previous Versions
Why does SQL Compare now include identical objects by default? I'm generating HTML reports that show the differences between Subversion and the production database, and since I upgraded to 10.3 th...
6 followers 7 comments 0 votes
slow performance investigated
  1. Community
  2. SQL Source Control Previous Versions
A while back I posted about SQL Source Control taking a very long time for remote users to link a database. Since then, we've removed some large static tables, upgraded to the latest version of SQL...
1 follower 1 comment 0 votes
temp files taking up lots of space
  1. Community
  2. SQL Compare Previous Versions
Hi, My IT department told me that we were getting disk space warnings on our continuous integration server. Upon investigation, I found that there were 28 GB of temp files in C:\Users\build\AppDat...
1 follower 2 comments 0 votes
I'll check it out, thanks! / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Continuous Integration with Cruisecontrol
I'll check it out, thanks!
0 votes
Hi, I apologize if my reply is untimely. We've had CI running with CruiseControl.Net for quite some time now. CCNet calls a NAnt script which does some Subversion stuff (check out the database scripts, etc.) and then calls the Redgate tools to sync the databases. It works pretty well now, but we did run into some problems along the way. I hoped we could just sync the schema then the data, but it wasn't that simple. We eventually ended up with a 5-step process to sync the database to SVN. I detailed the steps in another post so I won't copy it here. I'm not sure that it's the best way to do CI, but it works for us. / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Continuous Integration with Cruisecontrol
Hi, I apologize if my reply is untimely. We've had CI running with CruiseControl.Net for quite some time now. CCNet calls a NAnt script which does some Subversion stuff (check out the database sc...
0 votes
We're using CruiseControl.Net and NAnt scripts to do our deployments. We have a couple CI environments that are set up to deploy whenever someone commits to Subversion. Our staging environment is the last step before production and deployments are done a little differently. First we baseline it to match Production (by deploying Trunk; we keep trunk in sync with production) and then we deploy the entire release branch to the staging environment. Sometimes if a deployment fails or we find bugs, we need to redeploy, which involves first deploying Trunk and then deploying the branch again. I'm curious if the migration scripts will get deployed again in this scenario (we would like them to be). Update: I tested the above scenario, and it seems that the migration scripts do not get run the second time. I could probably get around this by changing the property so it reflects the first revision of the branch before we do the sync. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare command line and /migrationfolder switch
We're using CruiseControl.Net and NAnt scripts to do our deployments. We have a couple CI environments that are set up to deploy whenever someone commits to Subversion. Our staging environment is ...
0 votes
Hi guys, I've been using SQL Compare and SQL Data Compare to do our continuous integration for a little over a year now, and we too have been finding an increasing need for migration scripts so I'd love to get them working. I tried following the steps outlined in this thread, and I'm getting an error saying "Using source controlled databases requires SQL Source Control to be installed." I'd be interested in hearing the "hacky" way of running this without SQL Source Control since I'd prefer not to install that and SSMS on our build server. I'm thinking that we should ideally expose the repo using a command line switch rather than relying on the xml file. I'd like to cast a vote for the command line feature. We use the command line for all the other parameters so that would work nicely for us. (The XML file is workable, though slightly less convenient.) / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare command line and /migrationfolder switch
Hi guys, I've been using SQL Compare and SQL Data Compare to do our continuous integration for a little over a year now, and we too have been finding an increasing need for migration scripts so I'd...
0 votes
Total activity
49
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
13