散分啦

Question

各位大侠:现在有两个数据库, 一个是Oracle DB, 一个是MS SQL Server.
我的问题是想将Oracle DB中的一个表的数据同步到 MS SQL Server 中一个表.
我试过用MS SQL中的订阅好像不行. 我想过用存储过程.大伙儿帮帮忙看看, 有没有好的方法.回复的都有分哈!

Answer 1

我第一个回答，MS DTS轻松搞定，如果你不会，可以使用它的向导！

Answer 2

jie feu la
shu ru fa bu hao .jian liang

Answer 3

MS DTS试过吗，应该可以的，虽然没有试验过

Answer 4

MS DTS的功能很多呢，仔细看看吧，会有意外收获喔

Answer 5

MS SQL Server可做为同步的订阅端

Answer 6

在SQL中写一个过程，同步执行

Answer 7

反正散分的,我UP,只要不违犯程序,UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<UP<