Friday, March 30, 2012

Managed replacement for SQLDMO?

In VS 2003 I used SQLDMO (Com Object) to list all available SQL Servers. Is in SQL Server 2005 a managed .net Component that can do that task?

Thanks,
Rainer.

In SQL Server 2005 SMO(Sql management object) replaces DMO(data management object). I don't use DMO because DMO uses the system tables in the Master database which is Microsoft property. Microsoft make changes with service packs that can affect DMO based code. Try the link below for Microsoft provided tutorial on SMO. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukondev.asp

|||Thanks. Smo was the magic word ;). I found here a good article that solves my problem:http://www.yukonxml.com/articles/smo/

Rainer.

No comments:

Post a Comment