Bill
OK, you can use cXase to import the SQL server schema and convert it to Oracle, just like that. All syntax, field mapping, default differences, primary key indexing, autoincrements etc handled for you. Save yourself a mountain of grief!
Do you use RV's? If so, load them into xcase as well so you can click a button to create the views against whatever backend, all properly set up. And you can add or alter fields and click the button again and it will manage that annoying "the underlying fields have changed..." message you get which is one of the big criticisms of RV's.
Apart from a few minor glitches xCase works well. I've had it since the very first version (1995 I think) and have upgraded ever since.
Regards
JR
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
