Hi All,

Can some one please help me on this:

1) What is the current version of SQL Server Express?

2) HOw much SQL Server Express costs (figure about 500 branch servers)

3)Are there any Tools from Microsoft to convert Access 97 directly to SQL Server express, and how much do they cost?

4)Server Hardware requirements to run SQL Server Express - disk size, memory size, security settings, pre-requisite, service needed.

5)Maximum capacity / capabilities of SQL Server Express-max # of simultaneous users,tables,rows,database size.

6)Any installation instruction for SQL Server Express.

Thanks in Advance, Pls help

Thanks

Tony



• Edited by Antonsagay Friday, February 27, 2015 7:20 PM

Hi Tony,

SQL Server 2014 Express is the current version.  More that you ever wanted to know about it can be found here: http://www.microsoft.com/en-us/server-cloud/Products/sql-server-editions/sql-server-express.aspx

Bruce

Hi Tony,

Besides Bruces post, firstly, SQL Server Express is a free SQL Server edition,  you can download SQL Server 2014 Express directly from this link and install it on your computer. For how to install SQL Server 2014 Express, please follow the steps in this similar blog.

Secondly, for more information about hardware and software requirements for Installing SQL Server 2014 Express, please review this article: https://msdn.microsoft.com/en-us/library/ms143506.aspx .

Thirdly, SQL Server Express has the following limitations:

1 physical processor

1 GB of RAM

4 GB database size per database in SQL Server 2005 Express and SQL Server 2008 Express , 10 GB database size per database in SQL Server 2008 R2 Express and higher versions of SQL Server Express.

However, there is no limit to the numbers of databases in SQL Server Express. And there is no technical limit to the number of connection that SQL Express can handle.

In addition, there are several methods to convert an Access database to SQL Server, such as using SQL Server Import and Export Wizard and SQL Server Migration Assistant for Access, they are both free tools. For more information about convert an Access database to SQL Server, please review this KB article.


Thanks,
Lydia

Yes, they are both free tools, and neither one of them work...