MS SQL Server: ukufakwa kanye ukucushwa. Inguqulo ye-MS SQL Server. MS SQL Server futhi 1c

MS SQL Server lwedatha ngabaphathi semininingwane uhlelo kusukela owaziwa kuMicrosoft. Umkhiqizo yemincintiswane futhi lisetshenziswa njengendlela amabhizinisi zezimboni ezinkulu, kanye nabantu. Manje asetshenziswa kabanzi egciniwe, ngokulandelana, ukufunwa hlelo luqhubeka lukhula. Ukuthuthukiswa yomkhiqizo waqala ngo-1985, futhi kusukela ngaleso sikhathi inguqulo entsha uphuma njalo ngonyaka, onjiniyela Wethula izici ezintsha eziwusizo futhi ususe ezingadingeki ubudala.

Umlando, 90s

1989 - ukukhanya livela inguqulo yokuqala ithuluzi software, ukuthuthukiswa ahlangene Microsoft futhi inkampani Ashton-Tate. Lo mklamo ayitholakalanga ukuthandwa kulindeleke. Okokuqala, abasebenzisa mkhiqizo kufanele ushintshele komunye yesistimu yokusebenza. Okwesibili, ngesikhathi izimbangi bakwazi ukwakha SUDB ngemisebenzi ebanzi.

1990 - okukhipha okufushane MS SQL Server 1.1. Amakhono obusebenzayo inguqulo entsha kwakungeyona okuningi ezahlukene kusukela sangaphambilini (umsebenzi ngedatha, SQL ukweseka ulimi), kodwa eziningi amaphutha kanye zamehlo eye yalungiswa.

1993 - cishe kanyekanye ukukhululwa esimisweni esisha yokusebenza ibonakala SQL Server-Windows NT, kakhulu njengoba kuphakeme kakhulu izimbangi zayo ekusebenzeni.

1995 - Phuma Microsoft SQL Server 6.0, umkhiqizo wokuqala ezikhishwe ngokuhlukile Sybase (izinkampani ngawo Microsoft ethuthuka isofthiwe kusukela 1987). Isimemezelo waphumelela kakhulu.

1998 - Las Vegas, inguqulo entsha SQL Server 7.0. amaphutha amaningi futhi kokusebenza eye yalungiswa. Le nguqulo iye eyenzelwe izinkampani ezinkulu ezisebenza esiningi idatha.

Umlando, 2000

1999 - ukukhanya livela MS SQL Server 2000 version athuthukiswe ngaphansi uhlelo lokusebenza efanayo. Inguqulo kwadingeka ukusebenza okuningi kwalowo odlule. Phakathi kwabo, indlela entsha yokusondela yokutakula idatha algorithm, injini entsha (okuvulela amathuba okuthuthukisa).

2003 - Ukudalwa MS SQL Server 2005 Lokhu kukhululwa lula kakhulu ukuthuthukiswa egciniwe, asheshise umsebenzi nge yenqwaba Imininingwane waphuma ezinamaphutha ukulungiswa ezazisemizini izinguqulo ezandulele.

2008 - Ukuvela inguqulo entsha uhlelo. Eqinisweni, luwuhlobo obusebenzayo ngaphezulu MS SQL Server 2005 Azikho izinguquko ezinkulu kule nguqulo akusho.

samanje

Ngo-2010, le nguqulo mobile ye Compact 4.0 kwamenyezelwa. Inguqulo akudingi ukufakwa futhi iyahambisana ezisekelweni ezifana-API, futhi Framework NET, e-Visual Studio 2010. Ngo-2014, abasebenzisi inguqulo entsha kwase kutholakala. ukunakwa okuningi ikhokhelwa ekukhuphuleni ezingaba ivolumu yolwazi (kufika ku amakhulu terabytes), kwezamabhizinisi. Kukhona futhi izenzakalo ukubika esikhaleni egciniwe. Le nguqulo esilandelayo umkhiqizo kuyothiwa SQL Server 2016 futhi okwamanje ukuthuthukiswa yayo iyasebenza.

ukufakwa

Ngaphambi kokuqala ukufakwa, qiniseka ukuhlola nezidingo zesistimu. Ubuncane elandelayo:

• Processor - Intel (noma ehambisanayo) Pentium III 1000MHz noma ngaphezulu.
• RAM - 512 MB noma ngaphezulu.
• Hard sediski - 20 GB noma ngaphezulu.

izidingo zohlelo Kunconywe:

• Processor - Intel Core I7 3000 MHz noma ngaphezulu.
• RAM 4 GB noma ngaphezulu;
• Hard sediski kumele abe phakathi 100 GB noma ngaphezulu.

Uma ikhompyutha lapho ufaka uhlelo, ukuhlangabezana nezidingo ngenhla, usukulungele ukufaka. Ukufaka MS SQL Server akuyona yisixakaxaka futhi akahlukile izinhlelo ukufakwa esiku-Windows. Kukhona ezinye izici zayo ukuthi zichazwe lesi sihloko.

1. Ukuze uqalise udinga ukusebenzisa ifayela isethaphu njengoba umlawuli (kufanele chofoza ifayela, qhebeza kwesokudla bese ukhetha "Run njengoba umlawuli").
2. "Ukufakwa Centre" iwindi kuvula. It ukhetha esigabeni "Ukuhlela", lapho ukucushwa ikhompyutha liqinisekisiwe.
3. Uma konke kuhamba kahle, ewindini elifanayo, khetha "Isethaphu" ohlwini ezihlongozwayo, khetha into yokuqala, okuyinto siphakamisa ukufaka isofthiwe noma wengeze izici ezintsha kukho.
4. Faka ukhiye edingekayo (ngokuvamile kulotshiwe ebhokisini ngesofthiwe).
5. Yamukela imigomo echazwe ilayisensi, wafaka umkhaza endaweni efanele.
6. Bese uchofoza "Faka" inkinobho.
7. Ukukhetha izingxenye ukufaka.
8. Khetha "Okuzenzakalelayo Ngokwesibonelo".

Ukuze usebenze ngokugcwele, amathuluzi software adingekayo ukumisa ngaphambi kokufakwa. Isihloko esilandelayo sizodingida sibheke indlela yokukwenza.

ukulungiswa

Ilungiselela MS SQL Server kwenziwa ngaphambi kokufakwa. Ngakho-ke, uma usetha i-zezitsha ukuze baqaphele ngokukhethekile, ngoba ezinye izinketho ukucushwa ngeke ukushintsha ngemuva kokufaka.

1. Esikhathini "Iseva Ukucushwa" Sacela ukukhetha uhlobo isevisi (ngokuzenzekelayo noma ngesandla). On wonke amasevisi ngaphandle Okugcwele Umbhalo Hlunga Daemon Sokuqalisa, khetha "Auto". Chofoza "Next."
2. Esigabeni ngokuthi "Iseva Ukucushwa" asikho isidingo ukushintsha into, ngakho futhi thina uchofoze "Okulandelayo."
3. Esikhathini "Database Engine Ukucushwa", khetha "Imodi ezixutshiwe" bese usetha igama lomsebenzisi futhi iphasiwedi nomqondisi. Ewindini elifanayo, yana kwi-tab "Idatha Ezinye". Setha lapho indlela lapho amafayela izogcinwa database. Chofoza Next.
4. Ukukhetha Ukulungiselelwa okuzenzakalelayo (into yokuqala).
5. Iwindi izilungiselelo umbiko wephutha, ukhethe ukuthi lolu hlelo luyoba ngokuzenzekelayo umbiko iphutha Microsoft ukuthuthukisa isofthiwe.

Ukufakwa nokusetha usuphothuliwe, uhlelo ukulungele ukusebenza.

Lungiselela Remote Access

Naka ukusetha indlela uhlelo sokufinyelela kude. Lesi sici ewusizo uma inhlangano uhlelo efakwe kwi ezingaphezu kwesisodwa ikhompyutha. Ngemva kokufaka i-software, MS SQL Server, yenza okulandelayo:

1. Esikhathini "Qala" menu, khetha "Zonke Izinhlelo"> MS SQL Server> yokumiswa kwamasethingi.
2. Khetha Izivumelwano for SQLEXPRESS ke TCP / IP.
3. TCP / IP Ishintsha Vumela.
4. Khetha "Properties", bese-IP Adresses ithebhu.
5. Okulandelayo, khetha SQL Server Services.
6. Qala kabusha SQL Server Services, khetha ukuqalisa phansi.

Okulandelayo, kufanele uvumele i-firewall yesistimu yokusebenza ukuze uthole imilayezo engenayo. Kuze kube yimanje, sifeza izenzo ezilandelayo:

1. Ukufinyelela nemisebenzi firewall, singathola kwimenyu "Qala"> "Amathuluzi Administrative."
2. Ku-window firewall, khetha Imithetho kwangaphakathi.
3. Okulandelayo, khetha Port.
4. Khona-ke udinga ukucacisa TCP kanye nenombolo yayo ehambisana, kulesi simo-1433.
5. Isinyathelo esilandelayo, khetha Vumela uxhumano.
6. In the isinyathelo esilandelayo, Iphrofayela adalule wonke amabhokisi.
7. Ukukhetha igama kwesokudla.

Uma kwenziwe ngendlela efanele, i-database MS SQL Server kungenziwa run ukude.

Amacebo eziwusizo

Kubhekwe isofthiwe thuluzi isofthiwe sasivumela kuyinkimbinkimbi. Nanka amathiphu ambalwa kuzokwenza kube lula ukusebenza software MS SQL Server:

• Ukulinganiselwa lapho esebenza 1c zisebenze kwezinye izinguqulo, ngaphambi kokusebenza kohlelo kumele sicacise udaba software ukusebenzelana.
• Uma uphelelwa database inguqulo kamuva, awukwazi uyisebenzise ku izinguqulo ngaphambili.
• Uma ufuna ukuthumela iseva imisebenzi eminingana ngaphakathi ukuthengiselana olulodwa, kubalulekile ukuba ucacise uhlobo efanele kuthengiselana. Ukuze wenze lokhu, kungcono kakhulu ukunquma ukuthi uzosebenzisa imodi ukucacisa ngokuzenzakalelayo lomsebenzi: SET IMPLICIT_TRANSACTIONS OFF.
• Uma uhlelo edonsa iphutha uma yolwazi amaningi, kusho ukuthi amafayela database kukhona izinguqulo engahambelani. Kulokhu, database amadala kufanele ukuguqukela inguqulo kamuva.
• Ukuze sithole indlela database chofoza inkinobho yegundane kwesokudla bese ukhetha "Properties."

esikhundleni isiphetho

Okwamanje, yolwazi zingubudlelwane asetshenziswa cishe zonke izinhlangano ukuthi udinga ukudala ezitolo ezinkulu kanye nezincane. Ukusakazwa kabanzi le software kunikeza Onjiniyela negalelo elikhulu ekuthuthukiseni, ngakho ukuthi bamele izwe izinguqulo njalo ngonyaka futhi ngcono ngaphezulu isofthiwe yayo. Ukwabelana MS SQL Server futhi 1c lula kakhulu umjikelezo we amabhizinisi amaningi, ukuwalondoloza kusukela emsebenzini wamaphepha ezingadingekile. Wona kubhekwe isofthiwe akunzima kakhulu ukusebenzisa futhi ivumela abasebenzisi ukuze ufunde ngokushesha zonke izenzo eziyisisekelo ezidingekayo ukuze ukusebenza uhlelo.