SQL Server - Data Integration
Tools
- Microsoft® SQL Server® Integration Services (SSIS) as a platform for building ETL solutions.
- The Import and Export Data Wizard. (in the SQL Server management tools). Create an SSIS-based data transfer solution.
- bcp utility (command line for extracting data from, and inserting data into, SQL Server)
- Replication. SQL Server includes built-in replication functionality that you can use to synchronize data across SQL Server instances.