SqlServer 提供的数据迁移方案

梦里梦外; 2024-02-26 03:53 60阅读 0赞

[SQL Server migration documentation - SQL Server | Microsoft Learn][SQL Server migration documentation - SQL Server _ Microsoft Learn]

### SQL Server to SQL Server ###

#### Overview ####

*  [Data Migration Assistant (DMA)][Data Migration Assistant _DMA]
 *  [Database Experimentation Assistant][]

#### Download ####

*  [Data Migration Assistant (DMA)][Data Migration Assistant _DMA 1]
 *  [Database Experimentation Assistant][Database Experimentation Assistant 1]

### non-SQL to SQL & Azure ###

#### Overview ####

*  [SQL Server Migration Assistant (SSMA)][SQL Server Migration Assistant _SSMA]

#### Get Started ####

*  [From Oracle][]
 *  [From Access][]
 *  [From DB2][]
 *  [From mySQL][]
 *  [From Sybase][]

### SQL Server to Azure SQL ###

#### Overview ####

*  [Migrating SQL Server Workloads FAQ][]
 *  [Azure SQL Database][]
 *  [Azure SQL Server virtual machine][]

#### Deploy ####

*  [Database Migration Service (DMS)][Database Migration Service _DMS]
 *  [Data Migration Assistant (DMA)][Data Migration Assistant _DMA]

#### Concept ####

*  [Broader migration process][]

### Resources ###

#### Overview ####

*  [SQL Server Migration Center][]
 *  [Database migration guide][]
 *  [Azure Migration Service][]
 *  [Data migration blog][]
 *  [Modernizing SQL Server (SQL Pass)][Modernizing SQL Server _SQL Pass]

#### Download ####

*  [Microsoft Assessment and Planning (MAP) toolkit][Microsoft Assessment and Planning _MAP_ toolkit]

### End of support ###

#### Overview ####

*  [End of support options][]
 *  [SQL Server 2012][]
 *  [Extended Support Updates (ESUs)][Extended Support Updates _ESUs]
 *  [ESU frequently asked questions][]
 *  [Free ESUs with Azure VM][SQL Server 2012]

#### Download ####

*  [Extended security updates datasheet PDF][]

[SQL Server migration documentation - SQL Server _ Microsoft Learn]: https://learn.microsoft.com/en-us/sql/sql-server/migrate/?view=sql-server-ver16
[Data Migration Assistant _DMA]: https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16
[Database Experimentation Assistant]: https://learn.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver16
[Data Migration Assistant _DMA 1]: https://www.microsoft.com/download/details.aspx?id=53595
[Database Experimentation Assistant 1]: https://www.microsoft.com/download/details.aspx?id=54090
[SQL Server Migration Assistant _SSMA]: https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver16
[From Oracle]: https://learn.microsoft.com/en-us/sql/ssma/oracle/sql-server-migration-assistant-for-oracle-oracletosql?view=sql-server-ver16
[From Access]: https://learn.microsoft.com/en-us/sql/ssma/access/sql-server-migration-assistant-for-access-accesstosql?view=sql-server-ver16
[From DB2]: https://learn.microsoft.com/en-us/sql/ssma/db2/migrating-db2-data-into-sql-server-db2tosql?view=sql-server-ver16
[From mySQL]: https://learn.microsoft.com/en-us/sql/ssma/mysql/sql-server-migration-assistant-for-mysql-mysqltosql?view=sql-server-ver16
[From Sybase]: https://learn.microsoft.com/en-us/sql/ssma/sybase/sql-server-migration-assistant-for-sybase-sybasetosql?view=sql-server-ver16
[Migrating SQL Server Workloads FAQ]: https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/modernization
[Azure SQL Database]: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview
[Azure SQL Server virtual machine]: https://learn.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-overview
[Database Migration Service _DMS]: https://learn.microsoft.com/en-us/azure/dms/
[Broader migration process]: https://learn.microsoft.com/en-us/azure/cloud-adoption-framework/migrate/expanded-scope/sql-migration
[SQL Server Migration Center]: https://azure.microsoft.com/migration/sql-server/
[Database migration guide]: https://learn.microsoft.com/en-us/data-migration/
[Azure Migration Service]: https://azure.microsoft.com/services/azure-migrate/
[Data migration blog]: https://techcommunity.microsoft.com/t5/Microsoft-Data-Migration/bg-p/MicrosoftDataMigration
[Modernizing SQL Server _SQL Pass]: https://www.youtube.com/watch?v=5RPkuQHcxxs
[Microsoft Assessment and Planning _MAP_ toolkit]: https://www.microsoft.com/download/details.aspx?id=7826
[End of support options]: https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-end-of-support-overview?view=sql-server-ver16
[SQL Server 2012]: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-extend-end-of-support
[Extended Support Updates _ESUs]: https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-extended-security-updates?view=sql-server-ver16
[ESU frequently asked questions]: https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/extended-security-updates-frequently-asked-questions?view=sql-server-ver16
[Extended security updates datasheet PDF]: http://download.microsoft.com/download/A/3/F/A3F0908A-0FD8-494C-82BC-E75F313F3FAD/Extended_Security_Updates_for_Windows_Server_2008_and_SQL_Server_2008_End_of_Service.pdf