Import database from Oracle to MS--SQL2000

kennard_chue
kennard_chue used Ask the Experts™
on
Hi

I would like to find out if there is any article on how to export the Oracle database to MS SQL Server 2000 cause I can't find any (though there are a lot for the other way round).

TheSQL Server 2000 would be used for testing purpose for now and the Oracle server would be live server.

We are running on Win NT platform.

Appreciate if you can give me the link or you can show me the steps to do so. Thanks for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You should probably ask this In the DB area.

but check out:
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/dts_overview.htm
http://builder.com.com/article.jhtml?id=u00320021022ton01.htm&page=1&vf=tt [shows how to export but states that import is similar]

Author

Commented:
Ops...
Thanks....

Btw, cheekyci, thanks for your link but that is not what I want. Nevertheless, appreciate for your help.

Commented:
Did you resolve this?

CJ

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept cheekycj's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

krispols
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial