O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

We’ve only scratched the surface of SMO and PBM in this chapter because both SMO and PBM have tremendous capability and offer exceptionally rich programming features. Without a doubt, SMO is an exciting object model that covers everything SQL Server does—and in fact, even more than SQL Server Management Studio covers. As a developer, you might find yourself performing the same task over and over in Management Studio. If that’s the case, consider writing an application using SMO. Also keep in mind that SMO is more feature-complete and performs better than the legacy SQL-DMO, and therefore, it can fulfill many of your administrative needs. PBM makes it easy to ensure that your development environment and the target test and production environments ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required