Activity overview
Latest activity by hodgeAG81
Thanks Brian. I have sent you the results file off-line.
Thanks. / comments
Thanks Brian. I have sent you the results file off-line.
Thanks.
Latest update. I uninstalled SQL Compare 7.1.0.197 and reinstalled SQL Compare 7.0.0.835 and it works fine for me now without having the case sensitive option set. / comments
Latest update. I uninstalled SQL Compare 7.1.0.197 and reinstalled SQL Compare 7.0.0.835 and it works fine for me now without having the case sensitive option set.
One of my coworkers is running version 7.0.0.835 and he IS able to do the same compare that I was trying to do without having to set the case sensitive option in the compare project. So there must be something in the 7.1.0.197 release that is causing this issue. I had just upgraded to 7.1 this week.
Thanks. / comments
One of my coworkers is running version 7.0.0.835 and he IS able to do the same compare that I was trying to do without having to set the case sensitive option in the compare project. So there must...
Ok, I rooted around the Red Gate site and came across this: A duplicate object name has been found
SQL Compare displays this message when you compare a database on a SQL Server that uses case-sensitive sort order and you have not selected the Treat items as case sensitive project option; you must select this project option.
SQL Compare also displays this message if you create a snapshot of a database on a SQL Server that uses case-sensitive sort order and you have not selected the Treat items as case sensitive check box on the Create Database Snapshot dialog box.
So I talked to our DBA again and asked about the case-sensitivity of the sort order. This database has its collation order set to SQL_Latin1_General_CP1_CI_AS. The DBA tells me that the CI means case-insensitive.
But, once I checked Treat items as case sensitive project option and re-ran the compare, I did not get an error.
So basically, I have to tell the compare to compare the db as if it is case sensitive when it is not. Could this have something to do with the scripts and not the database?
Thanks. / comments
Ok, I rooted around the Red Gate site and came across this:A duplicate object name has been found
SQL Compare displays this message when you compare a database on a SQL Server that uses case-sensit...
SQL Compare 7.1 database/scripts comparison error.
Hi,
While comparing a database instance against a set of scripts, I get an error saying that one of the sprocs is duplicated. The specific message is "Unexpected error: A duplicate stored procedur...