Home » RDBMS Server » Server Utilities » migrating data
migrating data [message #368358] Thu, 30 November 2000 15:47 Go to next message
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 Go to previous messageGo to next message
-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 Go to previous messageGo to next message
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 #368367 is a reply to message #368360] Mon, 04 December 2000 08:17 Go to previous messageGo to next message
jack
Messages: 123
Registered: September 2000
Senior Member
Thanks guys!
Re: migrating data [message #368368 is a reply to message #368360] Mon, 04 December 2000 08:36 Go to previous message
-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
Previous Topic: Trailing minus in SQLLoader
Next Topic: Startup Problem
Goto Forum:
  


Current Time: Thu Dec 09 07:25:18 CST 2021