Home » RDBMS Server » Server Utilities » data migration
data migration [message #185747] Thu, 03 August 2006 07:13 Go to next message
helloanam
Messages: 20
Registered: August 2005
Junior Member
i just want any kind of help regarding making "Scripts" which are used in data migration. These scripts have to perform all the tasks of data migratin from one DB to another and we also have to verify its correctness.
Any help is appreciable.
Re: data migration [message #185798 is a reply to message #185747] Thu, 03 August 2006 12:06 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What databases are you talking about? dBASE III -> Oracle 10g or Access -> Oracle 7.3 or Paradox -> Oracle Lite (that one isn't quite a good idea)?

If it is about migration from one Oracle database to another, you might, perhaps, consider term upgrade instead of migration.

Basically, you don't need any scripts: create a new database, perform full database export on an old database and then full import into newly created one.
Re: data migration [message #185849 is a reply to message #185798] Thu, 03 August 2006 17:38 Go to previous messageGo to next message
helloanam
Messages: 20
Registered: August 2005
Junior Member
i am talking abt oracle 9i. its the req to migrate data by scripts which can be run any time just by changing names of dbs and it performs all the tasks automatically.

is it possible to write an export and import script?

if yes then can any one help me?
Re: data migration [message #185877 is a reply to message #185849] Fri, 04 August 2006 00:18 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see; if those databases are in the same network, perhaps you could consider using materialized views instead of copying data between databases. They can be refreshed whenever you wish, without writing any scripts.
Re: data migration [message #185918 is a reply to message #185877] Fri, 04 August 2006 04:37 Go to previous message
angelsliu
Messages: 23
Registered: July 2006
Junior Member
Littlefoot wrote on Fri, 04 August 2006 00:18

I see; if those databases are in the same network, perhaps you could consider using materialized views instead of copying data between databases. They can be refreshed whenever you wish, without writing any scripts.



maybe clone is best practise
Previous Topic: export tables in text files
Next Topic: When clause SQL Loader
Goto Forum:
  


Current Time: Thu Dec 08 02:30:03 CST 2016

Total time taken to generate the page: 0.13270 seconds