Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

Extended Properties Introduction Expand / Collapse
Author
Message
Posted Thursday, March 17, 2011 12:22 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:47 AM
Points: 81, Visits: 892
Hi YSLGuru,

No idea on this one, I am afraid - sorry!

Adam
Post #1079941
Posted Thursday, March 17, 2011 12:24 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:47 AM
Points: 81, Visits: 892
Thanks for the encouragement, Sal!
Post #1079944
Posted Thursday, March 17, 2011 12:34 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 06, 2014 12:59 PM
Points: 801, Visits: 1,962
Great article Adam.

ATB

Charles Kincaid

Post #1079952
Posted Thursday, March 17, 2011 12:40 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 06, 2014 12:59 PM
Points: 801, Visits: 1,962
So here is a couple of questions.
Let's say that there is a tool that lets you:
Log into a SQL server.
Update the description extended properties on your tables and columns.
Lets you export the same to an XML file.
Lets you import the same from an XML file.

Would such a tool be worth say $5 US? What else must it do to be worth that?


ATB

Charles Kincaid

Post #1079956
Posted Thursday, March 17, 2011 12:53 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 20,462, Visits: 14,092
Nice article. Thanks.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1079964
Posted Thursday, March 17, 2011 1:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:47 AM
Points: 81, Visits: 892
Hi Charles,

Thanks for the feedback. As to a tool to manage documentation better - I would prefer to see Microsoft extend the product to include this.

Regards,

Adam
Post #1079987
Posted Thursday, March 17, 2011 1:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 06, 2013 8:07 AM
Points: 109, Visits: 489
Alexander Kuznetsov (3/17/2011)
Hi Adam,

The following sounds like a good reason: "tracks object evolution automatically".
Thanks for the answer.

AK


The only problem (re: object evolution) I've found is in SQL Server 2005 on user-defined functions, the ALTER FUNCTION statement would cause extended properties to be lost. I think this was fixed in 2008. This is not a problem with ALTER PROCEDURE.

Renaming objects or changing schemas seemed to work fine in SQL Server 2005.
Post #1079989
Posted Thursday, March 17, 2011 1:31 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:47 AM
Points: 81, Visits: 892
Charles - have you looked at http://datadictionary.codeplex.com/ - free, and very good!
Post #1079991
Posted Thursday, March 17, 2011 2:47 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 27, 2014 10:14 AM
Points: 1,322, Visits: 1,091
YSLGuru,
ANyone know of a good way to get Meta data (sometimes called a data dictionary) out of a PDF and into something more easy to insert into t-SQL code? The PDF currently uses an Excel/Spreadhseet/table like structre; at least thats they way its presented. I have no diea how PDF works internally and so its looking like its in a table may not mean it any easier to export then if it were presented in free form style.



Internally, PDF is a compressed PostScript file (with proprietary add ons), and as far as I can tell there isn't any good way to extract the data out.

However, In theory, one could print the pdf to a PostScript file (e.g. set up a postscript printer and change the destination to be a file) and then use the postscript language to extract the data out. There may be converters to turn the postscript into something more friendly but I've never had occasion to look for any. It might even be possible to skip the postscript and set up some sort of line printer to create the file and parse that out after stripping out the control characters. If you decide to try this use the oldest printer driver you can make work (The Apple Laserwriter has historically been a good choice for a postscript printer driver). Tables might not be too bad but the more formatting and objects that exist in the pdf the harder it will be to parse out the file.

After writing all of that, I thought of a potentially much easier way:
OCR.

Good Luck,
Post #1080049
Posted Thursday, March 17, 2011 4:18 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 06, 2014 12:59 PM
Points: 801, Visits: 1,962
Another trick is to set up a Generic/Text Only printer on your PC and redirect that to a file.

ATB

Charles Kincaid

Post #1080104
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse