Oracle DBF export
-
I have oracle DBF files and I would like to know if there is any way to export data from them? I`m MSSQL user and I don`t know much about oracle .. I have just few DBF files and one ORA file and I don`t know how to export data from them. Any help appreciated. Thanks, Ivan
-
I have oracle DBF files and I would like to know if there is any way to export data from them? I`m MSSQL user and I don`t know much about oracle .. I have just few DBF files and one ORA file and I don`t know how to export data from them. Any help appreciated. Thanks, Ivan
Hi Ivan You would need to install Oracle (you may be able to get away with the Express edition), then attach the DBF files. Once you have an Oracle database up-and-running then you can use DTS or SSIS to transfer the data to your SQL-Server instance. If you have access to an Oracle DBA then you will save yourself a bunch of time. Otherwise you may find that one of the Oracle-specific forums will be able to provide more detailed advice on attaching Oracle databases - just don't tell them that you intend to rip the data in SQL-Server cos that will seriously hurt their feelings ;) Regards Andy
-
Hi Ivan You would need to install Oracle (you may be able to get away with the Express edition), then attach the DBF files. Once you have an Oracle database up-and-running then you can use DTS or SSIS to transfer the data to your SQL-Server instance. If you have access to an Oracle DBA then you will save yourself a bunch of time. Otherwise you may find that one of the Oracle-specific forums will be able to provide more detailed advice on attaching Oracle databases - just don't tell them that you intend to rip the data in SQL-Server cos that will seriously hurt their feelings ;) Regards Andy
-
Andy thank you for instructions ! :) I have had same thinking as you ... so I have started downloading oracle 10g express and SQL developer. Any forums you would recommend ? Thanks allot!
-