Questions about SQL Server CE

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello.

I have some questions about SQL Server CE:

1. What is main goal of SQL Server CE?

2. Does SQL Server CE required some other SQL Server 2000 to be installed?

3. Is it as powerful as other SQL Servers such as SQL Server 2000 enterprise
edition?

4. I'm using MS Visual Studio .NET 2003, do I have to install SQL Server CE
or VS already includes it?

5. How can I install and run SQL Server CE?

6. It will not have conflict to other SQL Servers on my system?

7. Is there any newsgroup about SQL Server CE?
 
David said:
Hello.

I have some questions about SQL Server CE:

1. What is main goal of SQL Server CE?

To provide a robust and reasonably functional SQL database on Windows
CE.
2. Does SQL Server CE required some other SQL Server 2000 to be installed?
No.

3. Is it as powerful as other SQL Servers such as SQL Server 2000 enterprise
edition?

Would you expect it to be? No, it's not. Bear in mind that it needs to
be fairly small and run on significantly lower powered devices.
4. I'm using MS Visual Studio .NET 2003, do I have to install SQL Server CE
or VS already includes it?

It includes it.
5. How can I install and run SQL Server CE?

I *think* SQL Server CE is automatically installed when you deploy a
project which uses it (i.e. when you reference
System.Data.SqlServerCe.dll).
6. It will not have conflict to other SQL Servers on my system?

It won't be running on the same system as any other SQL server - it
runs on the Windows CE device, not on your desktop.
7. Is there any newsgroup about SQL Server CE?

microsoft.public.sqlserver.ce
 
Back
Top