Those Stubborn Database Rules - Finding Them and Scripting Them

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Scott Abrants » Those Stubborn Database Rules - Finding Them...

12 posts, Page 2 of 2

««1 2

Those Stubborn Database Rules - Finding Them and Scripting Them

Rate Topic

Display Mode

Topic Options

Author

Message

Ligtorn

Posted Friday, January 08, 2010 10:28 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 20, 2013 5:40 AM
Points: 233, Visits: 434

I believe that I can save you the headache. I have just published two scripts, one which can convert bound default objects to column defaults and one that converts bound rules to column check constraint.

Convert rule objects to column check constraints

Convert default objects to column defaults

Actually it is pretty complicated to convert rules, because sql server stores them as transact statements. The only way I know of, are converting them by doing text parsing. Parsing these objects are pretty hard to generalize. I would appreciate feedback if you run into problems with the scripts

Post #844510

Scott Abrants

Posted Friday, January 08, 2010 12:48 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

Wow thank you for that. Now promising to post a follow up might not really be needed.

Post #844624

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions