December 19, 2001 at 7:19 am
Hello,
I need some tools for the migration of oracle databases to sql server.
main problem we see ist to translate the plsql to transact sql.
does someone know some products which translate or give suppot by the translation.
thank you
karl schuerz
austria
December 19, 2001 at 7:42 am
Don't know of any tools for this, but there are documents to help on Technet:
I converted an Oracle system last year. Seem to remember that there were far less datatypes available (eg they used char(1) rather than bit to represent true or false). Once I'd created a more viable schema in SQL Server I used Transformation tasks in DTS to import and transform the data and executed a script to create DRI after that. The sequences were all replaced with identity columns, and we autogenerated the sps (there are plenty of tools around for this), so that only left the triggers. We used TOAD to view the triggers and recreated them by hand. Admittedly this was not a huge system, but the conversion wasn't as much of a problem as I anticipated. Good luck with yours.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply