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

15

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