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-10-29 : 13:27:53
|
| Hi,I am trying to archive our production database, but i have to do this by denormalizing the dataCan anyone please tell me as to what are the initial steps i have to take in order to create a planning document and how check for the relationships and use them to denormalizeNote: I am confused as to one-to-one relationship tables can be joined as one tableand one-to-many can be done the same wayand many-to-many can be done the same way.Thanks,vamsi |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-29 : 13:41:46
|
quote:
but i have to do this by denormalizing the data
Why do you "have to" denormalize the data? Denormalizing and archiving are completely separate things, and neither of them depend on the other. |
 |
|
|
vamsidhar.tangutoori
Starting Member
19 Posts |
Posted - 2012-10-29 : 13:53:23
|
That is the requirement given to me, first i need to basically map out a plan to denormalize the data that is more than ten years old and then i can plan a way to archive itquote:
Originally posted by robvolk
quote:
but i have to do this by denormalizing the data
Why do you "have to" denormalize the data? Denormalizing and archiving are completely separate things, and neither of them depend on the other.
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-29 : 16:44:18
|
quote:
Originally posted by vamsidhar.tangutoori
That is the requirement given to me, first i need to basically map out a plan to denormalize the data that is more than ten years old and then i can plan a way to archive itquote:
Originally posted by robvolk
quote:
but i have to do this by denormalizing the data
Why do you "have to" denormalize the data? Denormalizing and archiving are completely separate things, and neither of them depend on the other.
Serious that requirment doesnt make any senseIf data is to be archived then why should it be converted to denormalised format?I'm certain you're missing some link in between which really calls for data to be converted to denormalised format------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to Denormalize and Archive Data