| Sr No | SQL Server 2005 | SQL Server 2008 |
| 1 | ||
| 2 | in 2008. | |
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 |
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.
