Databases
StackOverflow2013
Postsdbo
POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
    primarykey
    data
    text
    <p>The application I want to build using MS Visual C# Express (I'm willing to upgrade to Standard if that becomes required) that needs a database.</p> <p>I was all psyched about the SQL Server Compact - because I don't want the folks who would be installing my application on their computers to have to install the whole of SQL Server or something like that. I want this to be as easy as possible for the end user to install.</p> <p>So I was all psyched until it seems that there are limitations to what I can do with the columns in my tables. I created a new database, created a table and when I went to create columns it seems that there isn't a "text" datatype - just something called "ntext" that seems to be limited to 255 characters. "int" seems to be limited to 4 (I wanted 11). And there doesn't seem to be an "auto_increment" feature.</p> <p>Are these the real limitations I would have to live with? (Or is it because I'm using "Express" and not "Standard"). If these are the real limitations, what are my other database options that meet my requirements? (easy installation for user being the biggie - I'm assuming that my end user is just an average user of computers and if it's complicated would get frustrated with my application)</p> <p>-Adeena</p> <p>PS: I also want my database data to be encrypted to the end user. I don't want them to be able to access the database tables directly.</p> <p>PPS. I did read: <a href="http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx" rel="noreferrer">http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx</a> and didn't see a discussion on these particular limitations</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USadeena
    1. USadeena
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
      1. USwnka
      1. VTFavorite
    3. VO
      singulars
      1. POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODid you see the part of my post where I mentioned that nText supports 500 million characters: not 255 ?
      singulars
      1. POWhat are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)
      1. USJoel Coehoorn
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload