Simple Backup/Restore Utility With SQL-DMO Using VB.NET (Page 1 of 5 )
This article primarily introduces the concept of SQL-DMO together with a small and simple Backup/Restore utility developed using the .NET platform. It mainly focuses on the basics of SQL-DMO, its main objects and how to use them in .NET platform to design and develop MS SQL Server based database administration utilities/applications.
A downloadable file for this article is available
here.
Introduction to SQL-DMO
SQL-DMO uses the Microsoft® SQL Server™ ODBC driver to connect to and communicate with instances of SQL Server. SQL-DMO clients require the SQL Server ODBC Driver, version 3.80 or later, which ships with SQL Server 2000. All required SQL-DMO components are installed as part of an instance of the Microsoft® SQL Server™ server or client. SQL-DMO is implemented in a single dynamic-link library (DLL). We may develop SQL-DMO applications on either a client or a server.
SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating the Microsoft® SQL Server™ database and replication management. SQL-DMO is a dual interface COM, in-process server implemented as a dynamic-link library (DLL). SQL-DMO encapsulates SQL Server components, presenting the attributes of the component piece to you as the properties of an object instance. We can alter the properties of the instance, or use object methods to automate SQL Server administration, including replication.
An instance of SQL Server may be viewed as a collection of components. These components may also include several processes or services of SQL Server. An SQL-DMO object exposes the attributes of a Microsoft® SQL Server™ 2000 component to the other applications. The referenced component may be a new or existing database object, a replication or SQL Server Agent component, or could encapsulate a SQL Server management process.
We interact with SQL-DMO objects with the help of the following members with respect to that that object:
- Properties
- Methods
- Events
As they are part of the fundamentals of dot net (or any OOPS) and not a part of SQL-DMO, I leave it to the programmer to understand their functionalities.
Before proceeding further, let us grasp a small idea about the hierarchy of SQL-DMO objects. For quick reference, I included a huge GIF file (as part of a downloadable file) of an SQL-DMO object tree extracted from SQL Server Books On Line. I suggest you download and open it before proceeding to the next page. (See link above near the top of this page).
Next: Understanding SQL-DMO Objects >>
More Visual Basic.NET Articles
More By Jagadish Chaterjee
|
| · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | · | | | | |
|
