Sawubona, Habr! Sisebenza kakhulu Isoftware Yokufuna, futhi kulo nyaka bathengile I-ApexSQL - 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:

I-ApexSQL Qhathanisa - ithuluzi lokuqhathanisa ikhodi ye-SQL, amafayela namafolda. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
I-ApexSQL Decrypt - Ukukhishwa kwekhodi yokusakaza kwezinto ku-SQL Server: izinqubo, imisebenzi, izibangeli kanye nokubukwa. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
I-ApexSQL Thola - ukutholwa kwezimo ze-SQL Server namasevisi ahlobene i-SSRS, i-SSAS ne-SSIS.
I-ApexSQL Refactor - ithuluzi lokuphinda wenze kabusha nokufometha ikhodi ye-SQL. Isebenza njengesandiso se-SSMS noma i-Visual Studio.
Imodeli ye-ApexSQL - ukudala imidwebo yento ye-SQL Server. Isebenza futhi njengesandiso se-SSMS noma i-Visual Studio.
Uhlelo lwe-ApexSQL - ithuluzi lokuthuthukisa izinhlelo zokusebenza. Isebenza futhi njengesandiso se-SSMS.
I-ApexSQL Iqedile — 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.
I-ApexSQL Propagate - ithuluzi lokwenza ikhodi ye-SQL kuzinqolobane eziningana ngesikhathi.
Usesho lwe-ApexSQL - insiza yokusesha idatha nezinto ekujuleni kwe-SQL Server. Isebenza njengesandiso se-SSMS noma i-Visual Studio.
I-ApexSQL DevOps Toolkit — 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.

1. I-ApexSQL Qhathanisa

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 ukwesekwa kokusebenza nge-CLI.

2. ApexSQL Decrypt

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.

3. I-ApexSQL Zitholele

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.

4. I-ApexSQL Refactor

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 incazelo yensiza.

5. Imodeli ye-ApexSQL

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 Ukuhluka и Doc. Usebenzisa umkhiqizo wokuqala, ungaqhathanisa imodeli nesimo samanje kusizindalwazi noma uqhathanise amamodeli esizindalwazi ezimbili ezihlukene, futhi umkhiqizo wesibili uyadingeka ukuze ubhale izinto zesizindalwazi.

6. Uhlelo lwe-ApexSQL

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.

7. I-ApexSQL Iqedile

Ividiyo emfushane mayelana nendlela yokusebenza namandla

Isisheshisi sekhodi. Ku-interface yensiza ungamisa iziteketiso, amazwibela nokugqamisa amakhodi.

8. I-ApexSQL Propagate

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.

9. Usesho lwe-ApexSQL

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.

10. I-ApexSQL DevOps Toolkit

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 izihloko ezithakazelisayo kuma-DevOps endaweni egciniwe.

Manje njengoba sesibhekane nezixazululo zamahhala, sizohlinzeka kafushane uhlu lwezixazululo ezikhokhelwayo, okuyiqiniso, ezinomsebenzi onamandla kakhulu.

I-ApexSQL Audit - ithuluzi lokuhlola imininingwane yolwazi ukuze kuthotshelwe izidingo zokuphepha, kuhl. I-HIPAA, GDPR, PCI isekelwe. Imibiko nokubukwa komlando woshintsho kuyasekelwa.
Buka isithombe-skrini nevidiyo
I-ApexSQL Backup - 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
I-ApexSQL Defrag - insiza yokuqapha nokuphatha ukuhlukaniswa.
Buka isithombe-skrini nevidiyo
Umsebenzi we-ApexSQL - ithuluzi lokuphatha imisebenzi, okuhlanganisa umlando, isimiso kanye nezaziso.
Buka isithombe-skrini
Ilogi ye-ApexSQL — ithuluzi lokufunda ilogu yokwenziwayo ukuze kucwaningwe, kuphindaphindwe noma kubuyiselwe emuva izinguquko.
Buka isithombe-skrini nevidiyo
I-ApexSQL Recover — ukutholwa kwedatha eyonakele, esusiwe noma elahlekile.
Buka isithombe-skrini nevidiyo
I-ApexSQL Hlaziya - ithuluzi lokuhlaziya ubudlelwano kusizindalwazi.
Buka isithombe-skrini nevidiyo
I-ApexSQL Yakha - ithuluzi lokuzenzela isizindalwazi. Ingakwazi ukuxhuma kumasistimu okulawula inguqulo.
Buka isithombe-skrini nevidiyo
I-ApexSQL Enforce - Isithuthukisi sekhodi ye-SQL.
Buka isithombe-skrini nevidiyo
Khiqiza i-ApexSQL iyithuluzi lokukhiqiza izigidi zemigqa yedatha ngokuchofoza okukodwa. Ukuthunyelwa kwedatha yokuhlola ku-SQL, XML, CSV, JSON ne-Excel kuyasekelwa.
Buka isithombe-skrini
I-ApexSQL Mask - ithuluzi lokusesha, ukuhlukanisa kanye nokufihla idatha ebucayi kusizindalwazi. Inamamaski achazwe kusengaphambili angu-220+ kanye nezihlungi ezakhelwe ngaphakathi ezingu-55+ zokuhlukaniswa.
Buka isithombe-skrini
I-ApexSQL Script — ithuluzi lokudala imibhalo ye-DDL ne-DML namaphakheji okufaka asebenzisekayo.
Buka isithombe-skrini nevidiyo
I-ApexSQL Source Control - ithuluzi lokuhlanganisa izinhlelo zokulawula inguqulo ne-SSMS.
Buka isithombe-skrini nevidiyo
I-ApexSQL Trigger - Ukuhlolwa kwedatha kusizindalwazi nokuhunyushelwa ku-DML.
Buka isithombe-skrini nevidiyo
I-ApexSQL Unit Test - 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 ifomu lempendulo kuwebhusayithi yethu.

Uma uxazulula inkinga eyinkimbinkimbi yokuqapha nokuphatha, funda izindatshana zethu ezedlule mayelana ne-Habré:

Gada imininingwane egciniwe ehlukahlukene kusuka kusixhumi esibonakalayo esisodwa.

Hlukanisa ngokushesha izinkinga zokusebenza ku-SQL Server.

Ukuhlolwa kwezinguquko kwingqalasizinda ye-Microsoft (kuhlanganise ne-SQL Server).

Ungakwazi futhi ukubhalisela yethu Ikhasi le-Facebook.

Source: www.habr.com