migration oracle data to sql server
-
Hello there,
please tell me one thing, i have create the table in oracle now i wnat to convert all oracle table convert to sql server. Please suggest me how can i do.
Advance thanks for help me for this query.
I hope your response as soon as possible.
thanks,
sunil Kumar
-
Just use SSMA, Micro$oft has invested tons of talent and money in developing the tool, why you wouldn't use it?
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
check for SQLServer Migration Assistant for Oracle.
(there is a sql2005 and a sql2008 version)
free download at http://www.microsoft.com/downloads/details.aspx?familyid=6D9BC6A7-75DA-493E-BEE5-50F4A4352B91&displaylang=en
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I am using SSMA to migrate Oracle 11i to SQL Server 2005. SSMA is free try it.:D
-
check the ms website for more info and prereqs.
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
and
http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply