Brackets causing problems

Aaron S

Using SQL Server Management Studio (SSMS) 2005 I extracted the DDL for all objects, users, roles, etc. in one of my SQL Server 2000 production databases. To verify this extraction, I then created a blank database on another SQL 2000 server and ran the SQL script. I then compared the two databases using SQL Compare. Apparently SSMS places brackets around object owner names and table names, and SQL Compare does not because it showed a lot of differences between objects just because of the brackets. When I extracted the DDL using SQL Server Enterprise Manager 2000 and ran the same comparison, things worked as I expected.

Brian Donahue

Hello Aaron,

SQL Compare uses the exact DDL from the the time that the object was created, while SQL Server does tricks to work out the owner, etc so that the object name is always formatted the same rather than exactly what's stored in the system tables. This would account for the difference.

Aaron S

Maybe there could be an option added to ignore brackets in object names during comparisons?

Neil Davidson

Aaron,

In SQL Compare 4 this should be fixed.

- Neil