| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2009-04-08 : 13:03:44
|
| Hi all,Can any of you help me in importing dmp file to SQLSERVER 2005.Options I guess is. As the dmp is oracle export files, import back to oracle write a loader script to export it as txt etc, and then import sql serverBut the above option will be time consuming, and needs to write loader scripts.Regards, |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-09 : 01:25:03
|
| any help in this regard ? |
 |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-04-09 : 03:45:30
|
| You can't import dmp file to sql server. You have to first import it into local oracle server. Then using Export/import wizard you will be able import the data in sql server.Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-09 : 07:39:32
|
| Thanks Mangal,So once I am able to import all the files back to oracle using imp utility in Oracle.What would be my next step to load them back to SQLSERVER 2005.If at all I need to do some setup in ODBC etc, can you please let me know this?Thanks again.aak. |
|
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-04-09 : 08:03:43
|
| You can use ODBC or even Oledb drivers. I recommand use of OleDb. Form mangement studio right click on any database >> tasks >> Import Data >> Select data source as OleDb for Oracleput the connection string (you can find it in tnsnames.ora file) in server name.Then just follow the Import wizard.Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-09 : 12:07:10
|
| Thank you so much Mangal, I am waiting for oracle instance on my machine, as soon as I get, I'll import all the table and use oledb to import it back to SQLServer 2005.Best Regards,aak |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-12 : 03:07:23
|
| Thanks all & Magal,I got Oracle 10g R2 version and imported all the file with some DML and access waringsNow I want them to import it to SQL Server 2005.One of my colleague said that, OleDB has createdsome problem for him with datatype after imp to sql2005.Kindly guid me, I am trying to use the one suggested by Mangal.Regards, |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-12 : 11:52:55
|
| any idea about this tool.www.microsoft.com/sql/migration/Did any one happen to use this? |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-13 : 08:01:03
|
| Mangal,I was able to import 2 table with the Oracle provider for ole db however from 3rd table onwards I am getting the below errorsql server ora-01005 null password given logon denied (oraOLEDB) |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-13 : 08:56:00
|
| this is sloved need to select the check box of save password |
|
|
|
|
importing dmp file to sqlserver 2005