Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql server compact vs sql server express

Posted on 2007-11-27
4
Medium Priority
?
1,389 Views
Last Modified: 2012-08-14
I currently have a program that uses SQL Server Express.  Other than the pain it causes when my users have to install SQL Server Express, it works fine.  

I noticed that SQL Server Compact only requires about 6 or so dll's that can be placed in my installation package.

So, my questions are:  

  -  are there any reasons I should stick with Express?
  -  can the converstion from Express to Compact be done programmatically to make it painless?
  -  does Compact support networking?
  -  where can I find out more about Compact?

Thanks in advance...
0
Comment
Question by:rmmarsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 2000 total points
ID: 20362243
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20362249
0
 

Author Comment

by:rmmarsh
ID: 20362314
Interesting... OK... my next question is:  can I use the same database, only change the engine?  In other words, just include the aforementioned dll's and leave everything else the same? (with the exception of the connection details).  I really don't want to irritate my users anymore than I have to! :D

0
 

Author Comment

by:rmmarsh
ID: 20362392
Never mind... ignore the last question... it looks like I have to write my own conversion program...

Thanks for the info, tho'
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question