September 6, 2008 at 4:39 am
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
September 7, 2008 at 3:50 am
Just use SSMA, Micro$oft has invested tons of talent and money in developing the tool, why you wouldn't use it? 😉
_____________________________________
Pablo (Paul) Berzukov
Author 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.September 7, 2008 at 5:51 am
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
October 3, 2008 at 9:00 am
I am using SSMA to migrate Oracle 11i to SQL Server 2005. SSMA is free try it.:D
October 3, 2008 at 9:07 am
October 4, 2008 at 12:36 am
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply