How to use SQL SMO in c++???

• ravikiranforever

  SSC Veteran

  Points: 252

  More actions

  April 9, 2009 at 4:09 am

  #199110

  Hi

  i am usnig VS2003 with windows platform sdk2008. i want to migrate my code in DMO to SMO .how can i do in c++.

  Does vs2003 with pltrform sdk2008 supports SMO or Not ?? If supports how can i do this??????

  Plzzzzz help me in this regard...

  Thanks in advance....

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  April 9, 2009 at 7:11 am

  #975008

  You cannot use VS2003 with anything SMO because the SMO library was released with SQL Server 2005 which uses VS2005 so you need at least VS2005 to use SMO. I also don't think you should write SMO code with VC++ because there is more support in VB and C# both langauges are native to SQL Server 2005/8. So buy SQL Server 2005 the developer edition and use either VS2005 standard or Express the later is free.

  Kind regards,
  Gift Peddie