Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL sever 2000 schema generator

Posted on 2004-10-30
7
Medium Priority
?
965 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
  • 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

578 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