September 23, 2008 at 5:12 am
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;-)
September 23, 2008 at 6:40 am
You can use ERWIN.
September 23, 2008 at 6:42 am
... or ER/Studio
September 23, 2008 at 6:45 am
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;-)
September 23, 2008 at 7:06 am
You can use Microsoft Visio Professional to re-engineer your database schema into a Visio digram automaticaly, It is very easy to use.
September 23, 2008 at 10:05 pm
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;-)
September 24, 2008 at 4:24 am
Efficent solutions comes with efficent resources. In VLDB environment don't think about Visual Studio , think abt ERWIN more or less abt Microsoft Visio.
September 25, 2008 at 5:00 am
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:
September 25, 2008 at 11:52 am
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
September 26, 2008 at 1:20 am
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