Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Data Model Generation
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pandalion
Starting Member

6 Posts

Posted - 10/10/2014 :  17:07:22  Show Profile  Reply with Quote
I'm fairly new to SQL Server but in my new job we use 2005 exclusively. Is there any way to export a data model from an existing database? Currently we don't have a data model and I was hoping there was some way to either generate one from the base or at least get me partly there (e.g. exporting table defs to Excel, etc).

Anything like that built-in or any free tools available? We might consider paying for something but it'll be a last resort.

Thanks!

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1834 Posts

Posted - 10/10/2014 :  18:41:01  Show Profile  Reply with Quote
Are you trying to generate a data dictionary: http://www.codeproject.com/Tips/501909/Generate-Data-Dictionary-from-SQL-Server



No amount of belief makes something a fact. -James Randi
Go to Top of Page

pandalion
Starting Member

6 Posts

Posted - 10/13/2014 :  09:43:05  Show Profile  Reply with Quote
quote:
Originally posted by Bustaz Kool

Are you trying to generate a data dictionary: http://www.codeproject.com/Tips/501909/Generate-Data-Dictionary-from-SQL-Server



No amount of belief makes something a fact. -James Randi



A data model diagram ultimately but a data dictionary is part of what I want as well. Thank you for this it will be VERY useful!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000