What is the main tool to administer the database?
SQL Server -The main tool is SQL Server Management Studio.
Oracle -For Oracle by default Oracle SQL Developer is usually installed.
What tool is used to create reports?
SQL Server -SQL Server Reporting Services (SSRS) is primarily used for reporting. These tools are usually combined with SharePoint, but it can also be stand-alone.
Oracle -You can also use Power View, PowerPivot, etc..
What tools are used for replication?
SQL Server -You can use SQL Server Management Studio and go to the replication node to implement SQL Server Replication. You can also use T-SQL scripts. Another option is Microsoft Sync Framework.
Oracle -In Oracle 12c you can use the advanced Replication Interface in Oracle Enterprise Manager Cloud Control. The replication management API is a set of PL-SQL packages. This is used to replicate data using the command line.
What tools are used to create programs to connect to the database?
SQL Server -You can program with several platforms, but Visual Studio is the main Microsoft development environment used to program in C#, C++, J#, F#, VB.net, etc.
Oracle -You can use several Platforms, but the main Oracle tool is Java.
What platform is used to work in the cloud?
SQL Server- There are several tools to work in the Cloud, but the platform used by Microsoft is Microsoft Azure.
Oracle- There are several tools to work in the cloud, but the platform used by Oracle is the Oracle Cloud.
Does the database accept multidimensional databases (OLAP)?
SQL Server - SQL Server Analysis Services (SSAS) accepts multidimensional databases. You can use SSMS or the SQL Server Data Tools to create them. Also, you can do it programmatically using AMO (Analysis Services Management Objects) using your favorite programming language.
Oracle -You can use Essbase to create multidimensional databases.
Is there a way to do database mirroring?
SQL Server - You can use SSMS or T-SQL to use the Database Mirroring technology.
Oracle -You can use Storage Remote Mirroring and Active Data Guard.
Is there a way to do log shipping?
SQL Server -You can do Log Shipping using SSMS or T-SQL scripts.
Oracle -You can do log shipping, but it is recommended to use other High Availability solutions like Data Guard.
SQL Server -The main tool is SQL Server Management Studio.
Oracle -For Oracle by default Oracle SQL Developer is usually installed.
What tool is used to create reports?
SQL Server -SQL Server Reporting Services (SSRS) is primarily used for reporting. These tools are usually combined with SharePoint, but it can also be stand-alone.
Oracle -You can also use Power View, PowerPivot, etc..
What tools are used for replication?
SQL Server -You can use SQL Server Management Studio and go to the replication node to implement SQL Server Replication. You can also use T-SQL scripts. Another option is Microsoft Sync Framework.
Oracle -In Oracle 12c you can use the advanced Replication Interface in Oracle Enterprise Manager Cloud Control. The replication management API is a set of PL-SQL packages. This is used to replicate data using the command line.
What tools are used to create programs to connect to the database?
SQL Server -You can program with several platforms, but Visual Studio is the main Microsoft development environment used to program in C#, C++, J#, F#, VB.net, etc.
Oracle -You can use several Platforms, but the main Oracle tool is Java.
What platform is used to work in the cloud?
SQL Server- There are several tools to work in the Cloud, but the platform used by Microsoft is Microsoft Azure.
Oracle- There are several tools to work in the cloud, but the platform used by Oracle is the Oracle Cloud.
Does the database accept multidimensional databases (OLAP)?
SQL Server - SQL Server Analysis Services (SSAS) accepts multidimensional databases. You can use SSMS or the SQL Server Data Tools to create them. Also, you can do it programmatically using AMO (Analysis Services Management Objects) using your favorite programming language.
Oracle -You can use Essbase to create multidimensional databases.
Is there a way to do database mirroring?
SQL Server - You can use SSMS or T-SQL to use the Database Mirroring technology.
Oracle -You can use Storage Remote Mirroring and Active Data Guard.
Is there a way to do log shipping?
SQL Server -You can do Log Shipping using SSMS or T-SQL scripts.
Oracle -You can do log shipping, but it is recommended to use other High Availability solutions like Data Guard.