MS SQL Server: yokufaka uqwalaselo. Version of SQL Server MS. MS SQL Server kunye 1C

MS SQL Server i ulawulo ledatha lesistim data evela kakuhle yaziwa Microsoft. Le mveliso inokhuphiswano kakhulu yaye usetyenziswa njengendawo amashishini amakhulu orhwebo, kunye nabantu. Ngoku ngokubanzi database, ngokulandelelana, imfuno le nkqubo iyaqhubeka ngokukhula. Development imveliso yaqala ngo-1985, yaye ukususela ngoko inguqulelo entsha uyaphuma ngonyaka ngamnye, abaphuhlisi sazisa iimpawu ezintsha kuluncedo kwaye susa endala akaloncedo.

History, 90

1989 - Ukhanyiso ke olo lwabonakala inguqulelo yokuqala isixhobo software, uphuhliso odibeneyo Microsoft kunye nenkampani Ashton-Tate. Le projekthi iye akafumaneki ukuthandwa kulindeleke. Okokuqala, abasebenzisi imveliso kwakuza kufuneka batshintshele kwenye inkqubo yokusebenza. Okwesibini, xa ngexesha okhuphisana bakwazi ukuyila SUDB kunye nokusebenza ngokubanzi.

1990 - version output Umncedisi MS SQL 1.1. Namakhono ezisebenzayo inguqulelo entsha leyo kakhulu ezahlukene kowangaphambili (umsebenzi kunye data, SQL inkxaso ulwimi), kodwa ixesha elininzi iimpazamo neziphene sele zilungisiwe.

1993 - phantse ngaxeshanye kwakhululwa inkqubo entsha yokusebenza kubonakala Kumncedisi we SQL for Windows NT, mkhulu kakhulu abadlali yayo yokusebenza.

1995 - Phuma Umncedisi Microsoft SQL 6.0, imveliso yokuqala kukhululwa ngokwahlukileyo Sybase (iinkampani apho Microsoft liphuhlisa isoftware ukususela 1987). I saziso yimpumelelo gqitha.

1998 - Las Vegas, inguqulelo entsha ye Kumncedisi we SQL 7.0. iintsilelo ezininzi kunye nokuphuculwa komsebenzi sele zilungisiwe. Le nguqulelo iyilwe close ezinkulu ezisebenza imali ezinkulu ze data.

History, 2000

1999 - ukukhanya kuvela MS SQL Server 2000 phambili phantsi kwenkqubo enye lokusebenza. Version waba kumsebenzi omninzi ezidlulileyo. Phakathi kwabo, indlela entsha ukufikelela algorithms recovery data, i-injini entsha (leyo kuvula amathuba amatsha ophuhliso).

2003 - Ukudalwa Kumncedisi MS SQL 2005. Le ukukhululwa lula kakhulu kuphuhliso database, kukhawulezisa umsebenzi kunye umthamo omkhulu wolwazi waphuma iziphoso izakulungiswa ezibe iinguqulelo ezidlulileyo.

2008 - Le ukuvela inguqulelo entsha ye-nkqubo. Enyanisweni, oko uguqulelo esebenza ngakumbi Kumncedisi MS SQL 2005. Akukho iinguqulelo ezininzinzi kweli olu guqulelo na.

khona

Ngo-2010, yinguqulelo yemobile Compact 4.0 wabhengezwa. Version kufuna akukho ufakelo kwaye iyahambelana kumaqonga afana ne-API, neSakhelo NET, zeStudiyo zokuBonakalayo 2010. Ngo-2014, abasebenzisi kwefom entsha baba ekhoyo. ingqalelo Kuninzi ihlawulwe ukwandisa oovimba umthamo amandla (ukuya kutsho kumakhulu terabytes), ubukrelekrele ishishini. Kukho kwakhona ngaba ukuxela kwisithuba ledatha. Inguqulelo elandelayo imveliso iya kubizwa ngokuba Kumncedisi we SQL 2016 yaye njengangoku nophuhliso yayo iyasebenza.

ukufakwa

Ngaphambi kokuba uqalise ufakelo, qiniseka ukukhangela iimfuno zendlela. Ubuncinane lulandelayo:

• Odolo - Intel (okanye ehambelanayo) 1000MHz Pentium III okanye ngaphezulu.
• RAM - 512 MB okanye ngaphezulu.
• isithuba kwidiski nzima - 20 GB okanye ngaphezulu.

Iimfuno system Ithethelelwe:

• Odolo - Intel Core i7 3000 MHz okanye ngaphezulu.
• RAM 4 GB okanye ngaphezulu;
• isithuba kwidiski ezingamaphepha kufuneka abe phakathi kuka-100 GB okanye ngaphezulu.

Ukuba ikhompyutha kuyo ufake i gocr, abazanelisayo ezi mfuno zilapha ngentla, ukulungele ukufaka. Ifakela MS SQL Iseva ayikho inzima kakhulu kwaye ayahlukanga kwiinkqubo ufakelo oluqhelekileyo kwi Windows. Kukho ezinye iinkalo ezikhethekileyo ukuba zichazwe kweli nqaku.

1. Ukuze uqalise ufuna ifayile yababini njengento umphathi (kufuneka nqakraza kwifayile, nqakraza-ekunene kwaye ukhethe "Baleka umlawuli").
2. "Ufakelo Center" window ivula. It khetha icandelo "uCwangciso", apho uqwalaselo yekhompyutha luqinisekisiwe.
3. Ukuba konke kuhambe kakuhle, kwi window enye, khetha i "Setup" kuluhlu ecetywayo, khetha into yokuqala, leyo sicebisa ukuba zifake isoftware okanye songeze iimpawu ezintsha kuyo.
4. Ngenisa ezingundoqo ezifunekayo (idla ngokuba kubhaliwe kwathiwa kwibhokisi ne-educational software).
5. Yamkela imiqathango echazwe kule mvume, uze ubeke uphawu kwindawo efanelekileyo.
6. Ngoku nqakraza "Faka" iqhosha.
7. Ukukhetha amacandelo ukufaka.
8. Khetha "Default umzekelo '.

Ukuze lusebenze, izixhobo isoftware eyimfuneko ukuqwalasela phambi ufakelo. Isahluko esilandelayo siza kujonga indlela yokuyenza.

ukulungiswa

Kulungiselelwa Umncedisi MS SQL kwenziwa phambi kokufakwa. Ngoko ke, xa ucwangcisa umi ukuba alumke ngakumbi, kuba ezinye iinketho zoqwalaselo kuya kuba nzima ukutshintsha emva kokufakwa.

1. Xa "Umncedisi woqwalaselo" wabuza ukuba ukhethe uhlobo lwenkonzo (ngokuzenzekelayo okanye ngesandla). Kuzo zonke iinkonzo ngaphandle Isihluzi Text Full Daemon Yokhupha, khetha "Auto". Nqakraza "Landelayo."
2. Kwicandelo ekuthiwa "Umncedisi woqwalaselo" akukho mfuneko ukutshintsha into, ngoko kwakhona unqakraza "Okulandelayo."
3. Xa "sedata Uqwalaselo Engine", khetha "Indlela Oluyingxubevange 'uze usete lomsebenzisi kunye negama lokugqitha nomlawuli. Kwi window ofanayo, yiya kwi tab "Data Izalathisi". Cwangcisa apho umendo apho iifayile aya igcinwe kwiziko ledatha. Nqakraza Okulandelayo.
4. Ukukhetha ucwangciso olungagqibekanga (umba lokuqala).
5. Izicwangciso error report window, khetha ukuba le program iya kuthi ngokuzenzekelayo ukuthumela ingxelo imposiso Microsoft ukuphucula software.

Ufakelo kunye setup igqityiwe, le nkqubo ilungele ukusebenza.

Qwalasela Access Remote

Cinga ukubeka indlela kwiprogram ukufikelela kude. Lo msebenzi osemqoka uluncedo ukuba lombutho inkqubo ifakwe kwikhompyutha ngaphezu kwesinye. Emva kokufakela i-software, MS SQL Server, yenza oku kulandelayo:

1. Xa "Qala" menu, khetha "Zonke iiNkqubo"> Kumncedisi we SQL MS> Useto lwesimo.
2. Khetha Izivumelwano for SQLEXPRESS, ngoko TCP / IP.
3. TCP / IP itshintshela Yenza.
4. Khetha "Properties", ngoko IP Adresses tab.
5. Okulandelayo, khetha Iinkonzo Kumncedisi we SQL.
6. Qala i Services Kumncedisi we SQL, khetha qala.

Okulandelayo, kufuneka ukuba inkqubo yokusebenza firewall ukufumana imiyalezo engenayo. Ukuza kuthi ga ngoku, sifeza le manyathelo alandelayo:

1. Ukufikelela nemisebenzi firewall, sinokufumana kwi menu "Qala"> "Tools Administrative".
2. Kwi window Firewall, khetha Imithetho kwangaphakathi.
3. Okulandelayo, khetha Port.
4. Emva koko kufuneka ukhankanye TCP kunye nenombolo yayo ehambisana, kulo mzekelo 1433.
5. Inyathelo elilandelayo, khetha Vunyiwe udibaniso.
6. Kulo inyathelo elilandelayo, iprofayili ukuveza zonke iibhokisi.
7. Ukukhetha igama elifanelekileyo.

Ukuba yenziwe ngokuchanekileyo, i-database MS SQL Server esebenzisekayo kude.

amacebo aluncedo

isixhobo software ayikhumbule software noko inzima. Nazi iingcebiso ezimbalwa eya kwenza kube lula ukusebenza nge-software Umncedisi MS SQL:

• Imida xa esebenza 1C isicelo kwezinye iinguqulelo, ngoko phambi kokuba ukuphunyezwa kwale nkqubo kufuneka icacise umba software ukusebenziseka.
• Ukuba silubaleke database iyinguqulelo kamva, awunaku kwazi ukusebenzisa phezu iinguqulelo ngaphambili.
• Ukuba ufuna ukuthumela kumncedisi imisebenzi emininzi ngaxesha phakathi isivumelwano eyodwa, kuyimfuneko ukuba ucacise uhlobo oluchanekileyo lwesivumelwano. Ukuze wenze oku, eyona nto ingcono ukuseta imo ukujonga ngokuzenzekelayo intengiselwano: IMPLICIT_TRANSACTIONS SET OFF.
• Ukuba udweliso lwenkqubo ivelisa imposiso xa iinkcukacha ezininzi, oko kuthetha ukuba iifayili ledatha na iinguqulelo ezingahambelaniyo. Kulo mzekelo, i-database nangaphezulu kufuneka ukuguqula kuguqulelo kamva.
• Ukuze ubone indlela i-database nqakraza kwi ekunene iqhosha lemouse ekunene kwaye ukhethe "Properties."

endaweni yesiphelo

Okwangoku, edatha zonxulumelwano zisetyenziswa phantse yonke imibutho kufuneka ukudala kwiivenkile ezinkulu nezincinane. Ukusasazwa ngokubanzi kwale software unika ababhekisi negalelo elikhulu kuphuhliso, ukuba bamele ihlabathi minyaka yonke ngakumbi kwaye kuphuculwe ngakumbi iinguqulelo ze-software yayo. Ukwabelana Server MS SQL kunye 1C lula kakhulu kumjikelo kwamashishini ezininzi, ukugcina kwabo wamaphepha ezingeyomfuneko. Ngokwayo ingqalelo le software nzima kakhulu ukuba ukusebenzisa kwaye kuvumela abasebenzisi ukuba bafunde ngokukhawuleza zonke izenzo ezisisiseko ezifunekayo yokusebenza kunye nenkqubo.