export the data model from MS SQL/Oracle to Toad data modeler

What do you mean with MSSQL or Oracel data model?

You can use Toad's reverse engineering option to import the physical model.

"What do you mean with MSSQL or Oracel data model?"

I want to export MS SQL and Oracle's ER diagram/UML to Toad data modeler and see the relation between tables.

"You can use Toad's reverse engineering option to import the physical model. "

but how? from Toad data modeler, I just see the open tab read only XML files.

Toad data modeler can read all data modeler export format, right?

The diagrams in SSMS are only a simple representation of the physical model. There is imho no export option.

* Toad Data Modeler - Reverse-Engineering a Database
* How to reverse engineer database structures

"The diagrams in SSMS are only a simple representation of the physical model. "

yeah, but just want to have a visual representation of it and find out more on the design.

So toad data modeler is doing better than SSMS you mean?

When doing the reverse engineer, it will backup one and it never will the DB structure I believe  ?

No, or better I don't know. The last time I used Toad is some years ago. And I never used it's graphical widgets.

When doing the reverse engineer, it will backup one and it never will the DB structure I believe  ?

D'oh? Can you rephrase that?

"No, or better I don't know. The last time I used Toad is some years ago. And I never used it's graphical widgets."

which tools you use to see the ER/UML diagram in visual format instead of text format ?

I need a tools to see the ER/UML diagram from Oracle/MS SQL/DB2/MySQL, but mainly Oracle and MS SQL.

"D'oh? Can you rephrase that? "

I mean during the time the ER information export from database and I view them visually, there will not be any change to the DB schema structure and the operation should be quite safe, right?

I'm using Microsoft Visio or Redgate's Dependency Tracker. But I'm doing mainly SQL Server work.

I've also to admit, that I don't believe in grapical database modelling. Cause the model depends on the requirements. So a good documentation of the requirements is much more worth than an picture. And without this, a graphical model is imho worthless.

And for your question: Yes. I hope so :)

http://blogs.msdn.com/b/saurabh_singh/archive/2010/05/11/export-sql-table-records-to-xml-form.aspx

Like that?

Frank,

yes, but the point from this article is, it is only a single table and not ALL table and not the relationship  of all table.

ste5an,

"I'm using Microsoft Visio or Redgate's Dependency Tracker. But I'm doing mainly SQL Server work. "

but this mean we need to pay for it, this is the problem.  yeah, I believe redgate's tools is awesome. But if I can use free tools like Toad data modeler then I prefer that.

"I've also to admit, that I don't believe in grapical database modelling. Cause the model depends on the requirements. So a good documentation of the requirements is much more worth than an picture. And without this, a graphical model is imho worthless."

yeah, but usually developer do not show this out and they just don't share until the final minutes and ask you why the SQL server/Oracle that slow ! so why don't we just script that out and present it visually ?

Ste5an,

can redgate's tools pinpoint you some potential ER problem so that we can focus on it and work with developer to normalize it or denormalize it?

Frank,

tks for that but Visio need to pay, this is good to know that.

I don't know any ER which can do this.

yes, tks ! it should not be possible, but any good reference site which say sth like this shouldn't be done/design/implement from data modeller point of view ?

"But to point out such problems, the software must know the requirements. "

yeah, good point ! tks