SQL Server <-----> Oracle

[link9]

Hello all --

This is something that may be sitting on the horizon in the future for me, so I wanted to get some advice.

I know that the DTS will take info from an Oracle database and import it into SQL Server (or anything else for that matter), but can I read a backup file from Oracle to import into SQL Server?

We may be getting a client soon, and their customer database is in Oracle (as luck would have it), and I would very much like to just be able to tell them to do a full backup of the database and send me the file (.bak in SQL Server -- dunno what it is in Oracle).

Has anyone done this, and have some advice so that I wouldn't have to get a direct connection to the database in question to get the customer data?

Thanks in advance.
Paul Prewett

 

[cdukes]

I doubt it very much, especially knowing the competition between Oracle and Microsoft. The format of the backup file created by Oracle will be completely different to microsofts. Would you take years to develope a major word processing package which you are trying to sell and then save documents in WORD format enabling anyone to edit the documents without buying your package ?

You will also find the DataTypes, SQL and all other database objects are completely different to SQLServer.

Have a look at 'Migrating Oracle Applications to MS SQL Server' IN MSDN

Hope this helps,

Chris Dukes