Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, December 2, 2024 
 
Database Document Generator  
Description:  This utility will output the schema information for a database to an Excel workbook. You can use this for documenting database tables, printing out schema to make imports easier, etc. The output includes all details about fields on the selected tables and prints out nice. The utility allows you to select from the available ODBC DSNs for the data source. Works with version 6 and also v5 and prior. (Updated!)

Category:  Utilities
Author:  Ryan Farley
Submitted:  12/3/2002
   
Stats: 
Article has been read 11605 times

Rating: - 5.0 out of 5 by 10 users
 

fiogf49gjkf0d
Database Document Generator

This utility will output the schema information for a database to an Excel workbook. You can use this for documenting database tables, printing out schema to make imports easier, etc. The output includes all details about fields on the selected tables and prints out nice. The utility allows you to select from the available ODBC DSNs for the data source. Works with version 6 and also v5 and prior.



 Click here to download the utility

VB6 Runtimes are required.


-Ryan Farley

Updates

  • 5/27/2003 - Updated to fix crash when table contains only 1 field. Thanks to Lloy Sanders for the catch!

 

About the Author

  Ryan Farley
(SalesLogix Business Partner)
Customer FX Corporation

fiogf49gjkf0d

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View Ryan's SalesLogix Mobile Seveloper Series
View Ryan's SalesLogix SData Developer Series
View Ryan's Git for the SalesLogix Developer series



View online profile for Ryan Farley
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
RJ Samp

slxdeveloper.com Forum Top 10 Poster!

Re: Database Document Generator
Posted: 6/14/2004 12:25:59 PM
fiogf49gjkf0d
Time for ADO connection manager versus the ODBC DSN connections?

would make this utility a trifle easier to use?

THANKS!

RJ Samp
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: Database Document Generator
Posted: 6/14/2004 12:55:58 PM
fiogf49gjkf0d
RJ, I totally agree. I've always hated that I have to create a DSN to use this! It is in dire need of an update to get rid of that.

Thanks,
-Ryan
 
Michael Litman
 

Re: Database Document Generator
Posted: 10/13/2006 11:22:15 AM
fiogf49gjkf0d
Ryan,

Does this util work on 6.2? Thanks Michael
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: Database Document Generator
Posted: 10/13/2006 11:41:13 AM
fiogf49gjkf0d
Yes this does work on SLX 6.2. It actually uses an ODBC DNS for the connection so it doesn't really matter that it is SLX at all or some other database. You just create a DNS to point to the database in question and then use this.

The DNS part is a pain. I'd love it if this used an OLEDB connection instead, but I've never gotten around to changing this. Also, this is written in VB6 which I haven't had installed for years. At some point I'd like to rewrite this in C# and make source available. But, for now, this one will still work.

-Ryan
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 12/2/2024 2:46:00 PM