Difference in WSS and Microsoft Office sharePoint Server (MOSS) 2007 and sharepoint 2010

Windows SharePoint Services (WSS 3.0)

Windows SharePoint Services (3.0) are free available with Windows Server 2003. Microsoft Office SharePoint Server (MOSS) 2007 is licensed version. WSS 3.0 can be freely downloaded from Microsoft site.

MOSS 2007

MOSS 2007 is based on WSS3.0 with some additional features like Enterprise Search, enterprise content management, Business Data Catalog (BDC), User Profile, Excel Services, Single-Sign on, additional Workflows, My site feature , Office 2007 Integration
etc.

Sharepoint 2010

·         Linq in SharePoint 2010

·         Export Visio in workflow.

·         SharePoint Designer

·         BDC(Business data catalog) in 2007 – BCS in 2010->(To connect to external data in sql server)

·         BDC (Business Data Catalogue) is use to connect an external database and view it in share point. The BDC also allows connecting to data via Web Services
BCS (Business connectivity Services) is new in SharePoint2010. Using BDC one can only read from external Database, but using BCS one can read and write into the external Database

·         Shared service provider(SSP) – Service applications

·         Sandboxed solutions