Activity overview
Latest activity by monty
Comparing against Snapshot causes an error
When you create a snapshot through the SQLCompare utility then attempt to compare an actual databases against it (again through the SQLCompare utility), it throws the exception, "Object reference n...
Error in Synchronization script for SQL 2000
Hi,
We have a custom type 'boolean' in our databases and after comparing two databases (one on SQL 2005 express and the other on SQL 2000), the custom type has been considered to be different.
Howe...
Hi Andras,
My appologies. I was just getting the version number of the SQLCompare utility when I noticed that it was version 3.x. I must have downloaded the tools a day before the version 4 versions were released [image] .
Version 4 works as expected, the tables are now considered to be identical.
thanks
Mark / comments
Hi Andras,
My appologies. I was just getting the version number of the SQLCompare utility when I noticed that it was version 3.x. I must have downloaded the tools a day before the version 4 version...
Hi Andras,
According to the blog entry you mentioned in your last post on this topic, the comparing of the default values has been taken care of, however, I'm still getting differences being displayed in SQL Compare.
eg
Server1 (SQL Server Express 2005 (9.0.1399))
[ContractFactor] [float] NULL DEFAULT ((0.0))
Server 2 (SQL Server 8.0.194)
[ContractFactor] [float] NULL DEFAULT (0.0)
Is this just a problem that can't be solved, or is there a setting somewhere that does this (I can't seem to see one)??
thanks
Mark / comments
Hi Andras,
According to the blog entry you mentioned in your last post on this topic, the comparing of the default values has been taken care of, however, I'm still getting differences being displa...