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 |
|
vamsidhar.tangutoori
Starting Member
19 Posts |
 Posted - 2012-11-01 : 15:02:50
|
| Hi,I am trying to create a denormalized copy/archive database for the present database. I need help with how do i check the hierarchies in the database and what is the best practice and the steps i need to take in order to plan for the process.Thanks. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-01 : 15:21:29
|
| Denormalizing and archiving don't necessarily have to be associated with one another. Is there any reason you are associating these two together?If you want to denormalize, you would need to examine the schema of the database and decide what kind of denormalization you want to do. For example, if you have a few tables - Students, Teachers, Courses and tables that relate those, how do you want it to be denormalized? Unless there is a specific goal you are trying to achieve, there is no reason to and no point in denormalizing.For archiving, people take backups and delete old data from the production database. Alternatively, you might have an archive database (on a different server) to which you would move the old records from the production table. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-11-01 : 15:26:56
|
| Dupe of: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=180178 |
|
|
|
|
|
|
what are the steps to denormalize a database