Activity overview
Latest activity by StevenD
Yes, both databases are running on SQLServer 2005 (on separate machines)
After experimenting some more, I found out that whether the problem occurs or not, depends on how the tables (or in my case it were views) are made. If you make a table from within SQL server Management Studio, the square brackets are *not* added. So if I make a view called TEST, Sql Compare will treat it as:
CREATE VIEW TEST
AS
...
If you generate a create script from within SqlServer Mgmt Studio, it will add the brackets (and the schema):
CREATE VIEW [dbo].[TEST]
AS
...
If then use this script to update the 2nd database and compare the two databases, Sql Compare will report them as different. So it seems as if Sql Compare uses the exact string that is used to create the database...
Hope this helps,
Steven / comments
Yes, both databases are running on SQLServer 2005 (on separate machines)
After experimenting some more, I found out that whether the problem occurs or not, depends on how the tables (or in my case ...
Brackets in name causes difference
Hi,
I'm currently testing SqlCompare v4. I've noticed Sql Compare lists some tables as different although the only difference is that their names are enclosed in brackets on one db and not on the o...