Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MNewMan
Starting Member
2 Posts |
 Posted - 2008-08-18 : 09:56:33
|
| I am trying to understand the database which has following objects?ObjectName CountCheck Constraints 0Foreign Keys 0Primary Keys 126Tables 309Views 318Procedures 1082Triggers 12Unique Keys 0My understanding is that, the designer has never used business sense in designing relations. Though views exist in the database, merely used by developers. As there are no foreign keys, i am not sure about relating tables and integrity of data?Any suggestions in improving it without breaking applications? Or is it ok to have databases with no relationships in between tables?Thank you for suggestions and comments. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-18 : 11:24:17
|
| well if you don't have the source code for the app there's not much you can do.what i'd do is make a test copy of the database, implement the improvements and change the connection string of the app to the test db. then test it and if everythign works ok you're good to go_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
MNewMan
Starting Member
2 Posts |
Posted - 2008-08-18 : 13:46:29
|
| Thanks Spirit1Thats what i am doing right now, it is really time consuming as i dont have much documentation about tables and their contents...I took an empty schema, and started adding relations as per the understanding, and at the same time cleaning tables and views that dont need to be in there. And i am trying to modify stored procedures too while documenting the tables and associations. This is only one small database we have, the major database has some 3000 tables with no relations. I am wondering about third party tools. Any suggestions?Thanks a lot for responding. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-18 : 13:53:06
|
| third party tools for what exactly?red gate, idera, quest, apex and probably others i've forgotten to mention have loads of tools for stuff like this.look at some of those._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-18 : 18:51:44
|
I wrote a doc tool that may help you. see the link in my sig. 
elsasoft.org |
|
|
|
|
|
|
What is wrong with this picture?