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 6:59 am
You probably meant Visio, not Visual Studio?
ERWIN, ER/STUDIO, TOAD all have a trial version. It is more about your personal preference (and budget).
BTW, I am managing a DB with over 400 tables DB using database diagrams...
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 24, 2008 at 6:50 am
Sorry, I think that you are mixing data architect tools (ERWIN etc.) with change management tools.
You might want to take a look on ApexSQL Diff (www.apexsql.com) and similar tool from RedGate (www.redgate.com).
I believe Quest has the same type of tool which is designed to synchronize database schemas (as well as table data) between multiple environments.
All three has their products available in evaluation copies.
Also Apex has ApexDOC (RedGate has similar tool) for generating data dictionaries...
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 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply