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

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Data Model Generation

Author  Topic 

pandalion
Starting Member

6 Posts

Posted - 2014-10-10 : 17:07:22
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
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-10-10 : 18:41:01
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 - 2014-10-13 : 09:43:05
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
   

- Advertisement -