跨异构数据库的复制
是否可以使用 SQL Server 复制将数据复制到（双向）Oracle 和 SQL Server 之间？模式完全不同。实时将是一个奖励。
已经调查过 Oracle Golden Gate，它似乎可以完成这项工作，尽管许可证成本并不小！
我想知道是否有人有跨不同模式复制数据的经验，以及他们使用了哪些其他工具？我意识到这是一个开放式问题，但任何建议和以前的经验都是最有用的。
谢谢
邓肯
Is it possible using SQL Server Replication to replicate data to AND from (bi-directional) Oracle and SQL Server? The schemas are completely different. In real-time would be a bonus.
Have already investigated Oracle Golden Gate, which seemed to do the job, although the licence cost is not insignificant!
I wondered if anyone has had any experience in replicating data across different schemas, and what other tools they employed? I realise this is a bit of an open-ended question but any advice and previous experiences would be most useful.
Thanks
Duncan
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我最近必须创建一个解决方案，定期将大量数据从不同数据库（大部分时间从 Oracle 数据库）导入到 SQL Server 数据库（数据仓库）。为此，我使用 SQL Server 集成服务创建了一个包，能够根据需要导入、转换和插入数据（因为它也来自异构源）。该软件附带SQL Server 2005及以上版本，非常易于使用（图形编程）。就您而言，您可以在需要时触发您创建的服务。我不确定这是否是最好的解决方案，因为您需要为每个方向（从 Oracle 到 SQL Server 以及从 SQL Server 到 Oracle）创建 SSIS 服务。
I recently had to create a solution to import periodically lots of data from different databases (most of the time from Oracle databases) to a SQL Server database (a data warehouse). To do so, I used SQL Server Integration Service to create a package able to import, transform and insert the data as I wanted (since it was from heterogeneous sources too). This software comes with SQL Server and the version 2005 and superior is really easy to use (graphical programming). In your case, you could trigger your created services when needed. I am not sure it is the best solution since you would need to create a SSIS service for each direction (from Oracle to SQL Server and from SQL Server to Oracle).