Chapter 12. SQL Server Management Objects (SMO) Utility Classes

SMO utility classes perform specific tasks and are work independently of the SQL Server instance. SMO utility classes can be grouped according to their function:

• Database scripting operations

• Backup and restore databases

• Transfer schema and data between database instances

• Trace and trace replay operations

• Administering the Database Mail subsystem

The sections in this chapter describe these SMO utility classes and shows how to use them through programming examples.

There are three more SMO utility classes that are discussed in later chapters:

• SMO classes used to administer SQL Server Agent are covered in Chapter 16.

• SMO classes used to administer Service Broker are covered in Chapter 17.

• SMO classes used to administer Notification Services are covered in Chapter 18.

The examples in this section are all built using Visual Studio 2005. The examples need a reference to the following assemblies:

• Microsoft.SqlServer.ConnectionInfo

• Microsoft.SqlServer.Smo

Additional assembly references will be given for examples in which the assemblies are required.