sqldmo advise

[Dan]

Hi guys, I'd like to have from you some advise about using SQL-DMO with
C-sharp. I have found some nice introductory articles in the web (e.g.
http://www.csharphelp.com/archives2/archive342.html) but I'd like much more
information on *effectively* using SQLDMO (with C-Sharp) to:

- programmatically extract a database definition with all its tables,
relations, stored procs and re-create it onto another machine;
- programmatically modify a stored procedure;
- programmatically create full database backups;

....and so forth. Could you suggest any good book to learn doing all sort of
such things with C-sharp using SQL-DMO?

Thanx to all!

 

[Mark Allison]

Dan,

I wrote a book on the SQL-DMO API with Allan Mitchell, it doesn't cover
..NET though (I'm just learning that now).

Real-World SQL-DMO for SQL Server
http://www.apress.com/book/bookDisplay.html?bID=118

Jasper Smith has written some nice articles on SMO, the SQL2005 version
of SQL-DMO here:
www.sqldbatips.com

Using DMO with .NET is much the same as using it pre .NET, you just have
to be aware of the limitations of using COM. Also see http://sqldev.net
for more articles on using SQL-DMO with C#.

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html