Microsoft SQL Server 2008 Express is a scaled down, free edition of SQL Server.
SQL Server Express makes it easy to develop applications that need database management capabilities.
SQL Server 2008 Express comes in 3 editions:
- SQL Server 2008 Express – just the basic database engine
- SQL Server 2008 Express with Tools – includes Management Studio
- SQL Server 2008 Express with Advanced Services
The Advanced Services edition is full-featured and includes Full Text Search, Reporting Services and Report Designer. It also has an Import and Export Wizard, making it easy to transfer data from a Microsoft Access database to an SQL Server 2008 Express database.
There are no limitations on the number of databases or users. SQL Server 2008 Express is however limited to one processor, 1 GB memory (the excess will not be used) and 10 GB database files. More than enough for any Microsoft Access upgrade.
Note that SQL Server 2008 Express can only work with other 2008 versions.
SQL Server Express is ideal for the small company and the Microsoft Visual Basic developer. The SQL Server Express database can be used for a Website or as a Back-End to an Access application.
If data volume or traffic increases, the live system can be readily migrated to the full version of SQL Server.
more info: http://www.nevvb.com.au/SQL-Server-Migration.aspx