Mhoro, Habr! Tinoshanda zvakanyanya ne Kutsvaga Software, uye gore rino vakatenga ApexSQL - mugadziri wemhinduro dzekutonga nekutarisa Microsoft SQL Server dhatabhesi. MuRussia, zvinoratidzika kwatiri, zvishoma zvinozivikanwa pamusoro pevarume ava. Papeji guru rewebhusaiti yavo vanonyora "Killer zvishandiso zveSQL Server". Inonzwika kutyisidzira. Isu takanga tine pfungwa yekusuma mutengesi uyu uye kuona kuti chii chinouraya pamusoro pemhinduro dzavo. Ngatitange neiyo hype chikamu - zvigadzirwa zvemahara. Mushure mezvo pachava nechikamu chiduku pamusoro pezvigadzirwa zvekutengesa. Ndinovimba unowana aya mapurogiramu anobatsira. Ndapota pasi pekati.

Munyaya ino:

1. ApexSQL Enzanisa - chishandiso chekuenzanisa SQL kodhi, mafaera uye maforodha. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.
2. ApexSQL Decrypt -kuyerera kudhibhisa kwezvinhu muSQL Server: maitiro, mabasa, zvinokonzeresa uye maonero. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.
3. ApexSQL Discover -kuonekwa kweSQL Server mamiriro uye ane hukama masevhisi SSRS, SSAS uye SSIS.
4. ApexSQL Refactor - chishandiso chekugadzirisa uye kufomatisa SQL kodhi. Inoshanda sekuwedzera kweSSMS kana Visual Studio.
5. ApexSQL Model - kugadzira SQL Server chinhu dhayagiramu. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.
6. ApexSQL Chirongwa - chishandiso chekugadzirisa zvirongwa zveKuuraya. Inoshanda zvakare sekuwedzera kweSSMS.
7. ApexSQL Yakakwana - chishandiso chinopedza otomatiki zvirevo zveSQL uye chinokutendera kuti uwedzere snippets yako (keyboard mapfupi ekugadzirisa otomatiki). Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.
8. ApexSQL Propagate - chishandiso chekushandisa SQL kodhi pane akati wandei dhatabhesi panguva.
9. Kutsvaga kweApexSQL - chishandiso chekutsvaga data uye zvinhu zvakadzika zveSQL Server. Inoshanda sekuwedzera kweSSMS kana Visual Studio.
10. ApexSQL DevOps Toolkit - chishandiso chekugadzira mapaipi eCI/CD. Iyo chete yezvigadzirwa zvakanyorwa pano ine web console.

Chigadzirwa chega chega chikamu chekushanda kweakabhadharwa ApexSQL mhinduro. Pakupera kwechinyorwa tichatsanangura muchidimbu kuti ndezvipi zvigadziriso zvekutengesa zvavanazvo.

1. ApexSQL Enzanisa

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

Kuenzanisa kunoita kuti uenzanise SQL Server mafaera, maforodha, uye zvinhu. Bidirectional kuenzanisa uye imwezve chizvarwa che script yekubatanidza zvinhu zvakasiyana inotsigirwa. Mune iyo interface, iyo yekushandisa inogona kusimbisa syntax yeC #, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.

Akakosha maficha: kubatanidzwa muSSMS uye Visual Studio, kudaidza zvinhu kubva akasiyana dhatabhesi zviitiko kuenzanisa zvakananga kubva kuObject Explorer uye. rutsigiro rwekushanda kuburikidza neCLI.

2. ApexSQL Decrypt

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

MuDecrypt, kubva kuSSMS kana Visual Studio interface, unogona decrypt maitiro, basa, trigger kana kuona nekudzvanya kumwe chete.

Mune iyo interface iwe unogona kuona iyo DDL decryption script. Panguva imwe chete yekubatanidza kune dzakawanda zviitiko zveSQL Server inotsigirwa.

3. ApexSQL Ziva

Ziva zviitiko zviripo zveSQL Server, SSRS, SSAS uye SSIS masevhisi neIP kero renji uye tarisa ruzivo rwakadzama.

Kubva pane interface iwe unogona kugadzirisa kuwanikwa kwedhatabhesi pane hurongwa. ApexSQL Discover inogona kutumira zviziviso zvine mibairo yekuwanikwa neemail.

4. ApexSQL Refactor

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

Kugadzira kodhi kunogona kuitwa zvichibva pabhokisi rebhokisi kana iwe unogona kugadzirisa yako kuitira kuti kodhi iite seyakajairwa kwauri. Refactor inogona kusimbisa zvisingashandiswe akasiyana mukodhi, encapsulate kodhi mabhuraki kuita maitiro, uye kuwedzera "*" mune yakazara runyorwa.

Chimwe chinhu chinobatsira kupatsanura tafura kuparadzanisa makoramu mashoma anoshandiswa. Refactor inoshuma zvinhu zvichakanganiswa nekupatsanurwa uku.

Zvakare muRefactor interface unogona kushandura zvakachengeteka mazita ezvinhu uchichinja zvese zvinoenderana.

Aya nemamwe mabasa anogona kuwanikwa mune zvakadzama pane peji ne tsananguro yezvishandiso.

5. ApexSQL Model

Iyo yekushandisa inoona SQL Server zvinhu uye hukama pakati pavo. Mune imwechete interface, iwe unogona kushandura kugadziridzwa kwezvinhu uye kugadzira inoenderana DDL kodhi. Zvese zvinoonekwa zvinogona kutumirwa kunze semifananidzo.

Basa remuenzaniso rinowedzerwa nerubatsiro rwezvigadzirwa zvekutengesa Chipenga и Doc. Uchishandisa chigadzirwa chekutanga, unogona kuenzanisa modhi nemamiriro azvino mudhatabhesi kana kuenzanisa mamodheru maviri akasiyana dhatabhesi, uye yechipiri chigadzirwa chinodiwa kunyora zvinyorwa zvedhatabhesi.

6. ApexSQL Plan

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

Ichi chishandiso chekuita optimization. Zvakare, uchishandisa ApexSQL Plan, unogona kutumira zvirongwa kune mishumo muHTML uye XML mafomati. Kakawanda kushandiswa kwechiitiko ichi kuenzanisa kwehurongwa hwazvino uye imwe yakagadziridzwa zvinoenderana neakasiyana maitiro.

ApexSQL Plan inotsigira kudhawunirodha kubva muchitoro chemubvunzo uye kuratidza maitiro eiyi mibvunzo nenzira yemadhibhodhi.

7. ApexSQL Yakwana

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

Code accelerator. Mune yekushandisa interface iwe unogona kugadzirisa aliases, snippets uye kodhi ratidziro.

8. ApexSQL Propagate

MuApexSQL Propagate, unogona kugadzirisa kuurayiwa kwekodhi pane akasiyana SQL Server dhatabhesi uye kuona kurongeka kwekuita.

Mhedzisiro yekodhi yakatemerwa inopatsanurwa neutility uye inorekodhwa kuti ionekwe nyore kwemhedzisiro yekuuraya.

9. ApexSQL Search

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

Chishandiso chinotsvaga dhizaini chimiro. Kubva pano iwe unogona kutumidza zvinhu zvakachengeteka uye kuteedzera hukama hwavo. Mhinduro dzekutsvaga dzinotumirwa kune HTML, CSV uye Excel.

10. ApexSQL DevOps Toolkit

Vhidhiyo pfupi nezve maitiro ekushanda uye kugona

PowerShell kodhi inomhanya pasi pehodhi yekushandisa. Vaka, Ongorora, Gwaro uye Deploy zviripo kune mugadziri kubva kuApexSQL DevOps Toolkit interface. Pano iwe unogona kugadzira data rekugadzira, mhanyisa mayunitsi bvunzo, uye zvinyorwa shanduko. Inogona kubatanidzwa se plugin kuTeamCity, Jenkins nevamwe.

Iyo ApexSQL ruzivo base ine nyaya dzinonakidza paDevOps munzvimbo yedatabase.

Iye zvino zvatakabata nemhinduro dzemahara, tichapa muchidimbu runyoro rwemhinduro dzakabhadharwa, izvo, zvechokwadi, zvine mashandiro ane simba.

1. ApexSQL Audit - Chishandiso chekuongorora dhatabhesi yekutevedzera zvinodiwa zvekuchengetedza, kusanganisira. HIPAA, GDPR, PCI inotsigirwa. Mishumo uye kuona kwekuchinja kwenhoroondo kunotsigirwa.

   Ona skrini uye vhidhiyo
   
   

   
2. ApexSQL Backup - otomatiki yekugadzira yakawedzera backups, transaction logs uye yakazara backups. Dzosera kune imwe nzvimbo panguva inotsigirwa, unogona kugadzira matemplate ekugadzira mabhapu uye nekugadzirisa zvirongwa zvekuchengetedza.

   Ona skrini uye vhidhiyo
   
   

   
3. ApexSQL Defrag - chishandiso chekutarisa uye kugadzirisa defragmentation.

   Ona skrini uye vhidhiyo
   
   

   
4. ApexSQL Basa - chishandiso chekugadzirisa mabasa, kusanganisira nhoroondo, hurongwa uye zviziviso.

   View screenshot
   

5. ApexSQL Log - chishandiso chekuverenga iyo dhizaini yekuongorora, kudzokorora kana kudzoreredza shanduko.

   Ona skrini uye vhidhiyo
   
   

   
6. ApexSQL Recover - kudzoreredza data rakakuvadzwa, rakadzimwa kana rakarasika.

   Ona skrini uye vhidhiyo
   
   

   
7. ApexSQL Ongorora - chishandiso chekuongorora hukama mudhatabhesi.

   Ona skrini uye vhidhiyo
   
   

   
8. ApexSQL Kuvaka - chishandiso chekugadzira otomatiki dhatabhesi. Inogona kubatana neshanduro control system.

   Ona skrini uye vhidhiyo
   
   

   
9. ApexSQL Enforce - SQL kodhi inovandudza.

   Ona skrini uye vhidhiyo
   
   

   
10. ApexSQL Gadzira chishandiso chekugadzira mamirioni emitsara yedata nekudzvanya kumwe chete. Kutumira kunze kwedata rekuyedza kuSQL, XML, CSV, JSON uye Excel kunotsigirwa.

    View screenshot
    

11. ApexSQL Mask - chishandiso chekutsvaga, kurongedza uye kuvharisa data rakavanzika mudhatabhesi. Iine 220+ akafanotsanangurwa masiki uye 55+ akavakirwa-mukati mafirita ekurongedza.

    View screenshot
    

12. ApexSQL Script - chishandiso chekugadzira DDL uye DML zvinyorwa uye zvinogoneka kumisikidza mapakeji.

    Ona skrini uye vhidhiyo
    
    

    
13. ApexSQL Source Control - chishandiso chekubatanidza shanduro yekudzora masisitimu neSSMS.

    Ona skrini uye vhidhiyo
    
    

    
14. ApexSQL Trigger -Kuongororwa kwedata mudhatabhesi uye kududzira muDML.

    Ona skrini uye vhidhiyo
    
    

    
15. ApexSQL Unit Test - chishandiso chekumhanyisa unit bvunzo zvakananga kubva kuSSMS console.

    Ona skrini uye vhidhiyo
    
    

    

Nyora mune zvakataurwa kuti ndeapi maturusi ekuongorora uye dhatabhesi manejimendi aunotoshandisa uye ndeapi matambudziko aunogadzirisa nawo.

Kubvunza mibvunzo nezve zvigadzirwa zveApexSQL, gamuchira zvigadzirwa zvekutengesa zvekuyedzwa, kana kuziva mutengo, siya chikumbiro kuna mhinduro fomu pane yedu webhusaiti.

Kana iwe uri kugadzirisa dambudziko rakaoma rekutarisa uye manejimendi, verenga zvedu zvakapfuura zvinyorwa paHabré:

Tarisa akasiyana dhatabhesi kubva kune imwechete interface.

Kurumidza kuparadzanisa matambudziko ekuita muSQL Server.

Ongororo yekuchinja muMicrosoft infrastructure (kusanganisira SQL Server).

Iwe unogona zvakare kunyorera kune yedu Facebook peji.

Source: www.habr.com