将数据从sql server(源)加载到oracle(目标) [英] Load data from sql server(source) to oracle (target)

问题描述

我被要求在Oracle中创建新表并从MS Sql Server向其中加载数据.我使用星型模式与事实和维度表在oracle中创建表，并为维度表中的唯一id列创建了序列，并触发了将序列分配给该特定列的触发器.这是我的大问题，因为我是这个数据仓库的新手，我从未完成将数据从一个数据库(sql server)加载到另一数据库(oracle)的工作，有人告诉批量加载器将是最佳选择，而有人说SSIS包会是最好的.请让我知道哪一个最好，哪个可以快速加载数据，并请给我一些说明或说明链接以执行这些特定过程，因为我是这个概念的新手.

在此先感谢

Hi,

I was asked to create new tables in Oracle and load data in to it from MS Sql Server. I created the tables in oracle using star schema with fact and dimension tables and I created sequences for unique id columns in dimension table and triggers to assign the sequences to that particular column. Here is my big problem as I am new to this data warehouse part I never done loading data from one data base (sql server ) to other data base (oracle ), some one told that bulk loader will be best option and some said SSIS package will be best. Which one is best and which will load data fast please let me know, and please give me some instructions or links of instructions to do these particular process as I was new to this concept.

Thanks in advance

推荐答案

您可以为此使用SSIS.尽管使用MS Oracle提供程序可能会很慢.为此，您可以使用此 [ ^ ].

如果您完全不熟悉SSIS，请此 [

You can use SSIS for this purpose. Although using MS Oracle provider might turn out to be slow. To take care of that, you can use this[^] from MS.

If you are totally new to SSIS, this[^] should be a good start.

Oracle ODAC支持批量加载，您可以从此处下载:
Oracle .NET开发人员中心 [创建数据库链接 [ ^ ]语句创建到SQL Server的数据库链接.

或尝试 Sql Loader Utility [

Oracle ODAC supports bulk loading, you can download it from here:
Oracle .NET Developer Center[^]

Bulk loading outperforms data inserts using sql from .Net.

You can also Use the CREATE DATABASE LINK[^] statement to create a database link to the SQL Server.

Or try Sql Loader Utility[^]

If the database isn''t huge - choose what you are comfortable with ...

Bulk load using ODAC is fairly fast

Regards
Espen Harlinn

这篇关于将数据从sql server(源)加载到oracle(目标)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！