Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Designer Tool including Convertion to SQL !?

    Hi guys,
    I was searching for a software with wich you can design databases,
    and I wanted a tool that directly puts this database with fkeys etc, in a sql code to create a database or just in an XML document or something like this so that it would be easy to make changes in the Grafic-model parallel to the actual Model.

    I'm not sure if something like this exists but it would be great, does anyone knows something about the existence of such a tool,
    if possible it should be a tool with demo available.

    And I'd like to have an design with 2 sides relationship naming
    an relationship should look like this (just sketch)

    participates in
    Student ---------------------------------------- Course
    enrolled by
    I appreciate all answers
    Last edited by Kworth; 01-14-04 at 00:05.

  2. #2
    Join Date
    Jan 2004
    Posts
    18
    hey

    ive been using DBDesigner4 http://www.fabforce.net/

    im new to all this really, so perhaps theres better out there, should do everything youve requested though.

  3. #3
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50
    In SQL Server 2000, create your schema in Enterprise Manager, then script all your objects, Primary & Foreign keys, Indexes, etc. (Tools / Generate SQL Script)

  4. #4
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Check out

    http://www.datamodel.org/

    it might point you to a product. There are many more.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •