Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Regarding database migration from Oracle to MS SQ

Author  Topic 

vipinvijay
Starting Member

1 Post

Posted - 2012-03-26 : 08:00:24
Hi All,

In my application, the existing database is oracle. we need to migrate from Oracle db to MS SQL.
We need procedure is as below
1.export data from Oracle and keep it in a file.(.dmp)
2.Import data to MS SQL from the exported oracle file.

and vice versa from MS SQL to Oracle.

my question is- is it possible to import .bmp (oracle export data) into MS SQL.

Please clarify me.
   

- Advertisement -