Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 967
  • Last Modified:

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?
0
sgrahman
Asked:
sgrahman
  • 5
  • 2
1 Solution
 
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
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now