Hi
Just downloaded the SQL Everywhere CTP and installed it. I don't get it at this point It is supposed to be a desktop database right I realize it is based off of the SQL Mobile edition but are you going to have to use a different namespace System.Data.SQLServerCE to access SQL Everywhere. And will SQL Server Management Studio be able to access to at least create tables, etc. Please tell me that I can access SQL Everywhere through System.Data.SqlClient
What is SQL Everywhere?
Green Bird
SQL Server Everywhere is the next version of SQL Server Mobile. SQL Server Mobile can only be used on Desktop if SQL Server 2005 or Visual Studio 2005 is also installed. SQL Server Mobile is also restricted for production use on Desktop by licensing restrictions. The new version of SQL Server Mobile, SQL Server Everywhere can be deployed on Desktops. The SQL Server Everywhere CTP that you have downloaded can be used to install SQL Server Everywhere on Desktops and Tablet PC.
Clarifications about the other points are given below:
1) The namespace - System.Data.SqlServerCe - is the same namespace as used for SQL Server Mobile. To access SQL Server Everywhere from Managed Applications System.Data.SqlServerCe namespace is used.
2) SQL Server Management Studio can be used for creating SQL Server Everywhere databases. The database file format of SQL Server Mobile and SQL Server Everywhere is same (*.sdf).
3) The System.Data.SqlClient namespace is used for accessing SQL Server. For SQL Server Everywhere the namespace is System.Data.SqlServerCe. For more info about the System.Data.Client use the following link - http://msdn2.microsoft.com/en-us/8t72t3k4(vs.80).aspx
Other useful resources about SQL Server Everywhere are:
Pre-release version of the help file - http://www.microsoft.com/downloads/details.aspx FamilyID=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en
Blogs –
http://blogs.msdn.com/sqlmobile/
Thanks
Ambrish