i want a good preview about sql dmo
what is it and how to use with vb.net applications ?
thanks
SQL DMO is an API that exposes properties of SQL server enabling you to create an application that can manipulate objects within the server. I believe that the SQL Server Management Studio was built using SQL-DMO. There is also a web-based SQL Server Manager (similar to the one for MSSQL 2000) that is being developed.
You can also use the DMO tools to develop applications that automate tasks like backing up databases on a schedule and the like.
|||Note that if you want to program for SQL Server 2005 then you need SMO, which is the .NET replacement for DMO. DMO works with SQL Server 2005 as well, but you cannot manage any of the new SQL Server 2005 features with it.
No comments:
Post a Comment