316 lines (315 loc) · 17.3 KB

layout

HubPage

hide_bc

true

experimental

true

experiment_id

81ba5f65-59fb-4d

title

SQL Server - Load and move data

description

Explore the features that help you load, move, and migrate databases and data with SQL Server.

ms.topic

hub-page

ms.prod

sql

author

MashaMSFT

ms.author

mathoma

manager

craigg

ms.date

12/15/2018

featureFlags

clicktale

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.

Keep in touch with us