Web and Dev.... webzil.tistory.com

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

This section contains information about the SQL Server Database Management Objects (SQL-DMO). SQL-DMO is a collection of COM objects that are designed for programming all aspects of managing Microsoft SQL Server.

Note:
SQL-DMO topics will not be in future releases of SQL Server Books Online.

 See Also

Other Resources

Replication Programming
SQL Server Management Objects (SMO)

Help and Information

Getting SQL Server 2005 Assistance

차기 버전 부터는 없어 진다고 하니 그건 SQL 2008을 의미 하는 것인지 모르겠네요 ^^;
암튼 기존에 SQL DMO를 접해 본 경험이 있으므로 프로젝트 정리 차 SQL 2005 DMO를 이용해 볼 예정입니다.

출처 : http://technet.microsoft.com/en-us/library/ms131540.aspx

SQL Native Client is a data access technology that is new to Microsoft SQL Server 2005, and it is a stand-alone data access application programming interface (API) that is used for both OLE DB and ODBC. It combines the SQL OLE DB provider and the SQL ODBC driver into one native dynamic-link library (DLL) while also providing new functionality above and beyond that supplied by the Microsoft Data Access Components (MDAC). SQL Native Client can be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features such as multiple active result sets (MARS), user-defined data types (UDT), query notifications, snapshot isolation, and XML data type support.

참고:
For a list of the differences between SQL Native Client and MDAC, plus information about issues to consider before updating an MDAC application to SQL Native Client, see Updating an Application to SQL Native Client from MDAC.

The SQL Native Client ODBC driver is always used in conjunction with the ODBC Driver Manager supplied with MDAC. The SQL Native Client OLE DB provider may be used in conjunction with OLE DB Core Services supplied with MDAC, but this is not a requirement – the choice to use Core Services or not depends on the requirements of the individual application (for example, if connection pooling is required).

ActiveX Data Object (ADO) applications may use the SQL Native Client OLE DB provider, but it is recommended to use it in conjunction with the DataTypeCompatibility connection string keyword (or its corresponding DataSource property). When using the SQL Native Client OLE DB provider, ADO applications may exploit those new features of SQL Server 2005 that are available via the SQL Native Client via connection string keywords or OLE DB properties or Transact-SQL. For more information about the use of these features with ADO, see Using ADO with SQL Native Client.

SQL Native Client was designed to provide a simplified method of gaining native data access to SQL Server using either OLE DB or ODBC. It is simplified in that it combines OLE DB and ODBC technologies into one library, and it provides a way to innovate and evolve new data access features without changing the current MDAC components, which are now part of the Microsoft Windows platform.

While SQL Native Client uses components in MDAC, it is not explicitly dependant on a particular version of MDAC. You can use SQL Native Client with the version of MDAC that is installed with the operating systems supported by SQL Native Client.

출처 : http://technet.microsoft.com/ko-kr/library/ms130892.aspx