| migrating data [message #368358] |
Thu, 30 November 2000 15:47  |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
|
Can someone show me a script to migrate data from one database to another? Is there a tool that I can use to do this?
|
|
|
|
| Re: migrating data [message #368360 is a reply to message #368358] |
Fri, 01 December 2000 09:10  |
-sven
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
I can't determine from your post exactly what it is you're trying to convert, but we have had some success using Oracle's Migration Workbench (available at Oracle website) to convert MS Access and MS SqlServer databases to Oracle. And of course you can always import text files into an Oracle database schema that you've built manually, assuming the database you are coverting from can export data as text.
Good luck! -Sven
|
|
|
|
| Re: migrating data [message #368365 is a reply to message #368360] |
Sun, 03 December 2000 20:56 |
Ed
Messages: 24
Registered: November 1999
|
Junior Member |
|
|
Hi,
how about tranfer data and database structure
fr oracle(ver 8) to oracle.Can i use oracle migration workbench too.Thanks for help.
|
|
|
|
|
|
| Re: migrating data [message #368368 is a reply to message #368360] |
Mon, 04 December 2000 08:36 |
-sven
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
Ed,
I think Migration Workbench is a tool for converting non-Oracle databases to Oracle.
If you're converting between different versions of Oracle, then Oracle's Export and Import tools are probably your best bet.
Good luck! -Sven
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
