Kuisa SQL Server 2012 Express Edition

01 ye 08

Sarudza SQL Server 2012 Express Edition Ichasangana Nezvaunoda

Microsoft SQL Server 2012 Express Edition yakasununguka, yakagadzirwa shanduro yebazi rinozivikanwa sebazi re database. The Express Edition ndiyo yakakosha kune vashandi vekuchengetedza mabhuku vachitsvaga mamiriro ekuongorora nzvimbo yepamusoro kana kune avo vanodzidza nezve databases kana SQL Server panguva yekutanga vanoda ruvara rwavanogona kuisa pane imwe kombiyuta kuti vaumbe nzvimbo yekudzidza.

Pane zvimwe zvingakwanisi ku SQL Server 2012 Express Edition iyo yaunofanira kuinzwisisa usati wasarudza kuisa iyo. Mushure mezvose, iyi ihurukuro yakasununguka yezvimwe zvingave zvine simba zvikuru (uye inodhura zvikuru! Izvi zvisingakwanisi zvinosanganisira:

• Mafashoni anogona kungoshandisa imwe CPU ine chinangwa chikuru chechina
• Zvigadziri zvinogona kungoshandisa 1GB RAM, pasinei nehuwandu hwemangariro yakaiswa
• Databases yakavakwa neChirangaridzo Inosvika kune 10GB muhukuru
• Kuratidzira hahupi kupa dhiabhorosi mirroring , log shipping , kana kubatanidza zvinyorwa zvinopiwa mune chikuru chigadzirwa
• SQL Server Express Edition haina kusanganisira Oracle replication functionality
• Zvishandiso zviripo neChirangaridzo Chekunyora hazvikwanisi - mugadziri haatauri Database Tuning Advisor, SQL Agent , kana SQL Profiler

Cherechedza: Iyi tutorial inosanganisira SQL Server 2012 Express Edition. Pamusangano we2014, ona Kuisa SQL Server 2014 Express Edition . Kana uri kutsvaga imwe nhepfenyuro yakasiyana-siyana iyo yose isingabhadhari uye inoshanda zvakakwana, iwe ungada kuisa MySQL pane .

02 of 08

Dhaunirodha SQL Server Express Installer

Zvadaro, iwe unoda kutora faira yakakodzera yefaki yeiyo shanduro yeSQL Server 2012 Express Edition inonyatsokodzera yako yehutachiona yehurongwa uye zvido zvako. Enda kune peji rekushandisa reMicrosoft uye sarudza kana uchida shanduro ye 32-bit kana 64-bit yeSQL Server (zvichienderana nehutano hwako) uye osarudza kana iwe uchida shanduro inosanganisira SQL Server mathuluzi. Kana iwe usati uine zvishandiso zvakasungirwa pamakombiyuta yako, tinokurudzira kuti uzviise mumudhadha wako.

03 of 08

Faira Kuwedzera

Iyo installer inotanga kuburikidza nekubvisa mafaira anodiwa pakugadzirisa hurongwa. Munguva iyi, izvo zvingatora maminitsi mashanu kusvika gumi, uchaona firati yehutatidzwa inoratidzwa pamusoro apa.

Iwindo rekuwedzera richapera uye hapana chichazoitika kwekanguva chekuita sechinyanya kureba! Mira nekushivirira. Pakupedzisira, unogona kuona mharidzo ichikubvunza kana SQL Server 2012 inogona kuchinja pane kombiyuta yako. Pindura hungu. Iwe uchazoona mharidzo yekuverenga "Ndapota Rindira Kunyange SQL Server 2012 Setup inobata maitiro ezvino". Ramba uri murwere kwemaminitsi mashoma.

04 of 08

SQL Server Express Installation Center

SQL Server installer ichazoendesa chinyorwa chinoratidzwa pamusoro, chinonzi "SQL Server Installation Center". Dzvanya "New Installation SQL Server kusimisa-yoga kana kuwedzera zvikamu kune imwe yero yekuisa" link kuti uenderere mberi kwekugadzirisa. Iwe uchazoonazve ruzhinji rwemapfupa uye "Ndapota Mirira Kunyange SQL Server 2012 Setup inoshandisa ikozvino basa" message.

SQL Server ichazobuda mahwindo emawindo ayo anosanganisira zvakasiyana-siyana zvekugadzirira preinstallation uye kuisa mamwe mafaira ekutsigira. Hapana pane mahwindo aya anofanira kuda chero chinhu chipi zvacho kubva kwauri (kunze kwekubvuma chibvumirano chebvumirano) kunze kwekunge kune dambudziko nemamiriro ako.

05 of 08

Feature Selection

Icho Feature Selection window inowanikwa inotevera inokubvumira kuisa SQL Server zvinhu izvo zvichaiswa panzvimbo yako. Kana uri kuronga kushandisa dhesi iyi mu standalone mamiriro ekuongorora kwemashoko ezvinyorwa, haufaniri kuisa SQL Server Replication. Iwindo iri rinokubvumirawo kusarudza kusaisa matanho ekugadzirisa kana kushandiswa kweDVD kana zvisingakodzeri pane yako. Mumuenzaniso wedu wekutanga, isu tichabvuma zvisizvo zvisingagoneki uye tobva tanongedza Bhokisi rekutsvaga kuti urambe.

SQL Server ichazoita tsvakurudzo yezvitsva (zvakanyorwa kuti "Kuisa Mitemo" mugadziriro yekugadzirisa) uye ichangoenda mberi kuchikwangwani chinotevera kana pasina zvikanganiso. Iwe unogonawo kugamuchira zvisizvo zvisingagoneki paItest Configuration screen uye chengeta Bhokisi Rokudzo zvakare.

06 of 08

Instance Configuration

Chirongwa chinotevera chinokubvumira kusarudza kana iwe uchida kugadzira chiitiko chekutsvaga kana imwe yakanzi zita raSQL Server 2012 pakombiyuta iyi. Kunze kwekuti iwe uine makopi akawanda eSQL Server anoshanda pakombiyuta iyi, unogona kungogamuchira zvigadziriswa zvido.

07 of 08

Server Configuration

Mushure mekusimbisa kuti une disk yakakodzera nzvimbo panzvimbo yako yekuzadzisa kuiswa, mugadziri achapa firiji yekugadzira Server inoratidzwa pamusoro apa. Kana uchida, iwe unogona kushandisa chinyorwa ichi kuti uenzanise maakaiti ayo achashandira SQL Server mazamu. Kana zvisina kudaro, chengetera Bhokisi Rokutanga kuti ubvume zvisizvo zvisingagumi uye ramba uchienda. Iwe unogonawo kugamuchira zvisizvo zvisingagoneki paDesign Engine Configuration uye Error Reporting skrini dzinotevera.

08 we 08

Kuzadzisa Kuiswa

Iyo installer icha ((pakupedzisira!) Inotanga nzira yekugadzirisa. Izvi zvingatora kusvika pamaminitsi makumi matatu zvichienderana nezvinhu zvawakasarudza uye maitiro ekombiyuta yako.