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.

Report message to a moderator

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: 21823
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.

Report message to a moderator

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?

Report message to a moderator

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: 21823
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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: export tables in text files
Next Topic: When clause SQL Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 23:24:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.