[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL sever 2000 schema generator

Posted on 2004-10-30
7
Medium Priority
?
961 Views
Last Modified: 2008-01-09
Does anyone know a free tool or not so expensive tool that will generate schema in SQL server 2000? Would this tool have the capability of reverse engineering? I already have the sql sever 2000 databases but no schema have been created so far? Any suggestions would be greatly appreciated?
0
Comment
Question by:sgrahman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 6

Accepted Solution

by:
robertjbarker earned 375 total points
ID: 12455131
If you have Enterprise Manager you can use that. If you expand the database under EM there will be a member of the tree called "Diagrams". Click on that. Then, in the right window, right click. In the popup menu that comes up, choose "New Diagram...". That will start a wizard you can use to create a schema diagram.

Other tools you can use include Visio, if you have lots of Microsoft stuff just hanging about.
0
 

Author Comment

by:sgrahman
ID: 12455215
Have you used Visio to create schema? Does Visio support any other RDBMS to generate schema? Do you know any other off the self product that suport file maker pro, sql server and oracle dbs?
I know System Architect by Popkin support many different dbs to generate schema but it has only enterprise edition and it is quite expensive for an educational institute like ours. Any suggestions?

0
 
LVL 6

Expert Comment

by:robertjbarker
ID: 12455282
Yes, I have used it with SQL Server.

It has a list of supported databases, among them Oracle, DB2, Informix, Access, and a generic OLEDB (don't know about that one).

I have used, just a little - not enough to recommend, ERWin from CA.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 6

Expert Comment

by:robertjbarker
ID: 12455332
I know this question has been asked before in EE. You might try a search.

I know the high end schema diagramers/generators have reverse engineering capability. Both Visio and ERWin do.

Oracle has thier development tools (last I used them it was called Oracle Developer) - that's expensive I think.

Is this learning or work. For learning, if you are using SQL Server I would just go with EM and Query Analyzer.
0
 

Author Comment

by:sgrahman
ID: 12455403
This is for work. I was checking out Erwin data modeler but I'm not sure if it supports MS sql databases. There is one other product ER/Studio from "embercadero.com" I just came across by doing a search from this site.  It does support quite a different RDBMS.
But the pricing is not listed.
0
 
LVL 6

Expert Comment

by:robertjbarker
ID: 12455491
ERWin has been a choice of a number projects I've heard of, but not worked on. Visio has the capability to import ERWin schemas - I don't know how full that functionality is. The point being that at least Microsoft considers it a contender.

I'm pretty sure it handles SQL Server. Actually, I think I've tried it. CA does have a trial program.
0
 
LVL 6

Expert Comment

by:robertjbarker
ID: 12455496
"But the pricing is not listed"

Sounds expensive.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question