Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarah_shirin
Starting Member
5 Posts |
 Posted - 2002-10-27 : 23:30:34
|
| hello,I have to move my application running on Oracle 8 to Sql Server. For this Conversion i got to figure out as to which of the functions used in my queries is Oracle specific and Use an equivalent of that in SQL server for the smooth Database COnversion.1) R there any docs on the net which gives me a lsit of equivalent functions of Oracle and Sql Server & also other DB's? If Yes. can u please provide me with the link...(my search on google wasn't successfull)2) Is there an easier way for me to accomplish this... I am not that well versed in DB..so as of now ..i pick up an oracle function and c its equivalent in Sql server.Can somebody help me please......Thanking in advance |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-10-28 : 02:10:58
|
Hi there,Check this Link http://www.sqlmag.com/Articles/Index.cfm?ArticleID=14170 . it might be useful.you are better off with trial and error , that way you will know what exactly you are changing. though the article i mentioned talks about a automated software Toplink to convert from Oracle to Sqlserver, but i havent used it anytime so cant say much about it.P.S : you have a cute name -------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-10-28 : 05:35:10
|
| I recently wrote an article on this topic. Though its not meant to be comprehensive, it will at least get you started:http://www.sqlteam.com/redir.asp?ItemID=11324--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
Conversion from Oracle to Sql Server