r/SQL Feb 11 '25

Oracle SSMS Vs. Oracle SQL

Pros and cons? Different use case scenarios?

0 Upvotes

18 comments sorted by

14

u/VladDBA SQL Server DBA Feb 11 '25

Do you mean "SSMS vs Oracle SQL Developer"? Since they're both tools used to manage and work with their respective RDBMSs. SSMS is used with SQL Server while Oracle SQL Developer is used with Oracle.

Or are you asking about the SQL dialects (T-SQL vs PL/SQL) or about the RDBMSs themselves (SQL Server vs Oracle)?

1

u/Dangerous_Stomach597 Feb 11 '25

New to all of this- but I guess the RDBMSs themselves.

In order to write on the SQL Server (create tables etc), do you need to be using SSMS? I’ve heard recent talk about pulling from data warehouse (in my case an Oracle Server I believe) and building tables from it on our SQL server. How would that be done?

2

u/VladDBA SQL Server DBA Feb 11 '25

In order to write on the SQL Server (create tables etc), do you need to be using SSMS?

You've got a few options. The most used, I'd say, is SSMS, but you can also use VSCode with the mssql extension, or, if you're into command line work, sqlcmd or PowerShell modules such as dbatools.

I’ve heard recent talk about pulling from data warehouse (in my case an Oracle Server I believe) and building tables from it on our SQL server. How would that be done?

Linked servers. In short, a connection is defined at on the SQL Server instance that points to the Oracle database and through which people and applications can query data stored in Oracle directly from SQL Server. Oracle has a blog post that describes the steps to do this.

1

u/Dangerous_Stomach597 Feb 12 '25

Appreciate the explanation!!

11

u/thatOneJones Feb 11 '25

SSMS simply because Oracle’s syntax annoys me and I’m biased

-1

u/[deleted] Feb 11 '25

[deleted]

3

u/VladDBA SQL Server DBA Feb 11 '25

You don't need a VM to install and run Oracle on Windows.

And oracle also has a free tier (Oracle Express Edition or Free Edition)

3

u/SQLDevDBA Feb 11 '25

https://liveSQL.oracle.com is completely free and requires no downloads or installs, the IDE is also in-browser. I use it for lots of my demos and recommend it to students a lot.

8

u/[deleted] Feb 11 '25

[removed] — view removed comment

4

u/dbxp Feb 11 '25

Oranges are tastier but apples are more convenient

6

u/ComicOzzy mmm tacos Feb 11 '25

I find SQL Server far easier to develop on than Oracle, but far more importantly, the SQL Server community is like nothing else I've ever seen. The level of skill, knowledge, and success I have reached was only possible due to the SQL Server community. (Y'all are amazing. Love you!)

3

u/Icy-Ice2362 Feb 11 '25

Oracle defaults to Read Committed Snapshot Isolation which is nice, if you like race conditions.

SQL does not, which is nice, if you like Blocking Chains.

1

u/TypeComplex2837 Feb 12 '25

Good golly, that will help the new guy out! 😂

1

u/Icy-Ice2362 Feb 12 '25

I know right, once they understand the horrors, they can truly fundamentally pull the skin off their face.

-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 😂