SQL sever 2000 schema generator

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?
sgrahmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

robertjbarkerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sgrahmanAuthor Commented:
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
robertjbarkerCommented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

robertjbarkerCommented:
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
sgrahmanAuthor Commented:
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
robertjbarkerCommented:
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
robertjbarkerCommented:
"But the pricing is not listed"

Sounds expensive.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.