May 3, 2012 at 7:29 am
Dear All,
I would like to find more about the Disadvantages of Transactional Replication as it is the best process of Replication for my Business needs; I would like to know more about what it is not capable of doing, to give more of an example; the Replication will do the following:Updates, Filters, Inserts, Deletes
Thank you in advance!
May 3, 2012 at 7:48 am
tt-615680 (5/3/2012)
Dear All,I would like to find more about the Disadvantages of Transactional Replication as it is the best process of Replication for my Business needs; I would like to know more about what it is not capable of doing, to give more of an example; the Replication will do the following:Updates, Filters, Inserts, Deletes
Thank you in advance!
What have you discovered so far? There are hundreds of thousands of hits on google for "Disadvantages of Transactional Replication".
Here is one such link.
Here is another. http://sqlserverdatarecovery.com/transactional_replication.html
I would like to know more about what it is not capable of doing
Wow that list could get totally out of hand pretty quickly as it is pretty wide open. It can't make my morning coffee or walk my dog. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 3, 2012 at 8:00 am
Thank you for your reply,
I was more interested in which type of replication is best to use when the Replicated data is mainly updatable data where filtering is used e.g. filtering using two or more tables.
Thank you!
May 3, 2012 at 9:27 am
You'll have to explain more. What do you mean by updateable with filters?
I assume filters mean that you are producing a publication that joins data from two or more tables using a query.
The types of replication work differently, and it isn't necessarily about data. Snapshot replication is a complete movement of a set of data at points in time. Transactional works with shorter periods of time and sets.
Merge and peer to peer are more for data that changes at the publisher and subscriber.
May 3, 2012 at 9:38 am
Steve Jones - SSC Editor (5/3/2012)
I assume filters mean that you are producing a publication that joins data from two or more tables using a query.
The Business needs is that the data in "Real time" so Transactional Replication would be best suited and yes the Data would be mainly updating specific columns on various table which need to be joined for example creating a View which will have the tables which are needed and also filter the data as well e.g. only selecting then data from a particular year to date. I read that there are some downsides in Transactional Replication especially when it comes to performing Updates.
Thank you!
May 3, 2012 at 9:44 am
What updates? Are you talking about updating at the source or destination? It's not clear from what you are posting.
May 3, 2012 at 9:58 am
Steve Jones - SSC Editor (5/3/2012)
What updates? Are you talking about updating at the source or destination? It's not clear from what you are posting.
The Updates will Occur on both the Distributor Database and as I said the Updates will only happen only on Specific Columns and also in order to do that multiple tables will have to be Joined.
Thank you!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply