Abstract
Transferring and manipulating data was once the job of trained database administrators. Tools, such as SQL Server's Data Transformation Services (DTS) have become such important components in database solutions that it is difficult to remember how these tasks were accomplished before they were available. Traditional data import/export utilities are also available in SQL Server 2000. One of the more common tasks involved with administering a database is importing and exporting data. The necessity to import and export data can be spawned by a request from a user, an upgrade to a system, data consolidation, archiving, or testing new application technology. One of the most popular tools for this is Data Transformation Services (DTS). SQL Server 2000 offers additional tools to import and export data. Another tool available to move data into and out of SQL Server is the SQL Server Distributed Management Objects (SQL-DMO). DTS is a series of COM components that allow moving data between disparate sources and performing transformation consolidation and extraction as needed.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
