Brackets causing problems

Aaron S · February 17, 2006 3:22PM

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 · February 18, 2006 1:59PM

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 · February 20, 2006 8:12AM

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

Neil Davidson · February 20, 2006 8:37AM

Aaron,

In SQL Compare 4 this should be fixed.

- Neil

Brackets causing problems

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk