Copying data from SQL Server to Oracle (merged) [message #332431] |
Tue, 08 July 2008 09:07 |
knapsack3
Messages: 4 Registered: July 2008
|
Junior Member |
|
|
Hi,
I am planning to copy data from SQL Server 2000 to Oracle databse. This is the scenario:
- There are roughly 8 million records to be copied
- The copying is to be done once in 2 days (due to the business logic, this cannot be avoided)
While I think I can use the migration workbench tool for this, I am not sure if the tool is efficient to handle such a huge volume of records.
I am even thinking of accomplishing this through a .Net or a Java program.
Please suggest ways of doing this via Oracle provided tools.
Thanks in advance.
|
|
|
|
Re: Migration workbench tool - Efficient? [message #332476 is a reply to message #332456] |
Tue, 08 July 2008 11:28 |
knapsack3
Messages: 4 Registered: July 2008
|
Junior Member |
|
|
Hi,
Thanks for the reply.
I have been thinking that in a database to database copying, using a program ( written in Java or .Net) as a tool to copy is less efficient and it is always better to do such copying through the common platform which is database.
Can anybody confirm this for the above scenario.
Thanks.
|
|
|
Re: Migration workbench tool - Efficient? [message #334262 is a reply to message #332476] |
Wed, 16 July 2008 00:38 |
knapsack3
Messages: 4 Registered: July 2008
|
Junior Member |
|
|
Hi,
I saw that the work bench tool can be used only once, per migration.
But my requirement is that this copying of data needs to be done once in every 2 days in which case I think this tool mayn't be a good option.
Any other suggestions.
Thanks.
|
|
|
Copying data from SQL Server to Oracle [message #334288 is a reply to message #332431] |
Wed, 16 July 2008 01:50 |
knapsack3
Messages: 4 Registered: July 2008
|
Junior Member |
|
|
Hi,
(I had earlier posted this message under Server Administration. but thought this is a better forum for this)
I am planning to copy data from SQL Server 2000 to Oracle databse. This is the scenario:
- There are roughly 8 million records to be copied
- The copying is to be done once in 2 days (due to the business logic, this cannot be avoided)
I initially thought of doing this using the Migration workbench tool, but since this is going to be a recurring job, I couldn't use the Migration workbench tool.
Now I am looking into some other possible way.
Can somebody suggest a good tool for this in Oracle?
Thanks in advance.
|
|
|
|
|