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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access