Shulou(Shulou.com)06/03 Report--

How to migrate the schema of a database with DMA? I believe that most people have not yet learned this skill, in order to let you learn, to give you a summary of the following content, do not say much, let's move on.

So if this is the case, DMS is actually not very convenient, but there is a reason, because Microsoft is not only DMS for database migration. DMS has been on the ground in China for less than half a year, but another tool, DMA, can actually be GA several years ago. DMA is a very convenient tool, and it has a very important function that it can do evaluation. For example, before migrating SQL Server to Azure SQL, DMA can be used to evaluate the migration. At the same time, he can also do database migration. We can use DMA to migrate database schema before using DMS to migrate data, so that the whole migration process will be much smoother!

First of all, you need to download the DMA tool. Unlike DMS, DMA is not a SaaS platform, but a tool installed locally, which can be downloaded and installed locally, as long as you can access the database of the source and target on the network.

Https://www.microsoft.com/en-us/download/details.aspx?id=53595

The installation process will not be described in detail, just look at how to use it. Here is the interface of DMA.

We can create a project directly. When we create it, we will see whether we can choose assessment or migration. Let's try it with assessment first. We can see the source and select AWS RDS directly here.

DMA will check the compatibility of the database, because Azure SQL is a relatively lightweight database, some functions are not supported, and there are compatibility problems between different database versions, so it is necessary to evaluate whether there is a similar situation.

After connecting to the source, the information of the source database will be read.

The time of evaluation depends on the number and size of the source database. The amount of data here is very small, so the evaluation process is very fast, and we can also print out the report for screening.

Let's take a look at how to use DMA to migrate the schema of the database. When migrating, the source database does not have the option of AWS RDS, but we can choose SQL Server, and the scope of migration is schema directly. We can use DMS,DMA to migrate data, but DMS can, so the two can actually be used together.

Select the source and target libraries here

You can see here that after reading the source database information, view,procedure will generate corresponding scripts, and then these scripts will be executed on the target database.

After deploy schema, you can see the results.

After arriving at the target library, you can already see these contents, and the primary key of the table is the same as that of the source library.

After that, when you use DMS to migrate, you will no longer indicate that the table does not exist, the primary key does not exist, and so on.

On the use of DMA to migrate the database schema steps to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.