[RESOLVED] SQL Server 2005: replacement for SQLDMO

[dee-u]

SQLDMO only works for SQL Server 2000 (at least that what I believe), I need to replace it so that it will work on SQL Server 2005 and probably for SQL Server 2008 also in the future.

TIA

[jmcilhinney]

SQLDMO does work for later versions but it's preferable to use SMO. It's .NET-based instead of COM-based.

http://msdn.microsoft.com/en-us/library/ms162169.aspx

[techgnome]

And it's more powerful too..

-tg

[dee-u]

SQLDMO does work for later versions but it's preferable to use SMO. It's .NET-based instead of COM-based.

http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hmmnnn... Care to cite a sample that would make SQLDMO connect with SQL Server 2005 database?

[dee-u]

Hmmnnn... Care to cite a sample that would make SQLDMO connect with SQL Server 2005 database?

oSQL.LoginSecure = true;
oSQL.Connect(@"SERVER\SQLEXPRESS", null, null);

Works for me, just in case somebody else is interested.