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 |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2009-01-13 : 12:37:05
|
| Hi all,i have one question for replication model.i have two server...server-1 use for production and another is use for data warehousing(reporting purpose)we have 6 month archive policy on production server-1.so keep only six month data.but i need all history data on server-2 for reporting purpose.so how can i scyn both servers?? one with only six month data and another with all hisotry data as well as current data.so can anyone tell me which replication model is perfect for my sceanario.Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-13 : 12:41:23
|
See http://msdn.microsoft.com/en-us/library/ms152531(SQL.90).aspx
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 17:41:02
|
quote:
Originally posted by saurabh811
Hi all,i have one question for replication model.i have two server...server-1 use for production and another is use for data warehousing(reporting purpose)we have 6 month archive policy on production server-1.so keep only six month data.but i need all history data on server-2 for reporting purpose.so how can i scyn both servers?? one with only six month data and another with all hisotry data as well as current data.so can anyone tell me which replication model is perfect for my sceanario.Thanks in advance
Transactional Replication. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-13 : 17:52:30
|
Maybe a related question; Is it possible to filter out DELETE in transactional replication so that only UPDATE and INSERT are transferred?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 19:05:32
|
| Peso,Yes you can .It calls internal replication system SP (sp_Msdel_[schematablename]) whenever there is a delete happening in publisher so it is replicated to subscribers. You can prevent it from happening with1)Right click Publisher Properties and choose Articles2)Open properties of table and Choose Donot replicate Delete statements |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-14 : 01:51:11
|
Thanks!
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
replication model