Sawubona, Habr! Sisebenza kakhulu , futhi kulo nyaka bathengile - umkhiqizi wezixazululo zokuphatha nokuqapha i-Microsoft SQL Server database. E-Russia, kubonakala ngathi, kuncane okwaziwayo ngalaba bafana. Ekhasini eliyinhloko lewebhusayithi yabo babhala "Amathuluzi okubulala we-SQL Server". Kuzwakala kusongela. Sibe nombono wokwethula lo mthengisi futhi sithole ukuthi yini ebulalayo ngezisombululo zabo. Ake siqale ngengxenye ye-hype - imikhiqizo yamahhala. Ngemuva kwabo kuzoba nengxenye emfushane mayelana nemikhiqizo yokuhweba. Ngithemba ukuthi uthola lezi zinhlelo ziwusizo. Ngicela ngaphansi kwekati.
Kule ndatshana:
- - ithuluzi lokuqhathanisa ikhodi ye-SQL, amafayela namafolda. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
- - Ukukhishwa kwekhodi yokusakaza kwezinto ku-SQL Server: izinqubo, imisebenzi, izibangeli kanye nokubukwa. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
- - ukutholwa kwezimo ze-SQL Server namasevisi ahlobene i-SSRS, i-SSAS ne-SSIS.
- - ithuluzi lokuphinda wenze kabusha nokufometha ikhodi ye-SQL. Isebenza njengesandiso se-SSMS noma i-Visual Studio.
- - ukudala imidwebo yento ye-SQL Server. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
- - ithuluzi lokuthuthukisa izinhlelo zokusebenza. Isebenza futhi njengesandiso se-SSMS.
- — ithuluzi liziqedela ngokuzenzakalelayo izitatimende ze-SQL futhi likuvumela ukuthi wengeze amazwibela akho (izinqamuleli zekhibhodi zokuqedela ngokuzenzakalela). Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
- - ithuluzi lokwenza ikhodi ye-SQL kuzinqolobane eziningana ngesikhathi.
- - insiza yokusesha idatha nezinto ekujuleni kwe-SQL Server. Isebenza njengesandiso se-SSMS noma i-Visual Studio.
- — ithuluzi lokudala amapayipi e-CI/CD. Okuwukuphela kwemikhiqizo ebhalwe lapha enekhonsoli yewebhu.
Umkhiqizo ngamunye uyingxenye yokusebenza kwezixazululo ze-ApexSQL ezikhokhelwayo. Ekupheleni kwesihloko sizochaza kafushane ukuthi yiziphi izixazululo zezohwebo abanazo.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Ukuqhathanisa kukuvumela ukuthi uqhathanise amafayela e-SQL Server, amafolda, nezinto. Ukuqhathaniswa kwezinhlangothi ezimbili kanye nokukhiqizwa okuqhubekayo kweskripthi sokuhlanganisa izinto ezihlukene kuyasekelwa. Ku-interface, insiza ingagqamisa i-syntax ye-C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.
Izici ezibalulekile: ukuhlanganiswa ku-SSMS kanye ne-Visual Studio, ukubiza izinto ezivela ezimweni ezahlukene ze-database ukuze ziqhathaniswe ngokuqondile ne-Object Explorer kanye .
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Ku-Decrypt, kusukela kusixhumi esibonakalayo se-SSMS noma se-Visual Studio, ungakwazi ukususa ukubhala ngekhodi inqubo, umsebenzi, ukucupha noma ubuke ngokuchofoza okukodwa.
Kusixhumi esibonakalayo ungabuka iskripthi sokususa ukubethela se-DDL. Ukuxhumeka ngesikhathi esisodwa kuzimo eziningi ze-SQL Server kuyasekelwa.
Khomba izimo ezikhona ze-SQL Server, SSRS, SSAS kanye nezinsizakalo ze-SSIS ngobubanzi bekheli le-IP futhi ubuke imininingwane enemininingwane.
Kusuka kusixhumi esibonakalayo ungamisa ukutholwa kwedathabhethi ohlelweni. I-ApexSQL Discover ingathumela izaziso ezinemiphumela yokutholwa nge-imeyili.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Ukufometha kwekhodi kungenziwa ngokusekelwe kuphrofayela esebhokisini noma ungenza ngokwezifiso eyakho ukuze ikhodi ibukeke ijwayeleke kakhulu kuwe. I-Refactor ingagqamisa okuguquguqukayo okungasetshenzisiwe kukhodi, ihlanganise amabhulokhi ekhodi ibe yizinqubo, futhi inwebe okuthi “*” ibe uhlu oluphelele.
Isici esisodwa esiwusizo ukuhlukaniswa kwetafula ukuze kuhlukaniswe amakholomu asetshenziswa kancane. I-Refactor izobika izinto ezizothinteka kulokhu kuhlukaniswa.
Futhi ku-interface ye-Refactor ungashintsha ngokuphepha amagama ezinto ngenkathi ushintsha konke okuncikile.
Lezi kanye neminye imisebenzi ingatholakala ngokuningiliziwe ekhasini nge .
Insiza ibona ngeso lengqondo izinto ze-SQL Server nobudlelwano phakathi kwazo. Ku-interface efanayo, ungashintsha ukucushwa kwezinto futhi ukhiqize ikhodi ye-DDL ehambisanayo. Konke okubukwayo kungathunyelwa njengezithombe.
Ukusebenza kwemodeli kunwetshwa ngosizo lwemikhiqizo yokuhweba и . Usebenzisa umkhiqizo wokuqala, ungaqhathanisa imodeli nesimo samanje kusizindalwazi noma uqhathanise amamodeli esizindalwazi ezimbili ezihlukene, futhi umkhiqizo wesibili uyadingeka ukuze ubhale izinto zesizindalwazi.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Leli ithuluzi lokuthuthukisa ukusebenza. Futhi, usebenzisa i-ApexSQL Plan, ungathumela amapulani emibikweni ngamafomethi e-HTML ne-XML. Icala elisetshenziswa kaningi lalolu hlelo lokusebenza liyisiqhathaniso sohlelo lwamanje kanye nolunye olulungiswe ngokuya ngezici ezahlukahlukene.
I-ApexSQL Plan isekela ukulanda kusuka esitolo semibuzo futhi yethule izici zale mibuzo ngendlela yamadeshibhodi.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Isisheshisi sekhodi. Ku-interface yensiza ungamisa iziteketiso, amazwibela nokugqamisa amakhodi.
Ku-ApexSQL Propagate, ungalungiselela ukukhishwa kwekhodi kusizindalwazi esihlukahlukene se-SQL Server futhi unqume ukuhleleka kokwenziwa.
Imiphumela yekhodi ekhishiwe icutshungulwa ngokusetshenziswa futhi irekhodwe ukuze ibukwe kalula imiphumela yokubulawa.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Ithuluzi isesha isakhiwo sesizindalwazi. Kusuka lapha ungaqamba kabusha ngokuphephile izinto futhi ulandelele ubudlelwano bazo. Imiphumela yosesho ithunyelwa ku-HTML, CSV kanye ne-Excel.
Ividiyo emfushane mayelana nendlela yokusebenza namandla
Ikhodi ye-PowerShell isebenza ngaphansi kwe-hood yohlelo lokusebenza. Yakha, Buyekeza, Idokhumenti kanye Nokuphakelwa kuyatholakala kumthuthukisi kusukela kusixhumi esibonakalayo se-ApexSQL DevOps Toolkit. Lapha ungakwazi ukukhiqiza idatha yokwenziwa, uqalise ngokuzenzakalelayo ukuhlola kweyunithi, kanye nezinguquko zedokhumenti. Ingaxhunywa njenge-plugin ku-TeamCity, Jenkins nabanye.
Isisekelo solwazi se-ApexSQL sinalo kuma-DevOps endaweni egciniwe.
Manje njengoba sesibhekane nezixazululo zamahhala, sizohlinzeka kafushane uhlu lwezixazululo ezikhokhelwayo, okuyiqiniso, ezinomsebenzi onamandla kakhulu.
- - ithuluzi lokuhlola imininingwane yolwazi ukuze kuthotshelwe izidingo zokuphepha, kuhl. I-HIPAA, GDPR, PCI isekelwe. Imibiko nokubukwa komlando woshintsho kuyasekelwa.
Buka isithombe-skrini nevidiyo
- - okuzenzakalelayo kokwenza izipele ezikhuphukayo, izingodo zokuthengiselana kanye nezipele ezigcwele. Ukubuyisela endaweni ethile ngesikhathi kuyasekelwa, ungakha izifanekiso zokudala izipele futhi ulungiselele kalula izinhlelo zokulondoloza.
Buka isithombe-skrini nevidiyo
- - insiza yokuqapha nokuphatha ukuhlukaniswa.
Buka isithombe-skrini nevidiyo
- - ithuluzi lokuphatha imisebenzi, okuhlanganisa umlando, isimiso kanye nezaziso.
Buka isithombe-skrini
- — ithuluzi lokufunda ilogu yokwenziwayo ukuze kucwaningwe, kuphindaphindwe noma kubuyiselwe emuva izinguquko.
Buka isithombe-skrini nevidiyo
- — ukutholwa kwedatha eyonakele, esusiwe noma elahlekile.
Buka isithombe-skrini nevidiyo
- - ithuluzi lokuhlaziya ubudlelwano kusizindalwazi.
Buka isithombe-skrini nevidiyo
- - ithuluzi lokuzenzela isizindalwazi. Ingakwazi ukuxhuma kumasistimu okulawula inguqulo.
Buka isithombe-skrini nevidiyo
- - Isithuthukisi sekhodi ye-SQL.
Buka isithombe-skrini nevidiyo
- iyithuluzi lokukhiqiza izigidi zemigqa yedatha ngokuchofoza okukodwa. Ukuthunyelwa kwedatha yokuhlola ku-SQL, XML, CSV, JSON ne-Excel kuyasekelwa.
Buka isithombe-skrini
- - ithuluzi lokusesha, ukuhlukanisa kanye nokufihla idatha ebucayi kusizindalwazi. Inamamaski achazwe kusengaphambili angu-220+ kanye nezihlungi ezakhelwe ngaphakathi ezingu-55+ zokuhlukaniswa.
Buka isithombe-skrini
- — ithuluzi lokudala imibhalo ye-DDL ne-DML namaphakheji okufaka asebenzisekayo.
Buka isithombe-skrini nevidiyo
- - ithuluzi lokuhlanganisa izinhlelo zokulawula inguqulo ne-SSMS.
Buka isithombe-skrini nevidiyo
- - Ukuhlolwa kwedatha kusizindalwazi nokuhunyushelwa ku-DML.
Buka isithombe-skrini nevidiyo
- - ithuluzi lokuqhuba ukuhlolwa kweyunithi ngqo kusuka kukhonsoli ye-SSMS.
Buka isithombe-skrini nevidiyo
Bhala emazwaneni ukuthi imaphi amathuluzi okucwaninga nokuphathwa kwesizindalwazi osuvele uwasebenzisa nokuthi yiziphi izinkinga ozixazulula ngazo.
Ukuze ubuze imibuzo mayelana nemikhiqizo ye-ApexSQL, thola imikhiqizo yokuthengisa ezohlolwa, noma uthole intengo, shiya isicelo kuso .
Uma uxazulula inkinga eyinkimbinkimbi yokuqapha nokuphatha, funda izindatshana zethu ezedlule mayelana ne-Habré:
Ungakwazi futhi ukubhalisela yethu .
Source: www.habr.com