DSO equivalant in SQL25k ?

• FP-401493

  Right there with Babe

  Points: 723

  More actions

  July 16, 2007 at 5:20 am

  #179695

  Dear Gurus,

  I am not sure that is Decision Support Objects or simply DSO will be supported in later versions of MSSQL. I have checked the BOL and it displays a depreciated warning over all of DSO pages

  Anyway, I am to build a new system and since DSO is being depreciated what should i use to ensure compatibility with future versions (which seems to be just around corner ) - OR -what is the SQL2k5 replacement of SQL2k's DSO ?

  Thanks for reading.

  FP

  ---

  FP

  True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 16, 2007 at 5:35 am

  #719637

  What about Analysis services?

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  July 16, 2007 at 5:52 am

  #719642

  You're looking for AMO (Analysis Management Objects).  Here's a few links around AMO and porting DSO to AMO.

  http://technet.microsoft.com/en-us/library/ms345089.aspx

  http://technet.microsoft.com/en-us/library/ms403376.aspx

  As noted in the first link, AMO is not used for querying data, to do this, use ADOMD.net

  HTH,

   

  Steve.