Competition: What’s your favorite Redgate tool? Enter now.

Enable "Treat items as case sensitive" in Command line

clairehclaireh Posts: 14
edited May 8, 2007 8:22AM in SQL Compare Previous Versions
Please advise how I can enable "Treat items as case sensitive" when creating database snapshot from command line. I kept on getting the following error message.

Serial Number:

Unexpected error: 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.
A duplicate object name has been found. This may occur if the SQL Server that you are registe
ring is case sensitive but the case sensitive option is not set.
RedGate.SQLCompare.Engine.SqlCompareException
at _16._1()
at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties connectionProperties,
Options options)
at _12._1(LiveDatabaseSource )
at _12._1(Int32 )
at _12._1(String )
at RedGate.SQLCompare.CommandLine.CommandProcessor._1()
at RedGate.SQLCompare.CommandLine.CommandProcessor.Run()
at RedGate.SQLCompare.CommandLine.Startup._1(String[] )
Caused by:
Item has already been added. Key in dictionary: "TEST" Key being added: "test"
System.ArgumentException
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at System.Collections.Specialized.HybridDictionary.Add(Object key, Object value)
at _16._25(SqlConnection )
at _16._1()
:roll:

Comments

  • Never mind. I found the answer.

    /options:CaseSensitiveObjectDefinition

    :lol:
  • Claire,

    Sorry about the delay in answering you, I am glad you have found the solution in the meantime. However, that exception should not occur and the message isn't very helpful is it? I will look into getting this resolved.

    Kind regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.