Enable "Treat items as case sensitive" in Command line

claireh

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:

claireh

Never mind. I found the answer.

/options:CaseSensitiveObjectDefinition

:lol:

JonathanWatts

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