How can we help you today? How can we help you today?

Brackets causing problems

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.
Aaron S
0

Comments

3 comments

Sort by
  • 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.
    Brian Donahue
    0
  • Aaron S
    Maybe there could be an option added to ignore brackets in object names during comparisons?
    Aaron S
    0
  • Neil Davidson
    Aaron,

    In SQL Compare 4 this should be fixed.

    - Neil
    Neil Davidson
    0

Add comment

Please sign in to leave a comment.