Enable "Treat items as case sensitive" in Command line
claireh
Posts: 14
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:
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
/options:CaseSensitiveObjectDefinition
:lol:
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
-Project Manager
-Red Gate Software Ltd