SQL-DMF: SQL Distributed Management Framework is a set of utilities that are not part of the database engine (like Query Analyzer and Enterprise Manager). There are three application programming interfaces, or utilities that allow us to access all the objects in the SQL Server. They are:
SQL Namespace - SQL-NS
SQL Distributed Management Objects - SQL-DMO
SQL Data Transformation Services - SQL-DTS
DTS, which stands for Data Transformation Services, enable transfer of data and objects between different SQL 2000 Server systems. DTS was originally created to transfer data from OLTP data into OLAP data, which included the various steps of extracting the data, cleansing and transforming to remove inconsistencies, and then loading the data (popularly known as ETL). DTS can validate and summarize data while transferring -- making it extremely powerful.
DTS is available to all SQL Server editions from Enterprise to MSDE. DTS uses OLEDB, so it can be used for transferring data from one OLEDB to another OLEDB and therefore is not specific to SQL Server. It could be used to transfer data between any OLEDB supported databases, for example between Oracle to MS Access without an SQL 2000 middle man. Since Microsoft OLEDB for ODBC can connect to ODBC sources, the data transfer functionality is extended to ODBC sources, and DTS assumes an even more powerful role.
This article will be very useful if you are still using SQL Server 2000
SSIS replaced DTS in the recent SQL Servers after its 2000 Version. If you want a jump start on SSIS, I recommend my books which describes some 20 ETL Tasks. This book may be purchased from Amazon.com
SQL Namespace - SQL-NS
SQL Distributed Management Objects - SQL-DMO
SQL Data Transformation Services - SQL-DTS
DTS, which stands for Data Transformation Services, enable transfer of data and objects between different SQL 2000 Server systems. DTS was originally created to transfer data from OLTP data into OLAP data, which included the various steps of extracting the data, cleansing and transforming to remove inconsistencies, and then loading the data (popularly known as ETL). DTS can validate and summarize data while transferring -- making it extremely powerful.
DTS is available to all SQL Server editions from Enterprise to MSDE. DTS uses OLEDB, so it can be used for transferring data from one OLEDB to another OLEDB and therefore is not specific to SQL Server. It could be used to transfer data between any OLEDB supported databases, for example between Oracle to MS Access without an SQL 2000 middle man. Since Microsoft OLEDB for ODBC can connect to ODBC sources, the data transfer functionality is extended to ODBC sources, and DTS assumes an even more powerful role.
This article will be very useful if you are still using SQL Server 2000
SSIS replaced DTS in the recent SQL Servers after its 2000 Version. If you want a jump start on SSIS, I recommend my books which describes some 20 ETL Tasks. This book may be purchased from Amazon.com
No comments:
Post a Comment