SQL Server: Migrate, Load, and Move Data
-
-
-
Migrate databases to SQL
Azure Database Migration Service
Enables seamless migrations from multiple database sources to Azure Data platforms with minimal downtime.
Database Migration Assistant (DMA)
Detects compatibility issues, recommends improvements for your target environment, and moves your database and data.
SQL Server Migration Assistant (SSMA)
Automates database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.
Database Experimentation Assistant (DEA)
Assists in evaluating a target version of SQL Server for an existing workload.
Load and Move Data
BCP
Bulk copy data between a data file, in a format that you specify, and your SQL database.
Import Flat File Wizard
Use the wizard as a simple way to copy data from a flat file (.csv, .txt) into your SQL database.
Import and Export Wizard
Use the Wizard as a simple way to copy data from a wide variety of sources into your SQL database.
SQL Server Integration Services (SSIS)
Extract and transform data from a wide variety of sources, such as flat files and relational data sources, and then load the data into your SQL database.
Replication
A set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.
-
-