Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mikebyrne
Starting Member
13 Posts |
 Posted - 2008-10-15 : 09:59:31
|
| I need peoples opinions on my comparisons of SQL Server 05 and Oracle 11g.All opinions are welcome, both positive and negativeComparison of the two systemsCreating a databaseWhen 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 tableBoth systems allow for table creation through the provided interface. This process is fairly seamless and user friendly in both cases.Creating a primary keyThe 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 dataTable 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 serverNo 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 serverVery 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. |
|
|
|
|
|
Comparing SQL Server 2005 to Oracle 11g