从Oracle到SQL Server的数据迁移 [英] Data Migration From Oracle To SQL Server

问题描述

我有一个Oracle数据库，其中有一个或多个表.我也有Blob数据，即存储图像，现在我想将该数据移到Sql Server数据库中.最好的方法是什么?

I have an Oracle database in which there is one or more table. I also have blob data, i.e. images are stored, now I would like to move that data to Sql Server database. What is the best way to do this?

我想对它进行一次表迁移测试，该迁移包含Oracle数据库中的图像数据，然后将其移到SQL Server表中.

I would like to test it for one table migration which contains image data in the Oracle database and move it into SQL Server table.

如何测试将数据从一个表从Oracle迁移到SQL Server?

How do I test for migrating data from one table from Oracle to SQL Server?

但是我想确认的第一件事是，是否可以将图像数据从Oracle DB迁移到SQL Server DB，在迁移时是否需要注意什么?

But first thing I would like to confirm is that whether Image data moving from Oracle DB to SQL Server DB is possible, is there anything that has to be taken care of while migrating ?

推荐答案

我建议您看看 SQL Server集成服务(SSIS).

I'd recommend having a look at SQL Server Integration Services (SSIS).

SSIS是为数据仓库而构建的ETL(提取，转换和加载)工具，但它对于迁移数据也非常有用.它基本上替代了旧的SQL Server数据转换服务(DTS)，是一种功能强大且性能快速的工具，可让您将数据从一个系统移动到另一个系统(包括Oracle)，同时使您能够在必要时进行数据转换.

SSIS is a ETL (Extract, Transform and Load) tool built for Data Warehousing, but it's also great for migrating data. It basically replaces the old SQL Server Data Transformation Services (DTS), and is a robust and fast-performing tool allowing you to move data from one system to another (which includes Oracle), while giving you the ability to transform data where necessary.

它还具有工作流程功能，可让您设置执行路径(即在加载发票数据之前先加载客户端数据).

It also has work-flow capabilities, allowing you to set up an execution path (i.e. load client data prior to loading invoice data).

在建立各个步骤的同时，您可以轻松地查看传入的数据以及流过设置的不同对象的数据.

While building up the individual steps, you can easily have a look at the data coming in and flowing through the different objects you set up.

最重要的是，如果您至少运行SQL Server Standard Edition，则SSIS基本上是免费提供的.

Best of all is that if you run at least SQL Server Standard Edition, SSIS basically comes with it for free.

最后，关于图像的问题，斑点只是斑点.二进制数据流.我没有尝试将图像从一个迁移到另一个，但是我看不出为什么它不起作用.

Lastly, regarding the question about images, blobs are just blobs. Streams of binary data. I haven't tried migrating images from one to the other, but I see no reason why it would not work.

这篇关于从Oracle到SQL Server的数据迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！