你需要Oracle驱动程序和使用该驱动程序的连接字符串。以下是有关通过SQL Server Management Studio，SQL Server Integration Services和SQL Server Reporting Services连接到Oracle的文章。



https://www.techwalla.com/articles /如何连接到oracle-with-sql-management-studio



使用Sql Server Integration Services连接到Oracle数据库 - 堆栈溢出 [ ^ ]



Oracle连接类型（s-s-rS）| Microsoft Docs [ ^ ]



连接Oracle数据库（OracleToSQL） Microsoft Docs [ ^ ]

Visual Studio Marketplace有一个Visual Studio加载项，它看起来就像你需要的那样： br />
用于Visual Studio 2017的Oracle开发人员工具 - Visual Studio Marketplace [ ^ ]



来自Oracle网站：

适用于Visual Studio的Oracle开发人员工具 [ ^ ]

Using the SSDT tool we can connect to mssql database and create a database project in visual studioand deploy it using the .dacpac file that we get from building the application. Can the same be done for Oracle databases instead of mssql database?

What I have tried:

I have to implimented this only for mssql databases but can't find a way to implement it for Oracle databases

You need the Oracle driver and a connection string that uses the driver. Below are articles about connecting to Oracle through SQL Server Management Studio, SQL Server Integration Services and SQL Server Reporting Services.

https://www.techwalla.com/articles/how-to-connect-to-oracle-with-sql-management-studio

Connecting to Oracle Database using Sql Server Integration Services - Stack Overflow[^]

Oracle Connection Type (s-s-rS) | Microsoft Docs[^]

Connecting to Oracle Database (OracleToSQL) | Microsoft Docs[^]

The Visual Studio Marketplace has an add-in for Visual Studio that looks to be what you need:
Oracle Developer Tools for Visual Studio 2017 - Visual Studio Marketplace[^]

And from the Oracle site:
Oracle Developer Tools for Visual Studio[^]