What are the challenges you face when working across database platforms? Take the survey
Options

Brackets causing problems

Aaron SAaron S Posts: 11
edited February 20, 2006 8:37AM in SQL Compare Previous Versions
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.

Comments

Sign In or Register to comment.