Alternative ofdatabase diagram

  • hi ,

    actually i have db diagram which contains around 700 tables and on every quarter 20-30 tables

    are added .so it is very difficult to manage it ,because it is placed at Visual studio ?

    can any body help me ??

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • You can use ERWIN.

  • ... or ER/Studio

  • hi ER/studio OR erwin ?? please elaborate

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • You can use Microsoft Visio Professional to re-engineer your database schema into a Visio digram automaticaly, It is very easy to use.

  • Yeah......i know re-engineering feature but its really difficult to manage 700 tables.....the reason being we basically deals with DDL commands ....so on every time it takes a lot of DBA time to sync DB diagrams...can u provide your thoughts to ease it 🙂

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Efficent solutions comes with efficent resources. In VLDB environment don't think about Visual Studio , think abt ERWIN more or less abt Microsoft Visio.

  • Strange database - adds 20 - 30 tables quaterly.....hmmm....what type of database is it?

    Sounds like a totally flawed design.......:D

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • I started the database with 200 tables and usually it happens when your system is in production more and more tables have to be created every month, i execute campaigns and it require few tables to be created and generate scanlines. I have around 1000 tables in the database becuase i have been doing development too.

    In order to manage relationship in diagrams i prefer to create seperate diagram for each module and till now it is working for me

    if you have time then go for it

  • Er.....add tables to a database every month - very strange.....

    Usually a database is complete and whole and no more tables are added ever, unless there is a functional requirements change e.g. the application it supports has new functionality added to it.

    Are you adding tables to hold periodic data i.e. a set of data for each month? Thats just crazy!

    Your usage of the database engine is extremely strange.

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply