restoring from Oracle backup

Hello All,
I have a oracle backup file with the extension .dmp now i am not able to
restore that to SQL Server 2000 database.Can anybody help me with this.
regards
DilishHi,
No, You cant restore the Oracle dump to SQL server due to architectural
differences.
Please use DTS to copy table structure and data from Oracle to SQL server.
Have a look into this link for Oracle to SQL Server migration
http://www.microsoft.com/resources/.../reskit/en-us/p
art2/c0761.mspx
"dilish" <dilish@.covisible.com> wrote in message
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not able
to
> restore that to SQL Server 2000 database.Can anybody help me with this.
> regards
> Dilish
>|||There is no way you can restore a backup of an Oracle db directly to SQL =
Server, the internal file structures will be totally different.
You will need to restore the oracle db backup to a system running =
Oracle, and then move the data across using DTS or similar.
MIke John
"dilish" <dilish@.covisible.com> wrote in message =
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not =
able to
> restore that to SQL Server 2000 database.Can anybody help me with =
this.
>=20
> regards
> Dilish
>=20
>|||thank u for the information but the here i have a problem that i dont have a
Oracle running on the system.I mean i do not have a Oracle database but just
the backup file.Actually the problem goes like this.
I am having my clients distributed with all running on SQL server
2000 but one client is running on Oracle,I synchronise my central
database,which is again SQL Server 2000 where in i have a separate database
for each client, by simply getting their weekly backups and updating the
central server.Now my new client who is already having an Oracle database
doesnt want to switch to SQL so i am finding it difficult to get his data
onto my server.Means either i will have to go or a separate database,ie
ORACLE or he will have to change to SQL server.
now can u suggest me ways to get this problem solved.
NOTE: the client and Server are not dedicatedly connected.
"dilish" <dilish@.covisible.com> wrote in message
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not able
to
> restore that to SQL Server 2000 database.Can anybody help me with this.
> regards
> Dilish
>|||Work with the client to develop an automated export routine from their
database and a corresponding import routine on your system. Oracle provides
import/export features just as SQL Server does.
Alternatively, consider purchasing Oracle, you could then do the migration
from Oracle to SQLServer at your own site.
David Portas
SQL Server MVP
--