Activity overview
Latest activity by smurtagh
I found the issue with my database. I read on another post about turning on verbose logging (https://documentation.red-gate.com/disp ... +log+files) which isn't immediately obvious as it isn't in the menus. Once I did this an error was logged to the log file (not sure why no error is being displayed or it keeps retrying and getting the same error!):
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: A duplicate definition was found for [dbo].[Getjobtitle]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact Redgate support.
at RedGate.SQLCompare.Engine.ReadFromFolder.ObjectInformationFromDictionary.AddMapping(String fullyQualifiedName, Int32 sysobjectID)
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.PopulateObjectNames()
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.LightWeightPopulate(DBPopulationOptions popOptions)
The server is case sensitive, I'm not sure what the duplicate object is but in the comparison if I select the Options tab and check the "Use case-sensitive object definition" option before selecting the Tables & Views tab then all works ok.
I'm not sure if the case-sensitive option will always be the issue but the verbose logging may help identify the issue. Hope this helps someone. / comments
I found the issue with my database. I read on another post about turning on verbose logging (https://documentation.red-gate.com/disp ... +log+files) which isn't immediately obvious as it isn't in t...
I found the issue with my database. I read on another post about turning on verbose logging (https://documentation.red-gate.com/disp ... +log+files) which isn't immediately obvious as it isn't in the menus. Once I did this an error was logged to the log file (not sure why no error is being displayed or it keeps retrying and getting the same error!):
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: A duplicate definition was found for [dbo].[Getjobtitle]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact Redgate support.
at RedGate.SQLCompare.Engine.ReadFromFolder.ObjectInformationFromDictionary.AddMapping(String fullyQualifiedName, Int32 sysobjectID)
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.PopulateObjectNames()
at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.LightWeightPopulate(DBPopulationOptions popOptions)
The server is case sensitive, I'm not sure what the duplicate object is but in the comparison if I select the Options tab and check the "Use case-sensitive object definition" option before selecting the Tables & Views tab then all works ok. / comments
I found the issue with my database. I read on another post about turning on verbose logging (https://documentation.red-gate.com/disp ... +log+files) which isn't immediately obvious as it isn't in t...
Did you ever get to the bottom of this issue? I have the same issue with a supplier database (rather than master). I have posted the issue again given the age of this issue. / comments
Did you ever get to the bottom of this issue? I have the same issue with a supplier database (rather than master). I have posted the issue again given the age of this issue.
SDC hangs retrieving schema
I've got a strange issue with one of our databases I'm trying to compare using SDC. We've been using SDC for over 10 years and never not been able to compare. I'm a sysadmin on the server and the d...