Solved

SQL sever 2000 schema generator

Posted on 2004-10-30
917 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
Question by:sgrahman
    7 Comments
     
    LVL 6

    Accepted Solution

    by:
    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
    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
    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
     
    LVL 6

    Expert Comment

    by:robertjbarker
    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
    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
    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
    "But the pricing is not listed"

    Sounds expensive.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    SQL Server Side Trace is a technique of Profiling SQL Server Events Silently (i.e without Using the Profiling Tool). Running a visual tool in production increases overhead, but we can develop server side Trace using Sql Server Profiler itself. We…
    Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    884 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now