MS SQL Server: shigarwa da kuma sanyi. Version na MS SQL Server. MS SQL Server da kuma 1C

MS SQL Server ne a database management system data daga cikin sanannun a Microsoft. A samfurin ne sosai m da ake amfani da matsayin manyan masana'antu da kamfanonin, da kuma daidaikun mutane. Yana yanzu ko'ina amfani da database, da bi, da bukatar da shirin ci gaba da girma. Ci gaban da samfurin ya fara a shekarar 1985, kuma tun daga nan wani sabon version zo daga kowace shekara, developers suna gabatar da sabon amfani fasali da kuma cire unneeded haihuwa.

Tarihi, 90s

1989 - da haske ya bayyana da farko version na software kayan aiki, da hadin gwiwa na kungiyar na Microsoft da kuma kamfanin Ashton-Tate. The aikin bai sami da sa ran shahararsa. Da fari dai, masu amfani da samfurin zai yi canzawa zuwa wani tsarin aiki. Na biyu, da lokacin da fafatawa a gasa su iya haifar da SUDB tare da fadi aiki.

1990 - fitarwa version MS SQL Server 1.1. The aikin damar da sabon version ya ba yawa daban-daban daga baya daya (da aikin tare da bayanai, da SQL harshen support), amma da yawa daga kurakurai da lahani da aka gyara.

1993 - kusan lokaci guda tare da saki da sabon tsarin aiki bayyana SQL Server for Windows NT, muhimmanci m ga ta fafatawa a gasa a yi.

1995 - Fita Microsoft SQL Server 6.0, na farko samfurin saki dabam daga Sybase (kamfanoni tare da Microsoft da aka tasowa software tun 1987). A sanarwar da aka sosai nasara.

1998 - Las Vegas, wani sabon version na SQL Server 7.0. Mutane da yawa shortcomings kuma yi inganta aka gyara. Wannan sigar da aka tsara don manyan hukumomi da cewa aiki tare da manyan yawa na bayanai.

Tarihi, 2000

1999 - da haske ya bayyana MS SQL Server 2000 version ɓullo da a karkashin wannan tsarin aiki. Version da yawa fiye da ayyuka fiye da na baya daya. Daga gare su, da sabon Hanyar samun bayanan dawo da lissafi mai tsauri, da sabon engine (wanda ya buɗe sama da sabuwar dama ga ci gaban).

2003 - halittar MS SQL Server 2005. Wannan saki ƙwarai simplifies database ci gaba, bugun sama da aiki tare da manyan girma na bayanai da kuma fita tare da gyara kurakurai da suke a baya versions.

2008 - Ana zargin wani sabon version na shirin. A gaskiya, shi ne mafi aikin version of MS SQL Server 2005. Babu manyan canje-canje a cikin wannan version ba.

yanzu

A 2010, da hannu version of Karamin 4.0 da aka sanar. Version bukatar wani shigarwa da kuma shi ne mai jituwa tare da dandamali, kamar da API, kuma NET Tsarin, Kayayyakin aikin hurumin 2010. A 2014, masu amfani da sabon version ya zama akwai. Da yawa da hankali ne ya biya domin kara m girma databases (har zuwa daruruwan terabytes), kasuwanci da hankali. Akwai ma aukuwa ga bayar da rahoton a cikin database sarari. A na gaba version na samfurin za a kira SQL Server 2016, da kuma yanzu aiki ta ci gaba ne da za'ayi.

shigarwa

Kafin fara da kafuwa, tabbatar da duba da tsarin da bukatun. Mafi qarancin haka:

• Processor - Intel (ko m) Pentium III 1000MHz ko mafi girma.
• RAM - 512 MB ko fiye.
• Hard faifai sarari - 20 GB ko fiye.

Nagari tsarin bukatun:

• Processor - Intel Core i7 3000 MHz ko mafi girma.
• RAM 4 GB ko fiye.
• Hard faifai sarari ya kamata a tsakanin 100 GB ko fiye.

Idan kwamfuta a kan abin da za ka shigar da shirin, hadu da sama da bukatun, ka shirya don shigar. Girkawa MS SQL Server ba ma rikitarwa da kuma ba ya bambanta daga al'ada shigarwa shirye-shirye a kan Windows. Akwai wasu rarrabe fasali da aka bayyana a cikin wannan labarin.

1. Don fara kana bukatar ka gudu da saitin fayil a matsayin mai gudanarwa (dole ka danna kan fayil, danna-dama kuma zaɓi "Run a matsayin shugaba").
2. "Installation Center" da window yana buɗewa. Yana zabi da sashe "Planning", inda da kwamfuta sanyi da aka tabbatar.
3. Idan duk ke da kyau, a cikin wannan taga, zaɓi "Saita" a cikin samarwa jerin, zaɓi na farko abu, wanda mun ba da shawara shigar da software ko ƙara sabon fasali zuwa gare shi.
4. Shigar da ake bukata key (yawanci shi aka rubuta a cikin akwatin tare da software).
5. Yarda da sharuddan da aka bayyana a cikin lasisi, kuma Ya sa wata kaska a dace wuri.
6. Sa'an nan danna "Shigar" button.
7. Zabar aka gyara shigar.
8. Zaɓi "Default misali".

Domin hazaƙar aiki, da software kayayyakin aiki, wajibi ne don saita kafin shigarwa. A babi na gaba zai dubi yadda za a yi.

gyara

Harhadawa MS SQL Server da aka yi kafin shigarwa. Saboda haka, a lokacin da kafa rumfunan zama musamman da hankali, saboda wasu sanyi zažužžukan zai zama ba zai yiwu ba ga canja bayan da kafuwa.

1. A cikin "Server Kanfigareshan" Mun tambayi a zabi irin sabis (ta atomatik, ko da hannu). A duk sabis fãce Full Text Filter Daemon gabatarwa, zaɓi "Auto". Danna "Next."
2. A sashen da ake kira "Server Kanfigareshan" babu bukatar canza wani abu, haka kuma mun danna "Next."
3. A cikin "Database Engine Kanfigareshan", zaɓi "Mixed Mode" kuma saita sunan mai amfani da kuma kalmar sirri gudanarwa. A wannan taga, zuwa shafin "Data Saraka". Saita akwai hanya inda fayilolin da za a adana a cikin database. Danna Next.
4. Akwai hanyoyi da tsoho saitin (na farko abu).
5. A rahoton kuskure saituna taga, zaɓi ko shirin za ta atomatik aika da wani rahoto ga Microsoft kuskure don inganta software.

A shigarwa da kuma saitin an kammala, shirin ya shirya don aiki.

Saita M Access

Ka yi la'akari da kafa wani hanya zuwa shirin ga m damar. Wannan yanayin ne da amfani idan kungiyar na shirin da aka shigar a kan fiye da daya kwamfuta. Bayan installing da software, MS SQL Server, yi da wadannan:

1. A cikin "Fara" menu, zaɓi "All Programs"> MS SQL Server> Kanfigareshan saituna.
2. Zabi ladabi ga SQLEXPRESS, sa'an nan TCP / IP.
3. TCP / IP sauya to Enable.
4. Zaɓi "Properties", sa'an nan IP Adresses tab.
5. Next, zaɓi SQL Server Services.
6. Sake kunna SQL Server Services, zaži sake kunnawa.

Next, dole ne ka taimaka wa Firewall tsarin aiki don samun sakonni masu shigowa. Don wannan karshen, mu gudanar da wadannan ayyuka:

1. Damar yin amfani da ayyuka na Firewall, za mu iya samu a cikin menu "Fara"> "Gudanarwa Tools".
2. A Firewall taga, zaɓi Inbound Dokokin.
3. Next, zaɓi Port.
4. Sa'an nan kuma ka bukatar ka saka TCP da kuma ta m yawan, a cikin wannan yanayin 1433.
5. A mataki na gaba, zaɓi Izinin da connection.
6. A mataki na gaba, Profile bijirar duk da kwalaye.
7. Akwai hanyoyi da dama da sunan.

Idan yi daidai, da MS SQL Server database za a iya gudu mugun.

m alamu

Dauke software kayan aiki ne mai fairly rikitarwa software. Ga 'yan tips cewa zai sa shi sauki don aiki tare da MS SQL Server software:

• Gazawa a lõkacin da aiki tare da 1C shafi wasu versions, don haka kafin aiwatar da tsarin kamata bayyana batun software interoperability.
• Idan ka gudu da database a cikin wani daga baya version, ba za ka iya gudu da shi a kan baya versions.
• Idan kana so ka aika zuwa uwar garken da dama ayyuka a cikin guda ma'amala, ya zama dole to saka da daidai da irin ma'amala. Don yin wannan, yana da kyau domin saita yanayin zuwa ta atomatik ƙayyade da ma'amala: SET IMPLICIT_TRANSACTIONS KASHE.
• Idan shirin ya haifar da wani kuskure a lokacin da mahara databases, yana nufin cewa da database fayiloli ne m versions. A wannan yanayin, mazan database dole maida su a baya version.
• Don sanin hanyar da database click a dama linzamin kwamfuta button kuma zaɓi "Properties."

maimakon a ƙarshe

A halin yanzu, da zumunci databases an yi amfani da kusan dukkan kungiyoyi da cewa bukatar haifar da manyan da kananan Stores. A fadi da rarraba wannan software ba developers mai girma impetus ga ci gaba, saboda haka cewa suna wakiltar duniya a kowace shekara fiye da kuma mafi ingantattun iri na software. Raba MS SQL Server da kuma 1C ƙwarai simplifies da sake zagayowar na da yawa kasuwanci, ceton su daga ba dole ba paperwork. Kanta dauke da software ba ma wuya yin amfani da damar masu amfani don sauri koyi duk asali ayyuka da ake bukata domin yin aiki tare da shirin.