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.

Powered by ComboStrap