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.
| Author |
Topic |
|
mazta
Starting Member
6 Posts |
 Posted - 2008-03-19 : 05:20:50
|
| Hiya,I'm currently in a migration project from one tool to another, and now I need to to document all the table settings in the existing database. I was about to use Enterprise Manager and just document it all by hand, but then I thought that there might be more time efficient way to export it. Tried goggling it at first but couldn't find anything, so here I am.The primary thing I want is all of the table properties of the 10-15 tables (field names, type, length, PK/FK). The bonus thing would be if I somehow could get their relationship settings as well.Is there any way to do this with a query or an application feature? The outcome would preferably be in plain text mode and not at backup and SQL-backup file of some sort, since it's the documentation that's the essential part.I've got Enterprise Manager and Query Analyzer installed at the moment.Cheers, and thanks in advance!/maz |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-19 : 07:35:33
|
| Draw database Diagram. You will get full ERD diagram of your all tables and relationships. |
 |
|
|
mazta
Starting Member
6 Posts |
Posted - 2008-03-19 : 08:09:14
|
| Draw by hand or use a predefined function in one of the two applications above? I guess it might work to extract the data to an Access-backup file and then import it into Visio..? But then again, I don't want the data in database, just the table properties... so what would such a query contain? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-19 : 08:18:05
|
| Didn't you get a option to add table in SQL Diagram? Add all tables and it will create ERD for you. IF you can export all table structure, Visio will also create ERD for you. |
|
|
|
mazta
Starting Member
6 Posts |
Posted - 2008-03-19 : 09:21:12
|
| What SQL Diagram-option are we talking about..? I can't find any SQL Diagram option in Query Analyzer nor Enterprise Manager. The Database source is not on the same server (nor can I access it through any other way than a RDP-session) so I can't use Visio directly towards it. Thanks for all your help so far! |
|
|
|
|
|
|
|
|
Extracting Metadata and/or table properties