Molo, Habr! Sisebenza kakhulu kunye Isoftware yokufuna, yaye kulo nyaka baye bathenga ApexSQL — umenzi wezisombululo zokulawula nokubeka iliso koovimba beenkcukacha zeseva ye-Microsoft SQL. ERashiya, kubonakala ngathi, incinci iyaziwa malunga naba bafana. Kwiphepha eliphambili lewebhusayithi yabo babhala "Izixhobo zokubulala kwi-SQL Server". Ivakala isoyikiso. Sasinombono wokwazisa lo mthengisi kwaye sifumanise ukuba yintoni ebulalayo malunga nezisombululo zabo. Masiqale ngenxalenye ye-hype - iimveliso zasimahla. Emva kwabo kuya kuba nenxalenye emfutshane malunga neemveliso zorhwebo. Ndiyathemba ukuba uya kufumana ezi nkqubo ziluncedo. Nceda phantsi kwekati.

Kule nqaku:

1. ApexSQL Thelekisa - isixhobo sokuthelekisa ikhowudi yeSQL, iifayile kunye neefolda. Isebenza njengokwandiswa kwe-SSMS okanye i-Visual Studio.
2. ApexSQL Decrypt - Ukukhutshwa kwe-decryption yezinto kwi-SQL Server: iinkqubo, imisebenzi, izinto ezibangela kunye neembono. Isebenza njengokwandiswa kwe-SSMS okanye i-Visual Studio.
3. ApexSQL Fumana - ukufunyanwa kweemeko ze-SQL Server kunye neenkonzo ezinxulumene ne-SSRS, i-SSAS kunye ne-SSIS.
4. I-ApexSQL Refactor - isixhobo sokwenza ngokutsha kunye nokufomatha ikhowudi yeSQL. Isebenza njengokwandiswa kweSSMS okanye iVisual Studio.
5. Imodeli ye-ApexSQL -Ukudala imizobo yento ye-SQL Server. Isebenza njengokwandiswa kwe-SSMS okanye i-Visual Studio.
6. Isicwangciso se-ApexSQL -isixhobo sokwenza izicwangciso zokufezekisa. Isebenza kwakhona njengokwandiswa kwe-SSMS.
7. I-ApexSQL iGqibile — isixhobo sizigqibezela ngokuzenzekelayo iingxelo zeSQL kwaye sikuvumela ukuba wongeze iziqwengana zakho (iindlela ezimfutshane ze-keyboard zokuzigqibezela). Isebenza njengokwandiswa kwe-SSMS okanye i-Visual Studio.
8. ApexSQL Yandisa - isixhobo sokwenza ikhowudi yeSQL kuluhlu lweenkcukacha ezininzi ngexesha.
9. Uphendlo lwe-ApexSQL - into eluncedo yokukhangela idatha kunye nezinto kubunzulu be-SQL Server. Isebenza njengokwandiswa kweSSMS okanye iVisual Studio.
10. I-ApexSQL DevOps Toolkit — isixhobo sokwenza imibhobho yeCI/CD. Ikuphela kwemveliso edweliswe apha inekhonsoli yewebhu.

Imveliso nganye iyinxalenye yokusebenza kwezisombululo ze-ApexSQL ezihlawulweyo. Ekupheleni kwenqaku siza kuchaza ngokufutshane ukuba zeziphi izisombululo zorhwebo abanazo.

1. I-ApexSQL Thelekisa

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Ukuthelekisa kukuvumela ukuba uthelekise iifayile ze-SQL, iifolda, kunye nezinto. Uthelekiso lwe-Bidirectional kunye nokuveliswa okuqhubekayo kweskripthi sokudibanisa izinto ezahlukeneyo kuyaxhaswa. Kwi-interface, i-utility inokugqamisa i-syntax ye-C #, C ++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.

Iimpawu eziphambili: ukudityaniswa kwi-SSMS kunye ne-Visual Studio, ukubiza izinto ezivela kwiimeko ezahlukeneyo zedatha yokuthelekisa ngokuthe ngqo kwi-Object Explorer kunye inkxaso yokusebenza nge-CLI.

2. ApexSQL Decrypt

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Kwi-Decrypt, ukusuka kwi-SSMS okanye kwi-Visual Studio interface, unokuyicoca inkqubo, umsebenzi, ukuqalisa okanye ukujonga ngocofa nje olunye.

Kujongano ungajonga i-DDL yeskripthi sokuntsonkotha. Uqhagamshelo ngaxeshanye kwiimeko ezininzi ze-SQL Server ziyaxhaswa.

3. ApexSQL Fumana

Chonga iimeko ezikhoyo ze-SQL Server, SSRS, SSAS kunye neenkonzo ze-SSIS ngoluhlu lweedilesi ze-IP kwaye ujonge ulwazi oluneenkcukacha.

Ukusuka kujongano ungaqwalasela ukufunyanwa kwedatha kwishedyuli. I-ApexSQL Discover ingathumela izaziso ngeziphumo zokufunyanwa nge-imeyile.

4. I-ApexSQL Refactor

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Ukufomatha ikhowudi kunokwenziwa ngokusekwe kwiprofayile yebhokisi okanye unokwenza eyakho ukuze ikhowudi ibonakale iqhelekile kuwe. I-Refactor inokugqamisa iinguqu ezingasetyenziswanga kwikhowudi, ifake iibhloko zekhowudi kwiinkqubo, kwaye yandise "*" kuluhlu olupheleleyo.

Olunye uphawu oluluncedo kukwahlulwa kwetafile ukwahlula imiqolo esetyenziswa kancinane. I-Refactor iya kuxela izinto eziya kuchaphazeleka kolu lwahlulo.

Kwakhona kwi-interface ye-Refactor ungatshintsha ngokukhuselekileyo amagama ezinto ngelixa utshintsha zonke izinto ezixhomekeke kuyo.

Le kunye neminye imisebenzi inokufumaneka kwiinkcukacha ezithe vetshe kwiphepha nge inkcazo yosetyenziso.

5. Umzekelo we-ApexSQL

Umsebenzi ubonisa izinto ze-SQL Server kunye nobudlelwane phakathi kwazo. Kwi-interface efanayo, unokutshintsha ukucwangciswa kwezinto kwaye uvelise ikhowudi ye-DDL ehambelanayo. Yonke imibono inokuthunyelwa ngaphandle njengemifanekiso.

Ukusebenza kwemodeli kwandiswa ngoncedo lweemveliso zorhwebo Uluhlu и Doc. Ukusebenzisa imveliso yokuqala, unokuthelekisa imodeli kunye nemeko yangoku kwisiseko sedatha okanye uthelekise iimodeli zeenkcukacha ezimbini ezahlukeneyo, kwaye imveliso yesibini iyadingeka ukuze kubhalwe izinto zesiseko sedatha.

6. Isicwangciso se-ApexSQL

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Esi sisixhobo sokuphucula ukusebenza. Kwakhona, usebenzisa iSicwangciso se-ApexSQL, unokuthumela iiplani kwiingxelo kwiifom ze-HTML kunye ne-XML. Imeko yokusetyenziswa rhoqo kwesi sixhobo kukuthelekisa isicwangciso sangoku kwaye enye iguqulwe ngokweempawu ezahlukeneyo.

Isicwangciso se-ApexSQL sixhasa ukukhutshelwa kwivenkile yombuzo kunye nokubonisa iimpawu zale mibuzo ngendlela yeedeshibhodi.

7. I-ApexSQL iGqibile

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Ikhowudi yokunyusa isantya. Kwi-interface esebenzayo ungaqwalasela iziteketiso, iziqwengana kunye nokuqaqambisa ikhowudi.

8. ApexSQL Propagate

Kwi-ApexSQL Propagate, ungaqwalasela ukuphunyezwa kwekhowudi kwiinkcukacha ezahlukeneyo ze-SQL Server kwaye umisele umyalelo wokuphunyezwa.

Iziphumo zekhowudi eyenziweyo zicazululwa ngokusetyenziswa kwaye zirekhodwa ukuze zijongwe ngokulula kwiziphumo zokwenziwa.

9. Ukukhangela kwe-ApexSQL

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Isixhobo sikhangela ubume besiseko sedatha. Ukusuka apha unokuthiya ngokutsha ngokukhuselekileyo izinto kwaye ulandelele ubudlelwane bazo. Iziphumo zokukhangela zithunyelwa ngaphandle kwi-HTML, CSV kunye ne-Excel.

10. I-ApexSQL DevOps Toolkit

Ividiyo emfutshane malunga nendlela yokusebenza kunye nobuchule

Ikhowudi ye-PowerShell isebenza phantsi kwe-hood yosetyenziso. Yakha, uPhononongo, uXwebhu kunye noFakelo ziyafumaneka kumphuhlisi ukusuka kwi-interface ye-ApexSQL DevOps Toolkit. Apha uyakwazi ukuvelisa idatha yokwenziwa, yenza uvavanyo lweyunithi ngokuzenzekelayo, kunye notshintsho lwamaxwebhu. Inokudityaniswa njengeplagin kwiTeamCity, Jenkins nabanye.

Isiseko solwazi se-ApexSQL sinalo amanqaku anomdla kwi-DevOps kwindawo yedatha.

Ngoku ukuba sijongene nezisombululo zamahhala, siza kubonelela ngokufutshane uluhlu lwezisombululo ezihlawulwayo, ngokuqinisekileyo, zinomsebenzi onamandla ngakumbi.

1. Uphicotho lwe-ApexSQL — isixhobo sophicotho lweenkcukacha zolwazi ukuze kuthotyelwe iimfuno zokhuseleko, kubandakanywa. I-HIPAA, i-GDPR, i-PCI ixhaswa. Iingxelo kunye nokujongwa kwembali yotshintsho ziyaxhaswa.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

2. Ugcino lwe-ApexSQL -Automation yokudala ii-backups ezongeziweyo, iilog zentengiselwano kunye nee-backups ezigcweleyo. Ukubuyisela kwindawo ethile ngexesha lixhaswa, unokwenza iitemplates zokudala ii-backups kwaye ulungelelanise izicwangciso zokugcina.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

3. ApexSQL Defrag -isixhobo sokubeka iliso kunye nokulawula ukuqhawuka.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

4. Umsebenzi we-ApexSQL - isixhobo sokulawula imisebenzi, kubandakanya imbali, ishedyuli kunye nezaziso.

   Jonga umfanekiso wekhusi
   

5. Ilog yeApexSQL — isixhobo sokufunda ilog yetransekshini ukwenzela uphicotho, ukuphindaphinda okanye ukubuyisela umva utshintsho.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

6. Ukubuyisela kwakhona i-ApexSQL — ukubuyiswa kwedatha eyonakeleyo, ecinyiweyo okanye elahlekileyo.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

7. ApexSQL Hlalutya - isixhobo sokuhlalutya ubudlelwane kwisiseko sedatha.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

8. ApexSQL Yakha - isixhobo sokwenza isiseko sedatha ngokuzenzekelayo. Inokuqhagamshela kwiinkqubo zolawulo loguqulelo.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

9. Ukunyanzeliswa kwe-ApexSQL - Umphuculi wekhowudi yeSQL.

   Jonga umfanekiso weskrini kunye nevidiyo
   
   

10. ApexSQL Yenza sisixhobo sokuvelisa izigidi zemiqolo yedatha ngonqakrazo olunye. Ukuthunyelwa kwedatha yovavanyo kwi-SQL, XML, CSV, JSON kunye ne-Excel ixhaswa.

    Jonga umfanekiso wekhusi
    

11. Imaski ye-ApexSQL - isixhobo sokukhangela, ukwahlula kunye nokufihla idatha ebuthathaka kwisiseko sedatha. Ine-220+ yeemaski ezichazwe kwangaphambili kunye ne-55+ yokucoca eyakhelwe-ngaphakathi yokuhlela.

    Jonga umfanekiso wekhusi
    

12. I-ApexSQL Script - isixhobo sokwenza imibhalo ye-DDL kunye ne-DML kunye neepakethe zokufakela eziphunyeziweyo.

    Jonga umfanekiso weskrini kunye nevidiyo
    
    

13. Ulawulo lweMthombo lwe-ApexSQL -isixhobo sokudibanisa iinkqubo zolawulo lwenguqulelo kunye ne-SSMS.

    Jonga umfanekiso weskrini kunye nevidiyo
    
    

14. I-ApexSQL Trigger — ukuphicothwa kwedatha kuvimba weenkcukacha nokuguqulelwa kwi-DML.

    Jonga umfanekiso weskrini kunye nevidiyo
    
    

15. Uvavanyo lweYunithi ye-ApexSQL -isixhobo sokuqhuba iimvavanyo zeyunithi ngokuthe ngqo kwi-console ye-SSMS.

    Jonga umfanekiso weskrini kunye nevidiyo
    
    

Bhala kwizimvo ukuba zeziphi izixhobo zophicotho-zincwadi kunye nolawulo lwesiseko sedatha osele uzisebenzisa kwaye zeziphi iingxaki ozisombulula ngazo.

Ukubuza imibuzo malunga neemveliso ze-ApexSQL, ukufumana iimveliso zorhwebo zokuvavanya, okanye ukufumana ixabiso, shiya isicelo ifomu yempendulo kwiwebhusayithi yethu.

Ukuba usombulula ingxaki entsonkothileyo yokubeka iliso kunye nolawulo, funda amanqaku ethu angaphambili kuHabré:

Beka iliso koovimba beenkcukacha ezahlukeneyo kujongano olunye.

Yahlula ngokukhawuleza iingxaki zentsebenzo kwi-SQL Server.

Uphicotho lweenguqu kwiziseko zoncedo zikaMicrosoft (kuquka i-SQL Server).

Ungabhalisela yethu Iphepha likaFacebook.

umthombo: www.habr.com