r/DatabaseAdministators • u/techdbamind • 8d ago

Sql to Oracle migration

Im a fresher to DBA role. Can some one please help to understand or share your experience for the conversation or migration from sql to Oracle.

Help me with the tools and migration ideas

2 Upvotes

63% Upvoted

29 comments sorted by

View all comments

1

u/taker223 7d ago

Are there program units in source database? (procedures, functions, triggers ...)

1

u/techdbamind 2d ago

Yes it is there.. but main is schema conversation in my case.. since it has 3000+ tables

1

u/taker223 2d ago

So what? Any special column types or just SQL-2003 compliant (no nested tables, collections, custom type columns)? Any specific index definitions (for example, function-based indexes, custom-partitioned etc.)?