I need peoples opinions on my comparisons of SQL Server 05 and Oracle 11g.
All opinions are welcome, both positive and negative
Comparison of the two systems
Creating a database
When setting up a database in Oracle, it seems to have been created during the installation phase. SQL Server database creation is carried out after installation.
Creating a table
Both systems allow for table creation through the provided interface. This process is fairly seamless and user friendly in both cases.
Creating a primary key
The creation of a primary key in Oracle involved numerous steps whereas SQL Server allowed this action in one step (right click on field and select Primary Key)
Populating the tables with data
Table data population in Oracle through the SQL Plus command line prompt interface proved to be very involved and cumbersome. The entire SQL code and syntax had to be entered manually to insert any particular record entry. SQL Server 2005, on the other hand, presents an easy to use interface for data entry.
Connecting to a remote server
No problems encountered in SQL Server 2005. It was another case of a couple of mouse clicks to achieve the task of remote connectivity. We were unable to make a remote connection in Oracle due to a network error. However, the process of remote connectivity was again a laborious task in a separate application with multiple screens in which to provide additional information.
Accessing a database on a remote server
Very easy in SQL Server. The remote server is listed on the left hand pane and appears as if it were a local server with the same easy to use interface interaction.
