THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Allen White

SQL 2008 SMO - Doing a Little Rearranging

In browsing through the SQL Server 2008 SMO Object Library I noticed there are a couple of additional DLL's. For example, the SQL Server WMI Management objects, formerly in Microsoft.SqlServer.Smo.dll, are now in Microsoft.SqlServer.SqlWmiManagement.dll. There's also a new one called Microsoft.SqlServer.SmoExtended.dll. I took a look in there and found this list of objects, which have been removed from Microsoft.SqlServer.Smo.dll:

SmoExtended Objects

  • AsyncStatus
  • Backup
  • BackupActionType
  • BackupDevice
  • BackupDeviceCollection
  • BackupDeviceItem
  • BackupDeviceList
  • BackupRestoreBase
  • BackupRestoreBase.AsyncOperation
  • BackupTruncateLogType
  • DeviceType
  • PercentCompleteEventArgs
  • PercentCompleteEventHandler
  • RelocateFile
  • Restore
  • RestoreActionType
  • SqlVerifyAction
  • Transfer
  • VerifyCompleteEventArgs
  • VerifyCompleteEventHandler

    This means that if you are doing backup or data transfer operations through SMO you'll have to be sure to add references in your projects to the SmoExtended dll in SQL Server 2008.

    I expect there will be more changes as updated CTP's are released.

    Allen


  • Published Friday, October 19, 2007 3:36 PM by AllenMWhite
    Filed under: ,

    Comment Notification

    If you would like to receive an email when updates are made to this post, please register here

    Subscribe to this post's comments using RSS

    Comments

     

    Allen White said:

    While preparing for a presentation at PASS next month I tested my PowerShell script to back up user databases

    October 18, 2008 12:36 PM
     

    Allen White said:

    Errors occur. (I'm sure that's someone's corollary to Stuff Happens.) Errors occur, and that's why we

    November 24, 2008 11:38 AM

    Leave a Comment

    (required) 
    (optional)
    (required) 
    Submit

    About AllenMWhite

    Allen White is a SQL Server Trainer for Scalability Experts, a leading provider of scalable solutions, training and services based on Microsoft SQL Server. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.
    Powered by Community Server (Commercial Edition), by Telligent Systems
      Privacy Statement