MS SQL Server: rakibaadda iyo qaabeynta. Version of MS SQL Server. MS SQL Server iyo 1C

MS SQL Server waa nidaamka xogta maamulka database ka si fiican u yaqaan ee Microsoft. Shayga waa cammiran oo waxaa loo isticmaalaa sida a shirkadaha warshadaha waaweyn, iyo shaqsiyaadka. Waxaa hadda loo database, siday u kala horreeyaan, baahida loo qabo barnaamij ay sii kordheysay. Horumarinta ee alaabta bilaabay sannadkii 1985, ka dibna tan iyo version cusub sannad kasta soo baxa, horumarinta waxaa soo bandhigid qaababka cusub oo waxtar leh iyo saaro baahnayn jir.

History, 90s

1989 - nuurka u muuqataa version ugu horeysay ee qalab software ah, horumarinta wadajirka ah ee Microsoft iyo shirkadda Ashton-Tate. Mashruuca ayaa laga helay dadka la filayo. Marka hore, ee dadka isticmaala ee alaabta lahaa in ay u baddashaan nidaamka qalliinka kale. Second, by markii ugu tartameen ay awoodaan si ay u abuuraan SUDB la shaqeynayaan ballaadhan.

1990 - version saarka MS SQL Server 1.1. The awoodaha functional version cusub ma ahayn wax badan ka duwan mid ka mid ah hore (shaqada la xogta, taageero SQL luqadda), laakiin wax badan oo ka mid ah khaladaadka iyo cilladaha lagu saxo.

1993 - ku dhowaad isku mar la sii daayo of nidaamka cusub ee hawlgalka u muuqataa Server SQL for Windows NT, si weyn uga sareynay tartanka qaab ciyaareed.

1995 - Exit Microsoft SQL Server 6.0, wax soo saarka ugu horeysay la sii daayay si gooni gooni ah ka Sybase (shirkadaha oo Microsoft waxaa horumarinta software tan iyo 1987-kii). Shaacinta uu ahaa mid aad u guulaystay.

1998 - Las Vegas, version cusub oo SQL Server 7.0. ceebaha badan iyo hagaajinta qaab ayaa loo saxo. version Tani waxaa loo qoondeeyey in shirkadaha waaweyn in la xaddi badan oo data shaqeeyaan.

History, 2000

1999 - nuurka u muuqataa MS SQL Server 2000 version horumariyo hoos nidaam la mid ah hawlgalka. Version lahaa shaqeynayaan badan in ka badan hal hore. iyaga ka mid ah, habka cusub ee ay helaan algorithms kabashada xogta, engine cusub (taas oo albaabka u furtaa fursadaha cusub ee loogu talagalay horumarinta).

2003 - Abuurista Server SQL MS 2005. sii daayo Tani si weyn nayaa horumarka database, dedejiyo shaqada la mugga weyn oo ah macluumaad iyo u soo baxay la qalad saxo ku jiray nuquladii hore.

2008 - Xaaladan of version cusub ee barnaamijka. Dhab ahaantii, waa version ah oo dheeraad ah functional of Server SQL MS 2005. Ma jiraan wax isbeddel weyn ka version this ma.

jooga

Sanadkii 2010, waxaa ku dhawaaqay version mobile ah Compact 4.0. Version u baahan tahay rakibaadda lahayn oo waa la jaan dhufto ee sida API ah, iyo Framework NET, Visual Studio 2010. In 2014, dadka isticmaala of version cusub noqday heli karo. dareenka badan waxaa la siiyaa la kordhiyo database-mugga iman kara (ilaa boqolaal terabytes), sirdoonka ganacsiga. Waxaa sidoo kale jira horumar in ay soo sheegaan in meel database ah. version The soo socda ee alaabta ah waxaa loogu yeedhi doonaa Server SQL 2016 iyo haatan waa ay horumarka waa firfircoon.

rakibaadda

Ka hor inta aadan bilaabin rakibo, hubi inaad hubiso shuruudaha nidaamka. Ugu Yar soo socota:

• Processor - Intel (ama la jaan) Pentium III 1000MHz ama wax ka sareeya.
• RAM - 512 MB ama in ka badan.
• meel disk adag - 20 GB ama in ka badan.

shuruudaha nidaamka lagu talinayo:

• Processor - Intel Core i7 3000 MHz ama wax ka sareeya.
• RAM 4 GB ama in ka badan,
• meel disk adag waa inuu u dhexeeyo 100 GB ama in ka badan.

Haddii computer ka kaas oo aad ku rakibi barnaamijka, buuxiyo shuruudaha kor ku xusan, aad diyaar u ah inay rakibi. Ku xiridda MS SQL Server ma aha inay aad u adag oo kama duwana barnaamijyada rakibo caadiga on Windows. Waxaa jira qaar ka mid ah muuqaalada kala yihiin in lagu tilmaamay in this article.

1. Si aad u bilowdo inaad u baahan tahay in uu ordo file Mudanayaasha sida maamule (aad leedahay si aad riix on file ah, xaq-riix iyo doortaan "Run sida maamulaha").
2. "Xarunta Rakibaadda" furmo suuqa furmo. Waxaa dooran qaybta "Planning", halkaas oo qaabeynta computer la xaqiijin.
3. Haddii dhan si wanaagsan u dhaco, in uu furmo suuqa la mid ah, dooro "Setup" in liiska la soo jeediyay, dooro shayga ugu horeeyay, taas oo aan soo jeedin si loo soo dajiyo software ama ku dar qaababka cusub in ay.
4. Ku qor muhiim ah loo baahan yahay (sida caadiga ah, waxaa ku qoran sanduuqa la software).
5. Aqbalaan shuruudaha ku qeexan liisanka, oo sax ah meesha ku haboon.
6. Ka dibna riix "Ku rakib" badhanka.
7. Doorashada qaybaha si loo soo dajiyo.
8. Dooro "Default Darajada".

Waayo, qaab si mug leh, qalab software lagama maarmaanka ah si reserved ka hor inta rakibaadda. cutubka xiga eegi doonaa sida loo sameeyo.

sixitaanka

Configuring Server SQL MS waxaa loo sameeyaa ka hor inta aan loo xirxiro. Sidaa darteed, marka aasaasidda taribuunka si gaar ah taxaddar, sababta oo ah qaar ka mid ah xulashada habka qaabeynta noqon doontaa wax aan macquul aheyn in la beddelo ka dib markii la rakibey.

1. In the "haggaajin Server" Waxaan ka codsaday in ay doortaan nooca adeegga (si toos ah ama gacanta). On oo dhan marka laga reebo adeegyada Filter Text Full Daemon Launcher, dooro "Auto". Riix "Next."
2. In qaybta loo yaqaan "Server-haggaajin" looma baahna in la beddelo wax, si mar kale aan guji "Next."
3. In the "Database-haggaajin Engine", dooro "Mode Mixed" iyo u dhigay, magacaaga iyo isgarad-maamulka. In uu furmo suuqa la mid ah, tag tab ah "Data Tusiyayaasha". halkaas oo jidka meesha faylasha lagu kaydin doonaa si ay u database ah. Guji Next.
4. Doorashada goob caadiga ah (wax ugu horeysay).
5. Suuqa kala goobaha warbixin qalad, dooro in barnaamijka si toos ah warbixin u baadi Microsoft soo diri doonaa si loo hagaajiyo software ah.

The rakibaadda iyo Mudanayaasha la dhamaystiro, barnaamijka ayaa diyaar u ah in ay ka shaqeeyaan.

Reserved Helitaanka Remote

Tixgeli dejinta hab lagu barnaamijka helitaanka fog. Habkaani waa mid waxtar leh haddii urur ee barnaamijka waxa lagu xiraa in ka badan hal computer. Ka dib markii ay ku rakibidda software ah, MS SQL Server, sameeyo waxa soo socda:

1. In the "Start" menu, dooro "All Programs"> MS SQL Server> goobaha haggaajin.
2. Dooro Protocols for SQLEXPRESS, ka dibna TCP / IP.
3. TCP / IP daaro si loo sahlo.
4. Dooro "Properties", ka dibna IP ku cibro tab.
5. Next, dooro Services Server SQL.
6. Guuleysatey SQL Server Adeegyada, dooro qeybtii labaad.

Next, waa in aad awood nidaamka hawlgalka brannmur si ay u helaan farriimaha soo socda. Si taas loo gaaro, waxaan u fuliyaan tallaabooyinka soo socda:

1. Helitaanka hawlaha firewall, waxaan ka heli kartaa menu "Start"> "Tools Maamulka".
2. Daaqadda Brannmur ah, dooro Rules Inbound.
3. Next, dooro Port.
4. Markaas waxaad u baahan tahay sheeg TCP iyo tiro u dhiganta, kiiskan 1433.
5. Tallaabada xigta, dooro ogolow xidhiidhka ka.
6. In tallaabada xigta, profile soo bandhigaan dhammaan sanduuqyada.
7. Doorashada magaca saxda ah.

Haddii si sax ah u samaysay, ee database MS SQL Server la fog ordi karaan.

tilmaamo waxtar leh

qalab software loo tixgeliyaa waa software si caddaalad ah u adag. Halkan waxaa ku qoran dhowr talooyin ka dhigi doonaa in ay u fududahay in ay la software Server SQL MS shaqeeyaan:

• Xudduudka marka la 1C shaqeeya khuseeyaan versions qaar ka mid ah, sidaas darteed ka hor hirgalinta nidaamka waa in la caddeeyo arrinta interoperability software.
• Haddii aad database ee version ah ka dib, waxaad u ordi karaa qoraalkii hore.
• Haddii aad rabto in aad si server u diri hawlo dhowr ah gudahood hal macaamil ganacsi ah, waxaa lagama maarmaan ah in la qeexo nooca saxda ah ee macaamilka. Si arrintan loo sameeyo, waxaa fiican in loo sameeyo hab si toos ah loo ogaado macaamil: IMPLICIT_TRANSACTIONS SET OFF.
• Haddii barnaamijka abuuraa qalad markii database-badan, waxaa loola jeedaa in files database waa versions leheyn. Xaaladdan oo kale, database wayn waa in loogu badalo si version dambe.
• Si loo go'aamiyo Jidka database ee click on badhanka mouse xaq u dooro "Properties."

halkii ay ka gunaanad

Currently, database-xidhiidh waxaa loo isticmaalaa in dhammaan ururada u baahan tahay si ay u abuuraan dukaamada waaweyn iyo kuwo yaryar. Qaybinta balaadhan oo ah software this siinaysaa horumarinta wadadii weyn horumarka, si ay u matalaan dunida sanad walba iyo aad u badan oo hagaagay versions of ay software. Wadaagista Server SQL MS iyo 1C si weyn nayaa wareegga ah ee shirkado badan, iyaga badbaadiya ka waraaqaha loo baahnayn. Laftiisa loo arko software ah ma aha mid aad u adag tahay in aad isticmaasho oo saamaxaya kuwa isticmaala inay si deg deg ah wax ku bartaan oo dhan tallaabooyinka aasaasiga ah ee looga baahan yahay la barnaamijka ka shaqeeya.