I-Snapshot Replication kwi-Microsoft SQL Server

I-teknoloji yokuphindaphinda i- SQL yeStel Server ikuvumela ukuba uthumele ngolwazi ngokuzenzekelayo ulwazi phakathi kweenkcukacha ezininzi zeSQL Server . Le teknoloji yindlela enkulu yokuphucula ukusebenza kunye / okanye ukuthembeka kweenkcukacha zakho.

Kukho iindlela ezininzi ongasebenzisa ukuphindaphinda kwe-snapshot kwi-database yakho ye-SQL Server. Ngokomzekelo, ungasebenzisa le teknoloji ukusabalalisa idilesi kwiinkcukacha zolwazi ezifumaneka kumasayithi akude. Oku kuphucula ukusebenza kwabasebenzisi bokugqibela ngokubeka idatha kwindawo yokunxibelelanisa kufuphi nabo kunye nokunciphisa umthwalo kwiinkonzo zenethiwekhi zangaphakathi.

I-Snapshot Replication for Distribution Data

Ungasebenzisa kwakhona ukuphindaphinda kwe-snapshot yokuhambisa idatha kwiinkonzo ezininzi zeenjongo zokulinganisela. Isicwangciso esisodwa sokusasaza sino-database yolwazi esetyenziselwa yonke imibuzo yokubuyiselwa kwaye emva kweenkcukacha ezincinci ezinokufumana i-snapshots kwaye zisetyenziswe kwimodi yokufunda kuphela ukubonelela iinkcukacha kubasebenzisi kunye nezicelo. Ekugqibeleni, ungasebenzisa ukuphindaphinda kwe-snapshot ukuze uhlaziye idatha kwi-server ye-backup ukuba ifakwe kwi-intanethi kwimeko apho umncedisi oyintloko uyaphela.

Xa usebenzisa isicatshulwa se-snapshot, ukopiza yonke i-database kwiShicileli SQL Server kwi-SQL okanye kwi-SQL Server (s) kwixesha elilodwa okanye ngokuphindaphindiweyo. Xa uMbhalisi efumana ukuhlaziywa, ibhala ngaphezulu ikopi yayo yonke idatha kunye nolwazi olufunyenwe kuMshicileli. Oku kungathatha ixesha elide kunye needasethi ezinkulu kwaye kuyimfuneko ukuba uqwalasele ngononophelo ixesha kunye nexesha lokusabalalisa i-snapshot.

Ngokomzekelo, awufuni ukuthumela ii-snapshots phakathi kwamaseva phakathi kwedatha exakekileyo kwi-intanethi ekhululekile. Kuya kuba luncedo kakhulu ukudlulisa ulwazi phakathi kobusuku xa abasebenzisi bekhaya kunye ne-bandwidth ininzi.

Ukuqalisa Ukuphendula Kwesitampu Kwindlela Yokunyathela Kwethathu

  1. Yakha umthubi
  2. Yakha u papasho
  3. Bhalisa kwipapasho

Unokuphinda isinyathelo sokugqibela sokudala umthengi kaninzi kangangoko kuyimfuneko ukudala bonke ababhalisile ongathanda. Ukuphindaphinda kwesitrato yisixhobo esinamandla esikuvumela ukuba udlulise idatha phakathi kofakelo lweSQL Server kwishishini lakho. Abafundi abaqhagamshelwe ngasentla baya kukunceda uqale ukuhambisa idatha kwimiba yeeyure.