Data Migration

By geminikid_01 ·
I want to migrate data from oracle 9.1 to sql server in the same platform(Windows). How can i do so using commands/coding??..

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

This might help you .....


Create an Oracle 10g database on your Linux server, export your Oracle9i database, FTP the .dmp file over to the Linux server and import it into your newly created database.

Create Table As Select (CTAS) via a database link

Create an Oracle 10g database on your Linux server and create a database link from the Oracle 10g database to the Oracle9i database. Run 'create table as select ?' statements to create your tables with the data in the Oracle 10g database. Remember to also create any required indexes, constraints and referential integrity.

Use Oracle 10g cross-platform transportable tablespaces

Because your source server is Windows 2003, you can install Oracle 10gR2 on your Windows server, upgrade your database in place and then use the new cross-platform transportable tablespaces feature to move your database to your Linux server. Both Windows and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) and they are of the same endianness (little endian) so there is no need to convert the tablespaces being transported.

To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network.

Please post back if you have any more problems or questions.
If this info is useful, please mark it helpful. Thanks

Related Discussions

Related Forums