使用Java将Oracle数据库迁移到MS Access的最佳方法是什么? [英] What would be the best method to migrate Oracle database to MS Access using Java?
问题描述
这可能是一个非常基本的问题,但我可以从StackOverflow的专家处获得一些帮助。
This might be a very basic question, but I could use some help with this from the experts here at StackOverflow.
我只是集思广益,权衡所有可用选项。所以,我不需要帮助代码。但是,一些建议或想法会有所帮助。
I am just brainstorming and weighing all the options available. So, I do not need help with the code, please. But, some suggestions or ideas would help.
以下是我认为可行的方法:
Here's what I thought might work:
- 使用JDBC建立与Oracle的ad / b连接
- 运行SQL语句以从Oracle获取数据
- 存储在数据中获取的数据 - 结构
- 使用JDBC-ODBC桥驱动程序建立与MS Access的ad / b连接
- 在Access中创建新的d / b并将其插入其中使用SQL
- 关闭连接
- Making a d/b connection to Oracle using JDBC
- Running SQL statements to fetch data from Oracle
- Storing the data obtained in a data-structure
- Making a d/b connection to MS Access using the JDBC-ODBC bridge driver
- Creating a new d/b in Access and inseting into it using SQL
- Closing the connections
是否有更简单或更有效的方法来执行此操作?
Is there an easier or more efficient way to do this?
另外,这个过程需要为几个客户完成,而ad / b中的每个表都有数百万条记录。手动执行此过程会花费很多时间,所以这不是一个可行的选择。
Another thing, this process needs to be done for several clients and each table in a d/b has millions of records. Doing this process manually would take a lot of time and so it's not such a feasible option.
好的,我讨厌让这个变得复杂。但是,从Oracle导入数据后,我们正在使用Java代码操作数据。因此,在数据转换之后,我们希望将其迁移到MS Access并将其发送到客户端。
OK, I hate to make this complicated. But, after importing data from Oracle, we are manipulating the data using Java code. So, after the data-transformation, we then want to migrate it to MS Access and send it to the client's way.
我非常感谢您的时间和帮助。
I really appreciate your time and help.
推荐答案
我不明白为什么为此编写java程序比手动编写更容易。
I don't see why writing a java-program for this would be easier than doing it manually.
我会将oracle表转储到磁盘,然后将它们导入MS Access。 MS Access自身的导入功能(文件 - >获取外部数据)可能对ODBC导入很有用。
I would dump the oracle tables to disk, them import them to MS Access. Perhaps MS Access own import feature (File -> Get external data) might be useful for an ODBC import.
您甚至可以尝试其中一种(尽管非免费)工具 1 , 2 声称为你做这件事。
You could even try one of the (although non-free) tools 1,2 which claims to do this for you.
这篇关于使用Java将Oracle数据库迁移到MS Access的最佳方法是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!