Just so you get a reply - I suspect such a tool doesn't exist. You could check with Microsoft if they have a recommend migration approach. Oracle wouldn't make things easy to get out of their software. And seeing how this is an Oracle forum, people are more likely to know about Oracle here than Sql Server.
I need to convert my scripts/procedures/functions developed on oracle to ms sql format. Is there a tool (hopefully Open Source) to do this?
I don't think such a tool exists since there isn't a one-to-one conversion available for that... you are trying to move from a database designed to be scalable for an enterprise to a database that is limited even as a department level database.
Some things to keep in mind procedures are treated differently in MS Access... Output parameters cannot be used, Temporary tables are unavailable, substitution variables for local variables often do no work as expected.
I did (briefly) check to see if there is something that converts Microsoft's SQL server to Microsoft Access... I operating on the theory if there was an enterprise to department database conversion for access, it would be provided within Microsoft's product family... I didn't find anything, but I didn't look for long either.
This may be one of those cases where it will take longer looking for something to get 80% of the work done for you, than it will to just to do the conversion manually.
I like tacos! And this tiny ad:
SKIP - a book about connecting industrious people with elderly land owners