What are the difference of Microsoft 2003 to Microsoft 2008?

Answer 1

There are books and classes that describe the version differences. In a database, there would be too many to mention here. It would probably be a 200 page book. SQL Server 2005 has come up with new BI reporting tools, which is also called as 'Yukon'. This was the only significant reason to bring in the new version of SQL Server 2005 apart from the basic elements of SQL Server 2000.

Feature

Security:Owner = Schema, hard to remove old users at times Encryption:No options built in, expensive third party options with proprietary skills required to implement properly.

High Availability Clustering or Log Shipping require Enterprise Edition. Expensive hardware.

Scalability:Limited to 2GB, 4CPUs in Standard Edition. Limited 64-bit support. Security Schema is separate. Better granularity in easily controlling security. Logins can be authenticated by certificates.

Encryption Encryption and key management build in.

High Availability Clustering, Database Mirroring or Log Shipping available in Standard Edition. Database Mirroring can use cheap hardware.

Scalability 4 CPU, no RAM limit in Standard Edition. More 64-bit options offer chances for consolidation. http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

Answer 2

SQL Server 2005 has come up with new BI reporting tools, which is also called as 'Yukon'. This was the only significant reason to bring in the new version of SQL Server 2005 apart from the basic elements of SQL Server 2000. There are actually MANY advancements in performance, functionality, and reliability in SQL 2005. As one example XML is now a data type in SQL 2005 and as a native data type is handled efficiently by the internal SQL engine. There are additional improvements in SQL 2005 such as data isolation levels, snapshot data, better reporting, better scale, much improved server clustering. The list really goes on. Hope this helps jwilliamsoh
http://jwilliamsoh.spaces.live.com/

Answer 3

In sql server 2005,There is no option to compress backup files, but in sql server 2008,there you find it.

storing backup file takes 5 minutes without compression in sqlserver 2005,but it takes only 3 minutes in sql server 2008 for storing backup files with compression.

CPU is used to compress the data before it is written to disk,so less data is written to disk.

There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.

Server 2008 also added CMS which is Central Management Server. It only works with Windows Authentication but it allows you to management multiple SQL Servers at once. If SQL Server systems are popping up like weeds it will appear in the CMS provided that they point to the CMS via SSMS. Its a really cool feature.

PBM Policy-Based Management is another added feature introduced with SQL Server 2008. PBM allows you to define and enforce policies for configuring and managing SQL Server across your enterprise. It goes hand-in-hand with CMS.

One of my favorite is that fact that Reporting Services no longer requires IIS as it makes direct calls to HTTP.SYS.

As Rajiv mentioned there are many improvements to performance, data handling, security, administration, etc...

there is not much difference... just higher version but still companies develop projects in 2005 only

SQL2008 has support for additional datatypes:

date

time

geospatial

timestamp with internal timezone

in additon it has geospatial functions so it can compute differences based on GPS co-ordinates

when we write select * from --- it ask to for table name (2008)

but 2005 does not ask.

navin kumar 9590097686

Answer 4

The main difference between 2003 and 2008 is Visualization, management.

In Windows Server 2008, Microsoft is introducing new features and technologies, some of which were not available in Windows Server 2003 with Service Pack 1 (SP1), that will help to reduce the power consumption of server and client operating systems, minimize environmental byproducts and increase server efficiency.

Microsoft Windows Server 2008 has been designed with energy efficiency in mind, to provide customers with ready and convenient access to a number of new power saving features. It includes updated support for Advanced Configuration and Power Interface (ACPI) processor power management (PPM) features, including support for processor performance states (P-states) and processor idle sleep states on multiprocessor systems. These features simplify power management in Windows Server 2008 (WS08) and can be managed easily across servers and clients using Group Policies.

2008 has more in-build components and updated third party drivers.

Microsoft introduces new feature with 2k8 that is Hyper-V

Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine.

More information:

1.)

2008 is combination of vista and windows 2003r2. Some new services are introduced in it

1. RODC one new domain controller introduced in it

[Read-only Domain controllers.]

2. WDS (windows deployment services) instead of RIS in 2003 server

3. shadow copy for each and every folders

4.boot sequence is changed

5.installation is 32 bit where as 2003 it is 16 as well as 32 bit, that's why installation of 2008 is faster

6.services are known as role in it

7. Group policy editor is a separate option in ads

2)

The main difference between 2003 and 2008 is Virtualization, management.

2008 has more inbuilt components and updated third party drivers Microsoft introduces new feature with 2k8 that is Hyper-V Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine. If you like this exciting technology, make sure that you buy an edition of Windows Server 2008 that includes Hyper-V, then launch the Server Manger, add Roles.

3)

In Windows Server 2008, Microsoft is introducing new features and technologies, some of which were not available in Windows Server 2003 with Service Pack 1 (SP1), that will help to reduce the power consumption of server and client operating systems, minimize environmental byproducts, and increase server efficiency.

Microsoft Windows Server 2008 has been designed with energy efficiency in mind, to provide customers with ready and convenient access to a number of new power-saving features. It includes updated support for Advanced Configuration and Power Interface (ACPI) processor power management (PPM) features, including support for processor performance states (P-states) and processor idle sleep states on multiprocessor systems. These features simplify power management in Windows Server 2008 (WS08) and can be managed easily across servers and clients using Group Policies.

4.

1)2008 is combination of vista and windows 2003r2. Some new services are introduced in it

1. RODC one new domain controller introduced in it

[Read-only Domain controllers.]

2. WDS (windows deployment services) instead of RIS in 2003 server

3. shadow copy for each and every folders

4.boot sequence is changed

5.installation is 32 bit where as 2003 it is 16 as well as 32 bit, that's why installation of 2008 is faster

6.services are known as role in it

7. Group policy editor is a separate option in ads

2) The main difference between 2003 and 2008 is Virtualization, management.

2008 has more inbuilt components and updated third party drivers Microsoft introduces new feature with 2k8 that is Hyper-V Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine. If you like this exciting technology, make sure that you buy an edition of Windows Server 2008 that includes Hyper-V, then launch the Server Manger, add Roles.

3) In Windows Server 2008, Microsoft is introducing new features and technologies, some of which were not available in Windows Server 2003 with Service Pack 1 (SP1), that will help to reduce the power consumption of server and client operating systems, minimize environmental byproducts, and increase server efficiency.

Microsoft Windows Server 2008 has been designed with energy efficiency in mind, to provide customers with ready and convenient access to a number of new power-saving features. It includes updated support for Advanced Configuration and Power Interface (ACPI) processor power management (PPM) features, including support for processor performance states (P-states) and processor idle sleep states on multiprocessor systems. These features simplify power management in Windows Server 2008 (WS08) and can be managed easily across servers and clients using Group Policies.

Many features are updated - as security, IIS and RODC.

In security it enable outbound firewall as well as inbound, IIS 7 release, Read only Domain controllers.

1. Virtualization

2. Server Core provides the minimum installation required to carry out a specific server role, such as for a DHCP, DNS or print server.

3. Boot sequence is changed

4. Role-based installation or, services are known as role in it

5. Read Only Domain Controllers (RODC)

6. WDS (windows deployment services) instead of RIS in 2003 server

7. Network Access Protection Microsoft's system for ensuring that clients connecting to Server 2008 are patched, running a firewall and in compliance with corporate security policies.

8. Power Shell Microsoft's new(ish) command line shell and scripting language has proved popular with some server administrators.

9. IIS

10. Bitlocker System drive encryption can be a sensible security measure for servers located in remote branch offices.

5.

The main difference between 2003 and 2008 is Virtualization, management.

2008 has more inbuilt components and updated third party drivers.

Microsoft introduces new feature with 2k8 that is Hyper-V

Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine. If you like this exciting technology, make sure that you buy an edition of Windows Server 2008 that includes Hyper-V, then launch the Server Manger, add Roles.

Windows Server 2008, formerly codenamed Longhorn, is no leas than 45 times faster than its predecessor, Windows Server 2003, in terms of network transfer speeds. Now whatever the perspective is on Microsoft's last 32-bit server operating system, the fact of the matter is that faster transfer speeds for of up to 45 times is quite an evolution compared to Windows Server 2003. Back in June 2007, Microsoft commissioned a study to the Tally Group focused on the networking performances of its latest Windows client and server operating system, which ended up as the "Enhanced Network Performance with Microsoft Windows Vista and Windows Server 2008" white paper. The paper pointed to the fact that both Vista and Windows Server 2008 managed to offer "Dramatic network performance benefits".

Answer 5

1. Terminal service are enhanced in win2k3

2. Windows 2k doesn't have 64 bit version

3. DNS Stub zone has introduced.

4. Shadow copying has introduced.

5. Schema version has changed from ver.13 to ver.30.

6. When installing terminal services for win2000 you are prompted to select application server functions or administrative functions sets can be installed sequentially on one server but it performs only one function at one time. But in 2003 still distinguishes between application and administrative services but installation and management are now consolidated.

7. In Win 2000 server we can apply 620 group policies but in 2003 we can apply nearly 720 so Win2003 server is more secure than win 2000 server.

8. In 2000 we cannot rename domain whereas in 2003 we can rename Domain.

9. In 2000 it supports of 8 processors and 64 GB RAM (In 2000 Advance Server) whereas in 2003 supports up to 64 processors and max of 512GB RAM.

10. 2000 Supports IIS 5.0 and 2003 Supports IIS6.0

11. 2000 doesn't support Dot net whereas 2003 Supports Microsoft .NET 2.0

12. 2000 has Server and Advance Server editions whereas 2003 has Standard, Enterprise, Datacenter and Web server Editions.

13. 2000 doesn't have any 64 bit server operating system whereas 2003 has 64 bit server operating systems (Windows Server 2003 X64 Std and Enterprise Edition)

14. 2000 has basic concept of DFS (Distributed File systems) with defined roots whereas 2003 has Enhanced DFS support with multiple roots.

15. In 2000 there is complexality in administering Complex networks whereas 2003 is easy administration in all & Complex networks.

16. In 2000 we can create 1 million users and in 2003 we can create 1 billion users.

17. In 2003 we have concept of Volume shadow copy service which is used to create hard disk snap shot which is used in Disaster recovery and 2000 doesn't have this service.

18. In 2000 we don't have end user policy management, whereas in 2003 we have a End user policy management which is done in GPMC (Group policy management console).

19. In 2000 we have cross domain trust relation ship and 2003 we have Cross forest trust relationship.

20. 2000 Supports 4-node clustering and 2003 supports 8-node clustering.

21. 2003 has High HCL Support (Hardware Compatibility List) issued by Microsoft.

22. Code name of 2000 is Win NT 5.0 and Code name of 2003 is Win NT 5.1

23. 2003 has service called ADFS (Active Directory Federation Services) which is used to communicate between branches with safe authentication.

24. In 2003 their is improved storage management using service File Server Resource Manager (FSRM).

25. 2003 has service called Windows Share point Services (It is an integrated portfolio of collaboration and communication services designed to connect people, information, processes, and systems both within and beyond the organizational firewall).

26. 2003 has Improved Print management compared to 2000 server.

27. 2003 has telnet sessions available.

28. 2000 supports IPV4 whereas 2003 supports IPV4 and IPV6.

29. In windows 2003 server, AD partion is 5 where as in 2k that

30. is 3.The added partion is: 1) Global catelog 2) Application partion.

31. In 2k the Domain operation Roles and only two mode of

32. operation and in Win2k3 there are 4 modes of Domain

33. operation [Native mode, Mixed mode , Itrative mode and

34. windows 2003 mode .

35. In Win 2000 server we can apply 620 group policies but in 2003 we can apply nearly 720 so Win2003 server is more secure than win 2000 server.

36. In 2000 we cannot rename domain whereas in 2003 we

37. can rename Domain.

38. 2000 server and advanced 2000 server only available whereas in 2003 server there are four version are available.

between 2003 and 2008

1)2008 is combination of vista and windows 2003r2. Some new services are introduced in it

1. RODC one new domain controller introduced in it

[Read-only Domain controllers.]

2. WDS (windows deployment services) instead of RIS in 2003 server

3. shadow copy for each and every folders

4.boot sequence is changed

5.installation is 32 bit where as 2003 it is 16 as well as 32 bit, that's why installation of 2008 is faster

6.services are known as role in it

7. Group policy editor is a separate option in ads

2) The main difference between 2003 and 2008 is Virtualization, management.

2008 has more inbuilt components and updated third party drivers Microsoft introduces new feature with 2k8 that is Hyper-V Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine. If you like this exciting technology, make sure that you buy an edition of Windows Server 2008 that includes Hyper-V, then launch the Server Manger, add Roles.

3) In Windows Server 2008, Microsoft is introducing new features and technologies, some of which were not available in Windows Server 2003 with Service Pack 1 (SP1), that will help to reduce the power consumption of server and client operating systems, minimize environmental byproducts, and increase server efficiency.

Microsoft Windows Server 2008 has been designed with energy efficiency in mind, to provide customers with ready and convenient access to a number of new power-saving features. It includes updated support for Advanced Configuration and Power Interface (ACPI) processor power management (PPM) features, including support for processor performance states (P-states) and processor idle sleep states on multiprocessor systems. These features simplify power management in Windows Server 2008 (WS08) and can be managed easily across servers and clients using Group Policies.

Many features are updated - as security, IIS and RODC.

In security it enable outbound firewall as well as inbound, IIS 7 release, Read only Domain controllers.

1. Virtualization

2. Server Core provides the minimum installation required to carry out a specific server role, such as for a DHCP, DNS or print server.

3. Boot sequence is changed

4. Role-based installation or, services are known as role in it

5. Read Only Domain Controllers (RODC)

6. WDS (windows deployment services) instead of RIS in 2003 server

7. Network Access Protection Microsoft's system for ensuring that clients connecting to Server 2008 are patched, running a firewall and in compliance with corporate security policies.

8. Power Shell Microsoft's new(ish) command line shell and scripting language has proved popular with some server administrators.

9. IIS

10. Bitlocker System drive encryption can be a sensible security measure for servers located in remote branch offices.

The main difference between 2003 and 2008 is Virtualization, management.

2008 has more inbuilt components and updated third party drivers.

Microsoft introduces new feature with 2k8 that is Hyper-V

Windows Server 2008 introduces Hyper-V (V for Virtualization) but only on 64bit versions. More and more companies are seeing this as a way of reducing hardware costs by running several 'virtual' servers on one physical machine. If you like this exciting technology, make sure that you buy an edition of Windows Server 2008 that includes Hyper-V, then launch the Server Manger, add Roles.

Windows Server 2008, formerly codenamed Longhorn, is no leas than 45 times faster than its predecessor, Windows Server 2003, in terms of network transfer speeds. Now whatever the perspective is on Microsoft's last 32-bit server operating system, the fact of the matter is that faster transfer speeds for of up to 45 times is quite an evolution compared to Windows Server 2003. Back in June 2007, Microsoft commissioned a study to the Tally Group focused on the networking performances of its latest Windows client and server operating system, which ended up as the "Enhanced Network Performance with Microsoft Windows Vista and Windows Server 2008" whitepaper. The paper pointed to the fact that both Vista and Windows Server 2008 managed to offer "Dramatic network performance benefits".

Windows server 2008 has been more updated than windows server 2003.

Answer 6

The question makes absolutely no sense. Microsoft WHAT?

Server, Office, Visual Studio, Exchange, what?? Microsoft makes more than one product.