SQL Server Performance

Viso 2000

Discussion in 'Third Party Tools' started by cejar, Dec 16, 2003.

  1. cejar New Member

    Has any one created a database using Viso. How well do all the features work when it comes time to generate the database from the Model? Are there any draw backs? Is it recomended to use the Index creation features or should I just script them manually?
    Any thoughts would be appreciated.

    Cheers!
    cejar, Dec 16, 2003
    #2

  2. satya Moderator

    I tried, but only able to workout by exporting to access database and then use upsize wizard to move over SQL server.

    HTH


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Dec 16, 2003
    #2

  3. cejar New Member

    Satya, what version must you have to export directly to SQL Server?

    Cheers!
    cejar, Dec 17, 2003
    #2

  4. satya Moderator

    I mean to say its not possible to import directly to SQL server, as I tried so the workaround is defined above. I'd tried on SQL 2K with VISIO 2K2.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Dec 17, 2003
    #2

  5. ufobox New Member

    VISIO's strength is not in DB Model.

    It can't compete with other tools, such as ERWin.
    ufobox, Dec 19, 2003
    #2

  6. satya Moderator

    Agree, ERWIN is the first and best tool to get more out of it.
    TO get the compatibility and ease of diagram the database VISIO is best at it.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Dec 21, 2003
    #2

  7. cejar New Member

    I also agree on that. I followed on this in the MS website and the only recent tool by MS that lets you Forward Engineer to SQL Server is Visio Studio .Net Architect Designer. I thought Viso 2000 had this capability since I once read it in a book SQL Server Design and T-SQL Programming by Michelle Poolet.



    Cheers!
    cejar, Dec 24, 2003
    #2

Share This Page