Summary


Replication is a powerful feature of SQL Server that can be used in many business situations. Companies can use replication for anything from roll-up reporting to relieving the main server from ad hoc queries and reporting. It is critical to let your company's requirements drive the exact type of replication technique to use. Determining the replication option and configuration to use is difficult, whereas actually setting it up is pretty easy. Microsoft has come a long way in this regard. Unfortunately, a few minor bugs are still present in this version; however, you should not be afraid to use this facility. It is more than production-worthy, and the flexibility it offers and the overall performance is just short of incredible, incredible, incredible (replication humor for you).

In the next chapter, you will be taken into the realm of SQL Mail and see how to integrate this capability into your applications.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net