Server Sql: compatto e locale Denali

2

Qualcuno conosce le differenze tra queste?

  1. link (Cerca CTP3 LocalDB nella pagina)
  2. link

Mi chiedo perché microsoft abbia avviato il progetto Denali (ora in CTP).

    
posta onof 13.07.2011 - 16:24
fonte

2 risposte

5

Ho ricevuto la mia risposta qui :

LocalDB and SQL Server Compact?

Small and simple database, lightweight installation, connecting to a database file -- this will sound familiar to any developer using SQL Server Compact. The similarities are not accidental, as our goal for LocalDB was to be as easy to use as SQL Server Compact (while being as powerful and compatible with full SQL Server as SQL Express).

There are significant differences between LocalDB and SQL Server Compact:

Execution mode: SQL Server Compact is an in-proc DLL, while LocalDB runs as a separate process.

Disk usage: all SQL Server Compact binaries amount to some 4MBs, while LocalDB installation takes 140MBs.

Features: SQL Server Compact offers core RDBMS functionality like querying, while LocalDB provides a much richer set of features, including Stored Procedures, Geometry and Geography data types, etc.

    
risposta data 13.07.2011 - 17:02
fonte
1

Un confronto tra le diverse funzionalità di CE3.5, CE4, 2008 R2 Express e LocalDB (Denali CTP3) può essere trovato qui

link

(sì un link - perché è ancora un CTP)

    
risposta data 27.07.2011 - 08:08
fonte

Leggi altre domande sui tag