question

rudrapbiswas avatar image
rudrapbiswas asked

Compare objects

I had generated scripts to create objects without data. I did it to create a subset db out of my source db. While doing so I had selected ANSI_PADDING off. Due to this we are getting a mismatch in new db w.r.t to the source dbs. I tried to make use of the existing tools which compares the DB objects. But all of those doen't consider ANSI settings for the table/columns. How can I compare the differences between the ANSI settings (NULL, Padding, NULL semantics for Column) between 2 dbs. Also, how can I sync them? Regards, --Rudra
sql-server-2012objects
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

VishalhSingh avatar image VishalhSingh commented ·
Why the ANSI padding has set to be OFF?
0 Likes 0 ·

1 Answer

·
David Wimbush avatar image
David Wimbush answered
Hi Vishal ANSI_PADDING is in the is_ansi_padded column in sys.columns. ANSI_NULLS is in the uses_ansi_nulls column in sys.tables.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.