不同库表数据库迁移工具_Microsoft提供的数据库迁移助手工具概述

大家好，我是讯享网，很高兴认识大家。

不同库表数据库迁移工具

This article gives the overview of the Database Migration Assistant Tool to access, plan and migrate the SQL Server from an old version.

本文概述了用于从旧版本访问，计划和迁移SQL Server的数据库迁移助手工具。

Database migration is part of the DBA job. We can’t avoid it, and there are multiple options that can be taken:

数据库迁移是DBA工作的一部分。我们无法避免，可以采取多种选择：

From SQL Server to SQL Server
从SQL Server到SQL Server
From another platform (Oracle Database, MySQL, PosgreSQL…) to SQL Server
从另一个平台（Oracle数据库，MySQL，PosgreSQL等）到SQL Server
From SQL Server to another platform (Oracle Database, MySQL, PosgreSQL…)
从SQL Server到另一个平台（Oracle数据库，MySQL，PosgreSQL等）

We can also perform a so-called “in-place” migration or a “side-by-side” migration. In the first one, everything will be performed on the same server. We could say that the source for the migration is also the destination of that migration. In the second, source and destination roles are physically separated. This means one server is the source and another server is the destination. Choosing one or the other depends on the migration context and environment, but in my career, we always chose a side-by-side migration because the OS and the server had to be upgraded or changed.

我们还可以执行所谓的“就地”迁移或“并排”迁移。在第一个中，所有操作都将在同一服务器上执行。我们可以说，迁移的来源也是该迁移的目的地。第二，源角色和目标角色在物理上是分开的。这意味着一台服务器是源，另一台服务器是目的地。选择一个或另一个取决于迁移环境和环境，但是在我的职业生涯中，我们总是选择并行迁移，因为必须升级或更改OS和服务器。

You will definitely opt for a side-by-side migration when you want to migrate an Oracle database on Linux to a SQL Server on Windows so as a SQL Server on Windows to a SQL Server on Linux.

如果要将Linux上的Oracle数据库迁移到Windows上SQL Server，例如Windows上SQL Server到Linux上SQL Server，则肯定会选择并行迁移。

To help DBAs in this task that can be quite risky, Microsoft provides a bunch of tools that we will review in present article. You will find below a non-exhaustive list of these tools.

讯享网

为了帮助DBA承担可能相当冒险的这项任务，Microsoft提供了很多工具，我们将在本文中对其进行回顾。您会在下面找到这些工具的详尽列表。

Database Migration Guide 数据库迁移指南
Microsoft Assement and Planning Toolkit a.k.a MAP Microsoft评估和计划工具包又称为MAP
Database Migration Assistant a.k.a. DMA 数据库迁移助手又名DMA
Database Experimentation Assistant a.k.a DEA 数据库实验助手又名DEA
SQL Server Migration Assistant a.k.a. SSMA SQL Server迁移助手又名SSMA
- For SQL MySQL
  对于SQL MySQL
- For Oracle
  对于Oracle
- For Access
  用于访问
- …
  …
…
…

Let’s review some of these tools…

让我们回顾一下其中的一些工具...

数据库迁移指南 (Database Migration Guide)

Database Migration Guide is at first a website that will help you in a database migration. You can follow this link to get to the tool.

首先，《数据库迁移指南》是一个网站，它将帮助您进行数据库迁移。您可以单击此链接转到该工具。

Here is how it looks like:

看起来是这样的：

不同库表数据库迁移工具_Microsoft提供的数据库迁移助手工具概述

数据库迁移指南 (Database Migration Guide)

相关推荐