Where the Heck is DMO?

You've installed SQL Server 2008 on a clean machine and your vb script that uses DMO doesn't work. You're asking yourself: What the heck happened? Did those goofballs over @ MS hose me? Deprecation of DMO was announced in SQL Server 2005, but SQL Server 2005 still installed DMO. In SQL Server 2008 we've taken the next step down the deprecation path - we ship DMO but don't automatically install it. There are two places to get DMO:

• SQL Server 2008 Installation Media: go to ..\x86\Setup\x86\SQLServer2005_BC.msi
• SQL Server 2008 Feature Pack @ the Microsoft Download Center: www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

Generally it's best to go to www.microsoft.com/downloads, search for "SQL Server Feature Pack" and sort by Release Date to find the latest version.

With the addition of PowerShell support in SQL Server 2008 we highly encourage you to move off of DMO and start using SMO.

Comments

• Anonymous
  August 28, 2008
  PingBack from http://hoursfunnywallpaper.cn/?p=3626

• Anonymous
  November 21, 2008
  Thanks for the useful info.   The installer for a product I'm testing against SQL2008 uses some DMO stuff to connect to the db, verify version number, create db for the product etc..  needless to say that didn't work too well until I turned on DMO

• Anonymous
  April 02, 2009
  Thank you very much, I need DMO for integration to our backup sw.

• Anonymous
  August 07, 2012
  Based on my findings the SQL Server 2012 production release does no longer support SQL-DMO. It is not part of its Feature Pack either: www.microsoft.com/.../details.aspx