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.
• Transact-SQL
• 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.