Microsoft touts new database functions
InfoWorld | at | by Mike
Microsoft on Wednesday detailed tools planned for increasing database administration capabilities in the current and upcoming versions of the company's SQL Server database. The company revealed the details during its 2003 Professional Association for SQL Server (PASS) Community Summit meeting in Seattle.
One of the tools to be featured in the planned "Yukon" version of SQL Server due in 2004, a reconstituted Data Transformation Services (DTS) technology for extracting, transforming, and loading (ETL) of data, is intended to provide scalable and manageable ETL services. DTS will feature graphical debugging and built-in transformations such as "fuzzy lookup" to allow developers to more easily develop enterprise applications. Also to be featured in the DTS architecture are transaction support, the ability to restart, data error handling, and data cleansing.