|Sr No||SQL Server 2005||SQL Server 2008|
|1||XML datatype is introduced.||XML datatype is used.|
|2||Can not encrypt the entire database.||Can encrypt the entire database
introduced in 2008.
|3||Datetime is used for both date and time.||Date and time are separately used for
date and time
|4||No table datatype is included.||Table datatype introduced.|
|5||SSIS is started using.||SSIS avails in this version.|
|6||CMS is not available.||
CMS is Introduced.
|7||PBM is not available||
PBM server is Introduced.
SSIS-SQL Server Integration Services(SSIS) is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.
CMS–A Content Management System (CMS) is a computer program that allows publishing, editing and modifying content as well as maintenance from a central interface. Such systems of content management provide procedures to manage workflow in a collaborative environment.
PBM–SQL server 2008 has introduced Policy Based Management(PBM) Framework, which is the latest technique for SQL server database engine. SQL policy administrator uses SQL Server Management Studio to create policies that can handle entities on the server side like the SQL Server objects and the instance of SQL Server databases.