SQL-DMO Collections, what's the alternative?

• grahowler

  SSC Veteran

  Points: 244

  More actions

  March 23, 2008 at 2:43 am

  #188375

  Hi

  I've been in the back woods for a number of years and I'm only just coming back to SQL Server. I've starting using MyGeneration, which I love. I started to look at writing my own templates for it and when I looked at the existing code in it, then compared that with the books online I started to find some surprises. I.e...

  1. The databases collection is going: http://msdn2.microsoft.com/en-us/library/ms132129.aspx

  2. The Columns collection is going: http://msdn2.microsoft.com/en-us/library/ms135184.aspx

  Just to name a few.

  Also, I can't find documentation for the existing properties of the Columns collection, e.g. the property "DataTypeName". So this will work "Databases.Item(MyDatabaseName).Tables.Item(MyTableName).Columns.Item(0).DataTypeName", but I can't find it documented.

  So two questions...

  1. Where's the documentation for the properties I can use, but can't find in books online?

  2. What should I use to move forward considering the collections are going to become obsolete?

  Thanks!

  PS. Great site.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  April 7, 2008 at 8:50 am

  #799211

  SQL-DMO is deprecated as of SQL Server 2005. The new library is SQL Server Management Objects (SMO) - look it up in Books Online (e.g.: http://msdn2.microsoft.com/en-us/library/ms162169.aspx).

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com