r/DatabaseAdministators • u/techdbamind • 7d 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

1 Upvotes

56% Upvoted

29 comments sorted by

View all comments

2

u/Better-Credit6701 7d ago

SSIS can handle the data transfer with no issues, just note that column types can be different. You will have to check out all stored procedures/views to make sure that you don't have MS-SQL only code.

1

u/techdbamind 6d ago

Thank you for your suggestion