Kupititsa patsogolo kwa SQL Server kumapatsa olamulira azinenero kuti azigawira deta kudutsa ma seva ambiri mu bungwe. Mutha kuyanjanitsa ndi bungwe lanu chifukwa cha zifukwa zingapo monga:
- Ikani kusinthanitsa . Kubwereza kukulolani kuti mufalitse deta yanu ku ma seva angapo ndikugawira katundu wofunsira pakati pa ma seva awo.
- Kusinthana kwa intaneti . Kubwereza kumathandizira kusokoneza deta kuchokera ku database yanu pamakina omwe nthawizonse sagwirizana ndi intaneti.
- Kusintha . Kubwereza kukulolani kuti mumange seva yachinsinsi yosawerengeka yomwe ili okonzeka kuthana ndi vuto lokonzekera pakanthawi.
Mkhalidwe uliwonse wobwereza uli ndi zigawo zikuluzikulu ziwiri:
- Ofalitsa ali ndi deta yoti apereke kwa ma seva ena. Ndondomeko yopatsidwa yobwereza ikhoza kukhala ndi ofalitsa limodzi kapena ambiri.
- Olembawo ndi ma seva adiresi omwe akukhumba kulandira zosinthidwa kuchokera kwa Ofalitsa pamene deta isinthidwa.
Palibe chomwe chingalepheretse dongosolo limodzi kuti lichite zinthu zonsezi. Ndipotu, nthawi zambiri izi zimapangidwira machitidwe ambiri omwe akufalitsidwa.
SQL Server Support for Replication
Microsoft SQL Server ikuthandiza mitundu itatu ya kubwereza deta. Nkhaniyi ikufotokozera mwachidule zitsanzo zonsezi, ndipo nkhani zamtsogolo zidzazifufuza mwatsatanetsatane. Ali:
- Kubwereza kwazithunzithunzi kumachitika mwa momwe dzina lake limatanthawuzira. Wofalitsa amangotenga chithunzithunzi cha deta yonse yosinthidwa ndikuyigawa ndi olembetsa. Inde, ino ndi nthawi yochuluka kwambiri komanso yothandizira kwambiri. Pachifukwa ichi, olamulira ambiri samagwiritsa ntchito kufotokozera ndemanga pafupipafupi zomwe zimasintha nthawi zambiri. Pali zochitika ziwiri zomwe kufotokozera mwachidule kumagwiritsidwa ntchito kawirikawiri: Poyamba, imagwiritsidwa ntchito pazithunzi zomwe sizikusintha kawirikawiri. Chachiwiri, chimagwiritsidwa ntchito kukhazikitsa choyambitsirana pofuna kukhazikitsa kuphatikizana pakati pa machitidwe pomwe zosinthidwa zamtsogolo zimayambitsidwa pogwiritsa ntchito zochitika kapena kuphatikiza kufotokozera .
- Kubwereza mwachitsulo kumapereka njira yowonjezera yosinthika kwa ma database omwe amasintha nthawi zonse. Ndi kubwereza kwapadera, wogwira ntchito yobwerezabwereza akuyang'anira wofalitsayo kuti asinthe kusintha ku deta ndikusindikiza kusintha kwa olembetsa. Kutenga kumeneku kungachitike mwamsanga kapena panthawi.
- Kuyanjananso kubwereza kumapangitsa wofalitsa ndi wolembetsa kuti apange yekha kusintha kwa deta. Zipangizo zonsezi zimatha kugwira ntchito popanda kugwiritsidwa ntchito. Pamene abwezeretsanso, wogwirizanitsa kuphatikizapo mawonekedwe akuyang'ana kusintha pazitsulo zonse ziwiri ndikusintha deta iliyonse. Ngati kusintha kusagwirizana, wothandizira amagwiritsa ntchito ndondomeko yothetsera kusamvana kwapadera kuti adziwe deta yoyenera. Kuyanjanitsa kubwereza kumagwiritsidwa ntchito kwambiri ndi ogwiritsa ntchito laputopu ndi ena omwe sangathe kulumikizidwa nthawi zonse kwa wofalitsa.
Njira iliyonse yobwereza izi imathandiza kwambiri ndipo imakhala yoyenera pa zolemba zina.
Ngati mukugwira ntchito ndi SQL Server 2016, sankhani buku lanu malinga ndi zosowa zanu zobwereza. Magazini iliyonse ili ndi mphamvu zokhudzana ndi kubwezeretsa:
- Thandizo lolembetsa lokha : Express, Express ndi Zida kapena Zapangidwe Zapamwamba ndi ma edandanda a Webusaiti amapereka mphamvu zowonjezera zowerengera, zomwe zingathe kukhala ngati kasitomala wobwereza okha.
- Thandizo Lolemba ndi Olembetsa : Standard ndi Enterprise zimapereka chithandizo chokwanira, ndi Enterprise komanso kuphatikizapo Oracle kusindikiza, kuyang'anitsitsa kufotokozeredwa kwa anzawo, ndi kubwereza kwachinsinsi monga kubwereza kosinthika.
Monga momwe mwadzidzidzi mumadziwira pa mfundoyi, mphamvu zowonjezera za SQL Server zimapereka mwayi woyang'anira malo ogwiritsa ntchito chida champhamvu choyang'anira ndi kutsegula zidziwitso mu malo ogulitsa.