Scribd
Upload
17 views

Difference Between DB2 and SQL Server

Uploaded by

ajaymehta
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
17 views

Difference Between DB2 and SQL Server

Uploaded by

ajaymehta
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Difference between DB2 and SQL Server

DB2 vs SQL Server

Database systems are very important especially when dealing with great amounts of data that are very
important. To handle these data, you would need to implement a Relational Database Management
System or RDBMS. Two of the RDBMS in existence today are DB2 developed by IBM and SQL server
which comes from Microsoft.

The term DB2 usually refers to the Enterprise Server Edition that can run on UNIX, Windows, and Linux
servers although there are many more versions of DB2, some are even run on handheld devices. The
DB2 Enterprise Server Edition is meant for high end mainframes and may have some difficulty working
on lower end computer for smaller database needs. The SQL server doesn’t have this problem and
could easily scale from low end laptops to high end mainframes.

SQL server also comes in many editions but for comparison we would deal with the Enterprise Edition.
SQL server Enterprise Edition comes complete with all the features needed to run and maintain your
own database and even has tools that would be bought if using DB2, like the Word Indexer and Server
Clear. The SQL server even provides the developer with multiple GUI tools that makes it easier for him to
create databases and relations across different tables. Even drag and drop capabilities are already
programmed into these tools. The DB2 also has a GUI tool but it is fairly limited when compared to that
of SQL and most advanced users still prefer to use the command line in processing and maintaining data.

Another advantage that SQL has over DB2 is in the .Net Framework that Microsoft also developed.
Visual Studio, which is the programming suite in the .Net Framework, supports native data programming
for SQL server. This allows Visual Studio programmers to easily create and debug their own programs
that can then be executed in the SQL server. This greatly reduces the steep learning curve that is often
involved when dealing with another language that processes huge amounts of data.

Summary:

1. SQL server can run on almost any computer even a laptop which the DB2 Enterprise Edition Server
cannot

2. SQL server can drag and drop tables and DB2 cannot

3. SQL server has a built-in Word Indexer, you need to have your own for DB2

4. SQL server has a built-in Server Clear, you also need to have your own for DB2

5. SQL server has the support of Microsoft’s .Net Framework allowing coders familiar with the .Net
languages to easily pick up the needed learning.

Read more: Difference Between DB2 and SQL Server | Difference Between | DB2 vs SQL Server
http://www.differencebetween.net/technology/difference-between-db2-and-sql-
server/#ixzz1JG8UbKTV

You might also like