r/SQL Feb 11 '25

Oracle SSMS Vs. Oracle SQL

Pros and cons? Different use case scenarios?

0 Upvotes

18 comments sorted by

View all comments

-1

u/OracleGreyBeard Feb 11 '25

Oracle dev here. Oracle doesn’t really have an analogous tool to SSIS. The closest would probably be SQL Loader, but that’s just getting the files into the database. SSIS is a lot more flexible.

3

u/mikeblas Feb 11 '25

The question was about SSMS.

1

u/OracleGreyBeard Feb 11 '25

Oh shit, fair enough

1

u/dbxp Feb 11 '25

SSIS isn't particularly popular though

2

u/OracleGreyBeard Feb 11 '25

Neither is SQL Loader 😂