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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-06-03 : 04:23:50
|
| Hi What are the problems generally occurs in Transactional Replication?and How to resolve the problems? kindly update your experiences about it.--Ragu |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-03 : 05:01:04
|
| Failing and/due to lack of expertise are the main issues.Not having a test system so that features can be tested before implementation or trailed when problems are found.Not looking at the way the system is used to see if it is a good solution - it might be for some tables/processes and not for others.Not reviewing dependencies of data before designing.Not looking into the architecture and hardware.It's not that difficult but a lot of companies just try to dump it on top of an existing system without checking the affect it will have or testing how to make changes. Not so bad if you can afford the time to re-initialise from scratch but at some point that won't help.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Issues in Transactional Replication