MS SQL neeg rau zaub mov: installation thiab configuration. Version ntawm MS SQL neeg rau zaub mov. MS SQL neeg rau zaub mov thiab 1C

MS SQL neeg rau zaub mov yog ib tug database system tswj cov ntaub ntawv los ntawm lub zoo-paub nyob Microsoft. Cov khoom no mas sib tw thiab yog siv raws li ib tug loj industrial Enterprises, thiab cov tib neeg. Nws yog tam sim no dav siv database, ntsig txog, qhov kev thov rau qhov kev pab cuam tseem loj hlob tuaj. Kev loj hlob ntawm cov khoom pib nyob rau hauv 1985, thiab txij thaum ntawd ib tug tshiab version tawm txhua txhua xyoo, developers yog qhia tshiab pab nta thiab tshem tawm cov kuav qub.

Keeb kwm, 90s

1989 - lub teeb tshwm thawj version ntawm lub software cuab tam, ob leeg txoj kev loj hlob ntawm Microsoft thiab lub tuam txhab Ashton-Tate. Peb tes num tau tsis pom cov kev tsim tej chaw. Firstly, cov neeg siv cov ntawm cov khoom yuav tau hloov mus rau lwm lub operating system. Ob, los ntawm lub sij hawm cov neeg sib tw muaj peev xwm ua tsim SUDB nrog nrug functionality.

1990 - tso zis version MS SQL neeg rau zaub mov 1.1. Lub haumxeeb tuition tus tshiab version yog tsis ntau sib txawv ntawm yav dhau los ib tug (cov ua hauj lwm nrog cov ntaub ntawv, cov SQL nyiaj them yug lus), tab sis ib tug ntau ntawm teeb meem thiab tsis xws luag tau muab kho tas.

1993 - yuav luag ib txhij nrog qhov kev tso tawm ntawm tus tshiab operating system zoo nkaus li SQL neeg rau zaub mov rau lub qhov rais NT, ho superior rau nws cov competitors nyob rau hauv kev kawm ntawv.

1995 - Exit Microsoft SQL neeg rau zaub mov 6.0, thawj cov khoom tso nyias los ntawm Sybase (tuam txhab uas muag uas Microsoft yog tsim software txij li thaum 1987). Cov ntawv tshaj tawm yog zoo heev.

1998 - Las Vegas, ib tug tshiab version ntawm SQL neeg rau zaub mov 7.0. Muaj ntau shortcomings thiab kev kawm ntawv kev txhim kho tau kho. Qhov no version tau raug tsim los rau cov loj corporations uas ua hauj lwm nrog loj nyiaj ntawm cov ntaub ntawv.

History, 2000

1999 - lub teeb tshwm MS SQL neeg rau zaub mov 2000 version tsim nyob rau hauv tib operating system. Version muaj ntau npaum li cas functionality tshaj yav dhau los yog ib tug. Ntawm lawv, cov txoj kev tshiab ntawm kev nkag tau rau cov ntaub ntawv rov qab algorithms, tus tshiab cav (uas yuav qhib li tshiab lub caij rau cov kev loj hlob).

2003 - Creation ntawm MS SQL neeg rau zaub mov 2005. Qhov kev tso cai heev simplifies database txoj kev loj hlob, kom cov ua hauj lwm nrog ib tug loj ntim ntawm cov ntaub ntawv thiab tau mus tawm nrog cov kho uas tsis muaj nyob rau hauv versions yav dhau los.

2008 - Lub rov tshwm sim ntawm ib tug tshiab version ntawm cov kev pab cuam. Nyob rau hauv qhov tseeb, nws yog ib tug ntau ua hauj version ntawm MS SQL neeg rau zaub mov 2005. Muaj tsis muaj kev hloov nyob rau hauv no version tsis.

tam sim no

Nyob rau hauv 2010, lub mobile version ntawm Compact 4.0 twb tshaj tawm. Version yuav tsum tau tsis muaj installation thiab yog sib xws nrog platforms xws li cov API, thiab NET moj khaum, Visual Studio 2010. Nyob rau hauv 2014, cov neeg siv ntawm tus tshiab version ua muaj. Ntau mloog yog them rau ua lub peev xwm volume databases (mus txog pua pua ntawm cov terabytes), ua lag ua luam txawj ntse. Muaj kuj tsim los qhia txog nyob rau hauv lub database qhov chaw. Tus tom ntej version of cov khoom yuav tsum tau hu ua SQL neeg rau zaub mov 2016 thiab tam sim no nws txoj kev loj hlob yog kom nquag plias.

installation

Ua ntej yuav pib lub installation, nco ntsoov mus xyuas cov kev uas yuav tsum. Yam tsawg kawg nkaus li nram no:

• Processor - Intel (los yog tshaj) pentium III 1000MHz los yog ntau dua.
• RAM - 512 MB los yog ntau tshaj.
• Hard disk qhov chaw - 20 GB los yog ntau tshaj.

Pom zoo uas yuav tsum:

• Processor - Intel ntxhais i7 3000 MHz los yog ntau dua.
• RAM 4 GB los yog ntau tshaj;
• Hard disk qhov chaw yuav tsum nyob nruab nrab ntawm 100 GB los yog ntau tshaj.

Yog hais tias lub computer uas koj nruab qhov kev pab cuam, raws li cov saum toj no yuav tsum tau, koj yuav npaj mus nruab. Txhim kho MS SQL neeg rau zaub mov yog tsis nyuab heev thiab tsis txawv ntawm cov pa installation cov kev pab cuam nyob rau hauv lub qhov rais. Muaj ib co yus nta uas piav nyob rau hauv no tsab xov xwm.

1. Yog xav tau pib koj yuav tau khiav lub teeb ntaub ntawv raws li ib tug neeg khiav dej num (koj yuav tsum nias rau ntawm ib cov ntaub ntawv, txoj cai-nias thiab xaiv "Khiav raws li cov thawj coj").
2. "Installation Center" qhov rais qhib. Nws xaiv tus seem "Kev Npaj", qhov twg lub computer configuration yog qhia tau tseeb.
3. Yog hais tias tag nrho cov mus zoo, nyob rau hauv tib lub qhov rais, xaiv cov "Teeb" nyob rau hauv lub npaj daim ntawv teev, xaiv thawj yam khoom, uas peb qhia rau nruab ib lub software los yog ntxiv tshiab nta mus rau nws.
4. Sau qhov yuav tsum tau tseem ceeb (feem ntau yog nws yog sau nyob rau hauv lub thawv nrog cov software).
5. Txais cov nqe lus piav nyob rau hauv daim ntawv tso cai, thiab muab tso rau ib tug zuam nyob rau hauv lub qhov chaw.
6. Ces nyem "Nruab" khawm.
7. Xaiv lub Cheebtsam rau nruab.
8. Xaiv "Default Piv txwv li".

Rau optimum kev ua tau zoo, tus software cuab yeej tsim nyog los kho ua ntej installation. Cov tshooj tom ntej yuav zoo li cas yuav ua rau nws.

hloov

Configuring MS SQL neeg rau zaub mov yog ua li cas ua ntej installation. Yog li ntawd, thaum teem mus sawv yuav tsum tau tshwj xeeb tshaj yog tau ceev faj, vim hais tias ib co configuration xaiv yuav tsis yooj yim sua kom hloov tom qab installation.

1. Nyob rau hauv lub "neeg rau zaub mov Configuration" Peb nug kom xaiv cov hom ntawm cov kev pab cuam (txiav los yog manually). Nyob rau tag nrho cov kev pab cuam tshwj tsis yog tag nrho cov ntawv nyeem Lim Daemon Launcher, xaiv "Nws pib". Nyem "Tom ntej no."
2. Nyob rau hauv lub seem hu ua "neeg rau zaub mov Configuration" yog tsis muaj yuav tsum tau hloov ib yam dab tsi, yog li dua peb nias "Tom ntej no."
3. Nyob rau hauv lub "Database cav Configuration", xaiv "Mixed hom" thiab teem lub username thiab cov neeg khiav dej num lo lus zais. Nyob rau hauv tib lub qhov rais, mus rau lub tab "Cov ntaub ntawv Wage". Teem muaj txoj kev nyob qhov twg cov ntaub ntawv yuav tau muab cia rau hauv lub database. Nyem tom ntej.
4. Xaiv lub neej ntawd chaw (thawj yam khoom).
5. Cov kev ua yuam kev daim ntawv qhia chaw qhov rais, xaiv seb qhov kev pab cuam yuav tau xa ib daim ntawv qhia rau Microsoft kev ua yuam kev los txhim kho lub software.

Lub installation thiab teeb tiav, qhov kev pab cuam yog npaj txhij mus ua hauj lwm.

Configure tej thaj chaw deb Access

Xav txog qhov chaw kawm ib txoj kev uas yuav pab cuam rau tej thaj chaw deb. Qhov no feature yog pab tau yog hais tias tus lub koom haum ntawm qhov kev pab cuam yog ntsia tau rau ntau tshaj ib lub computer. Tom qab kev txhim kho cov software, MS SQL neeg rau zaub mov, ua cov nram qab no:

1. Nyob rau hauv lub "Start" ntawv qhia zaub mov, xaiv "Tag nrho cov kev pab cuam"> MS SQL neeg rau zaub mov> Configuration nqis.
2. Xaiv cai rau SQLEXPRESS, ces TCP / IP.
3. TCP / IP Keyboards rau Pab.
4. Xaiv "Properties", ces tus IP adresses tab.
5. Tom ntej no, xaiv SQL neeg rau zaub mov Services.
6. Pib dua lub SQL neeg rau zaub mov kev pab, xaiv restart.

Tom ntej no, koj yuav tsum pab kom cov firewall operating system yuav tau txais khoom lus. Yuav kom qhov no kawg, peb nqa tawm cov nram qab no ua:

1. Mus saib tau lub zog ntawm firewall, peb yuav nrhiav tau nyob rau hauv cov zaub mov "Start"> "Administrative cuab yeej".
2. Nyob rau hauv lub Firewall qhov rais, xaiv Inbound kev cai.
3. Tom ntej no, xaiv Chaw nres nkoj.
4. Ces koj yuav tsum qhia kom meej TCP thiab nws cov coj tooj, nyob rau hauv cov ntaub ntawv no 1433.
5. Cov kauj ruam tom ntej, xaiv Cia lub kev twb kev txuas.
6. Nyob rau hauv lub kauj ruam tom ntej, Profile las tag nrho cov thawv.
7. Xaiv txoj kev lub npe.

Yog hais tias ua kom raug, lub MS SQL neeg rau zaub mov database yuav tsum khiav remotely.

yuav pab tau yim pab

Xam tias yog software cuab tam yog ib tug ncaj nyuab software. Ntawm no yog ob peb lub tswv yim uas yuav ua rau nws yooj yim mus ua hauj lwm nrog MS SQL neeg rau zaub mov software:

• Cov kev txwv thaum ua hauj lwm nrog 1C thov rau ib co versions, yog li ua ntej yuav ua raws li ntawm lub cev yuav tsum hais qhov teeb meem ntawm software interoperability.
• Yog hais tias koj khiav lub database nyob rau hauv ib tug tom qab version, koj yuav khiav tsis tau nws nyob rau hauv ua ntej lawm versions.
• Yog hais tias koj xav kom xa mus rau lub neeg rau zaub mov ob peb paub tab nyob rau hauv ib zaug xwb lw, nws yog tsim nyog los qhia kom meej qhov tseeb hom lw. Ua li no, nws yog qhov zoo tshaj plaws los mus teev cov hom yuav tau txiav txim seb cov kev sib pauv: SET IMPLICIT_TRANSACTIONS OFF.
• Yog hais tias qhov kev pab cuam generates ib qho yuam kev thaum muaj ntau databases, nws txhais tau tias database ntaub ntawv yog incompatible versions. Nyob rau hauv cov ntaub ntawv no, cov laus database yuav tsum hloov mus rau ib tug tom qab version.
• Yuav kom txiav txim rau txoj kev uas lub database nyem rau ntawm qhov txoj cai nas khawm thiab xaiv "Properties."

es tsis txhob ntawm ib tug xaus

Tam sim no, paub databases yog siv nyob rau hauv txhua lub koom haum uas yuav tsum tau tsim loj thiab me me khw muag khoom noj. Qhov ntau muab faib rau ntawm no software muab developers ib tug zoo impetus rau txoj kev loj hlob, yog li ntawd lawv sawv cev rau lub ntiaj teb no txhua txhua xyoo ntau thiab ntau paub versions ntawm nws cov software. Sib koom MS SQL neeg rau zaub mov thiab 1C heev simplifies lub voj voog uas muaj ntau cov lag luam, txuag lawv ntawm ruaj ntaub ntawv. Nws tus kheej xam tias yog qhov software yog tsis heev yooj yim mus siv thiab tso cai rau cov neeg siv kom sai sai kawm tag nrho cov yooj yim tej yam yuav ua rau kev ua hauj lwm nrog cov kev pab cuam.