MS SQL Server: unsembe ndi kasinthidwe. Version wa MS SQL yawonongeka. MS SQL Server ndi 1C

MS SQL Server ndi kasamalidwe Nawonso achichepere dongosolo kafukufuku odziwika bwino pa Microsoft. mankhwala ndi mpikisano waukulu ndi ntchito monga makampani akuluakulu mafakitale ndi anthu. Panopa chimagwiritsidwa ntchito Nawonso achichepere, motero, kufunika kwa dongosolo chikukulirakulirabe. Development wa mankhwala inayamba mu 1985, ndipo kuyambira pamenepo Baibulo latsopano akutuluka chaka chilichonse, kutukula ndi kuyambitsa zatsopano zothandiza ndi kuchotsa unneeded akale.

History, 90s

1989 - kuwala limapezeka buku loyamba la chida mapulogalamu, chitukuko anzake a Microsoft ndi kampani Ashton-Tate. Ntchitoyi yatenga sanapezeke kutchuka kuyembekezera. Choyamba, okonda mankhwala adzakhala ndi kusinthana kwa kachitidwe kena opaleshoni. Chachiwiri, nthawi mpikisano anali Ngokhoza kulenga SUDB ndi magwiridwe zambiri.

1990 - linanena bungwe Baibulo MS SQL Server 1.1. The mphamvu zinchito Baibulo latsopanoli sanali osiyana kwambiri kuyambira yapita (ntchito ndi deta, chinenero SQL chithandizo), koma kwambiri zolakwa ndi zophophonya awawongolera.

1993 - pafupifupi imodzi ndi kutulutsidwa kwa dongosolo latsopano opaleshoni limapezeka SQL Server Windows NT, kwambiri kuposa mpikisano mu ntchito.

1995 - Tulukani Microsoft SQL Server 6,0, mankhwala choyamba anamasulidwa mosiyana Sybase (makampani amene Microsoft kusiyana mapulogalamu kuyambira 1987). chilengezo inayenda bwino kwambiri.

1998 - Las Vegas, Baibulo latsopano SQL Server 7,0. zolakwa zambiri ndi patsogolo ntchito awawongolera. Baibulo lalembedwa kwa mabungwe akuluakulu kuti ntchito ndi yambiri deta.

History, 2000

1999 - kuwala limapezeka MS SQL Server 2000 Baibulo anayamba pansi dongosolo lomwelo opaleshoni. Version anali magwiridwe kwambiri kuposa wina m'mbuyomu. Pakati pawo, njira yatsopano yopempherera kwa ma aligorivimu deta kuchira, injini watsopano (amene atsegula mwayi chitukuko).

2003 - Creation wa MS SQL Server 2005. kumasulidwa Izi kwambiri zimatithandiza chitukuko Nawonso achichepere, kufulumizitsa ntchito ndi buku lalikulu mauthenga ndi anatuluka ndi zolakwa kudzudzulidwa kuti anali Mabaibulo m'mbuyomu.

2008 - The zikamera wa Baibulo latsopano pulogalamu. Ndipotu, ndi podziwa kwambiri zinchito za MS SQL Server 2005. Palibe kusintha kwakukulu mu Baibulo silikunena.

pano

Mu 2010, Baibulo mafoni a Yaying'ono 4.0 analengeza. Version amafuna palibe unsembe ndi n'zogwirizana ndi nsanja monga API, ndi NET M'chilamulo, zithunzi situdiyo 2010. Mu 2014, okonda Baibulo latsopanoli anapezeka. chidwi linaperekedwa kwa kukula ndi kuthekera zinasokoneza makompyuta buku (kwa mazana a terabytes), ntchito nzeru. Palinso zikuchitika kuti afotokoze danga Nawonso achichepere. Baibulo wotsatira wa mankhwala adzatchedwa SQL Server 2016 ndipo panopa chitukuko ukugwirira.

unsembe

Asanayambe unsembe, onetsetsani kuti amafuna dongosolo. Osachepera motere:

• Purosesa - Intel (kapena n'zogwirizana) Pentium III 1000 MHz kapena kuposerapo.
• RAM - 512 MB kapena zambiri.
• Mwakhama litayamba danga - 20 GB kapena kuposa.

amafuna dongosolo tikulimbikitsidwa:

• Purosesa - Intel Kore i7 3000 MHz kapena kuposerapo.
• RAM 4 GB kapena zambiri;
• Mwakhama litayamba danga ayenera kukhala pakati 100 GB kapena kuposa.

Ngati kompyuta limene inu kukhazikitsa pulogalamu, akwaniritsa zofunikira pamwamba, mwakonzeka kukhazikitsa. Khazikitsa MS SQL Server si yovuta kwambiri ndipo sasiyana ku ndondomeko ochiritsira unsembe pa Windows. Pali zina zapadera zimene zikufotokozedwa m'nkhani ino.

1. Kuti tiyambepo muyenera kuthamanga khwekhwe file monga mkulu (muli alemba pa wapamwamba, dinani-kumanja ndi kusankha "Thamanga woyang'anira").
2. "Unsembe Center" zenera chikuyamba. Ndi kusankha gawo "Planning", pomwe kasinthidwe kompyuta wotsimikizika.
3. Ngati zonse zitayenda bwino, mu zenera lomwelo, kusankha "dongosolo" mu mndandanda akufuna, kusankha chinthu choyamba, chimene ife akamufunsirire kukhazikitsa pulogalamu kapena kuwonjezera zatsopano kwa iwo.
4. Lowani fungulo chofunika (zambiri kwalembedwa mu bokosi ndi mapulogalamu).
5. Landirani mawu anafotokoza mu chiphaso, ndi kuika mudzichonga mu malo oyenera.
6. Kenako dinani "kukhazikitsa" batani.
7. Kusankha zigawo kukhazikitsa.
8. Sankhani "Pofikira Mwachitsanzo".

Kuchitila akadakwanitsira, mapulogalamu zipangizo zofunika sintha pamaso unsembe. Mutu wotsatira kuyang'ana momwe angachitire izo.

kusintha

Configuring MS SQL Server zachitika isanafike unsembe. Choncho, pamene atakhala nthandala kusamala makamaka chifukwa ena options kasinthidwe kadzakulakani kusintha pambuyo unsembe.

1. Mu "Server kasinthidwe" Tinafunsa kusankha mtundu wa utumiki (kokha kapena pamanja). Pa ntchito zonse kupatula Full Text Sefani Daemon Launcher, kusankha "Auto". Dinani "Kenako."
2. Mu gawo lotchedwa "Server kasinthidwe" palibe kusintha chinachake, kotero ife dinani "Kenako."
3. Mu "Nawonso achichepere Engine kasinthidwe", kusankha "obwerawa mumalowedwe" ndipo anapereka lolowera ndi woyang'anira achinsinsi. Mu zenera lomwelo, kupita ku tsamba "Data akalozera". Ndinakhala pamenepo njira kumene owona udzasugidwa kwa Nawonso achichepere. Dinani Next.
4. Kusankha kuti mukuona kusakhulupirika (chinthu choyamba).
5. The zoikamo zolakwa lipoti zenera, kusankha ngati pulogalamu adzakhala basi kutumiza lipoti zolakwa Microsoft kusintha mapulogalamu.

The unsembe ndi khwekhwe udzatha, dongosolo ndi wokonzeka ntchito.

Sintha Akutali Access

Taganizirani atakhala njira pulogalamu kupeza akumidzi. Mbali imeneyi ndi zothandiza ngati gulu la pulogalamu waikidwa pa kompyuta kuposa wina. Pambuyo khazikitsa mapulogalamu, MS SQL Server, chitani zotsatirazi:

1. Mu "Start" menyu, kusankha "Mapologalamu onse"> MS SQL Server> Zikhazikiko kasinthidwe.
2. Sankhani ndondomeko chifukwa SQLEXPRESS, ndiye TCP / IP.
3. TCP / IP masiwichi kwa Yambitsani.
4. Sankhani "Katundu", ndiye IP Adresses tsamba.
5. Kenako, kusankha SQL Server Services.
6. Kuyambitsanso ndi SQL Server Services, sankhani kuyambitsanso.

Kenako, muyenera chimathandiza makhoma oteteza opaleshoni dongosolo kuti alandire mauthenga ukubwera. Kuti zimenezi zitheke, tiyenera azichita zinthu zotsatirazi:

1. Kupeza ntchito za makhoma oteteza tingapeze menyu "Start"> "Zida Administrative".
2. Mu makhoma oteteza zenera, kusankha Malamulo inbound.
3. Kenako, kusankha Port.
4. Ndiye muyenera mwachindunji TCP ndi nambala yake lolingana, mu nkhani iyi 1433.
5. Chotsatira, kusankha Amalola kugwirizana.
6. Mu sitepe yotsatira, mbiri poyera mabokosi onse.
7. Kusankha dzina bwino.

Ngati mwachita molondola, ndi Nawonso achichepere MS SQL Server akhoza kuthamanga kutali.

Malangizo

Akuti mapulogalamu chida ndi mapulogalamu mwachilungamo zovuta. Nawa ochepa nsonga kuti kovuta kugwira ntchito ndi Server mapulogalamu MS SQL:

• Zofooka pamene akugwira 1C ntchito kwa m'Mabaibulo ena, kotero isanafike kukhazikitsa dongosolo ayenera kulongosola nkhani ya mapulogalamu interoperability.
• Ngati inu kuthamanga Nawonso achichepere mu Baibulo kenako, inu simungakhoze kuyenda pa Mabaibulo kale.
• Ngati mukufuna kutumiza makina ntchito zingapo mwa ndikupeleka wosakwatiwa, m'pofunika mwachindunji mtundu olondola a ndikupeleka. Kuchita izi, ndi bwino anapereka mode kuti basi kudziwa ndikupeleka: Ikani IMPLICIT_TRANSACTIONS WOZIMITSA.
• Ngati pulogalamu amapanga kulakwitsa pamene zinasokoneza makompyuta angapo, izo zimatanthauza kuti owona Nawonso achichepere Mabaibulo atakwatirana. Mu nkhani iyi, Nawonso achichepere akulu ayenera kusintha kwa Baibulo ina.
• Kudziwa njira ya Nawonso achichepere pitani pa mbewa batani bwino ndi kusankha "Katundu."

m'malo mapeto

Panopa zinasokoneza makompyuta ubale ntchito pafupifupi mabungwe onse kuti kukhazikitsa masitolo yaikuluikulu. Yogawa lonse pulogalamu amapereka kutukula ndi inalimbikitsidwa kwambiri chitukuko, kotero kuti iwo akuimilira dziko chaka chilichonse koposa bwino Mabaibulo a mapulogalamu ake. Kuuza MS SQL Server ndi 1C kwambiri zimatithandiza mkombero wa mabizinezi ambiri, kuwapulumutsa iwo kuchokera zolembalemba zosafunika. Lokha ankaona mapulogalamu si zovuta kugwiritsa ntchito ndi limalola owerenga msanga kuphunzira zochita zonse otithandiza kugwira ntchito ndi pulogalamu.