SQL Server Express 2005 vs SQL Server Express 2008 | SQL Server Express 2005 vs 2008
SQL Server yog tus qauv kev sib raug zoo database server tsim los ntawm Microsoft. Thiab SQL Server Express yog qhov ntsuas qis ntawm SQL Server uas yog dawb. SQL Server Express 2008 (uas yog qhov ntsuas qis ntawm SQL Server 2008 R2) ua raws li SQL Server Express 2005 (qhov ntsuas qis qis ntawm SQL Server 2005). SQL Server Express muaj qee qhov kev txwv piv rau cov ntawv tag nrho. Ib qho kev txwv tseem ceeb tshaj plaws yog qhov tsis muaj peev xwm ntawm Kev Tshawb Fawb, Kev Sib Koom Tes thiab Kev Ceeb Toom. Tab sis tag nrho txhua yam, Cov Ntawv Tshaj Tawm yog qhov zoo rau kev kawm vim tias nws tuaj yeem siv dawb los tsim cov duab me me thiab lub vev xaib.
SQL Server Express 2005
SQL Server Express 2005 yog qhov ntsuas qis qis ntawm SQL Server 2005, uas yog rub tawm dawb. Tab sis nws muaj kev txwv piv rau SQL Server 2005. Thaum nws los txog rau scalability thiab kev ua tau zoo, tus naj npawb ntawm kev txhawb nqa lub cev CPUs tsuas yog 1. Nws yuav tsum muaj tsawg kawg yog 1 GB RAM. 64-ntsis yog txaus siab tab sis tsuas yog raws li WOW (Windows ntawm Windows). Qhov kev txwv ntawm database loj yog 4 GB. Thaum nws los txog rau kev tswj hwm kev tswj hwm, cov ntaub ntawv khaws cia tau hloov kho kom zoo tshaj plaws. Nws suav nrog ib qho profiler. SQL Server Express 2005 muaj tag nrho cov kev ruaj ntseg nta muaj nyob rau hauv SQL Server 2005 nrog rau kev soj ntsuam siab heev, authentication, kev tso cai, built-in cov ntaub ntawv encryption thiab Microsoft lub hauv paus kev ruaj ntseg analyzer kev koom ua ke. SQL Server Express 2005 tuaj yeem sib pauv lus nrog lwm cov ntawv, txawm li cas los xij cov lus ntawm ob qhov xwm txheej yuav tsum raug xa mus rau lwm tsab. Express 2005 muaj kev sib koom ua ke thiab kev sib pauv hloov pauv.
SQL Server Express 2008
SQL Server Express 2008 yog qhov ntsuas qis qis ntawm SQL Server 2008 R2. Yog li, nws muaj kev txwv piv rau SQL Server 2008 R2. SQL Server Express 2008 yog dawb downloadable. SQL Server Express 2008 txhawb nqa ib lub cev CPU thiab xav tau 1 GB Memory. Nws muaj cov ntaub ntawv loj ntawm 10 GB, thiab txhawb nqa tag nrho ob qho tib si x32 thiab x64 kho vajtse. SQL Server Express 2008 muaj SQL Server hloov kev taug qab. Tsis tas li ntawd, nws muaj Merge, Transactional thiab Snapshot replication. Hais txog kev ruaj ntseg ntawm kev lag luam, nws txhawb C2 raws kev taug qab. Cov cuab yeej tswj hwm kev lag luam xws li kev txhawb nqa Hypervisor, cov cuab yeej hloov chaw hauv cov ntaub ntawv, kev tswj hwm txoj cai thiab SQL server tswj cov cuab yeej tau muab.
Qhov txawv ntawm SQL Server Express 2005 thiab SQL Server Express 2008 yog dab tsi?
SQL Server Express 2008 yog Express Edition, uas ua raws SQL Server Express 2005. Yog li ntawd, SQL Server Express 2008 muaj ntau yam nta tshaj SQL Server Express 2005.
– SQL Server Express 2008 muaj kev txhim kho loj dua SQL Server Express 2005 hais txog cov ntaub ntawv loj.
– Tsis zoo li Express 2005, Express 2008 muaj Snapshot replication.
– Database mirroring tsis muaj nrog Express 2005, tab sis Express 2008 tuaj yeem siv los ua tus neeg ua pov thawj rau database mirroring.
– Cov ntawv nyeem puv, uas tsis muaj nyob rau hauv 2005, muaj nyob rau hauv Express 2008 (nrog cov kev pabcuam siab heev rub tawm).
– Kev tshaj tawm tsis muaj nyob rau xyoo 2005, thaum lub sijhawm txwv / ib feem ntawm Kev Tshaj Tawm tau muab ntxiv rau xyoo 2008.
