Mhoro, Habr! Tinoshanda zvakanyanya ne
Munyaya ino:
ApexSQL Enzanisa - chishandiso chekuenzanisa SQL kodhi, mafaera uye maforodha. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.ApexSQL Decrypt -kuyerera kudhibhisa kwezvinhu muSQL Server: maitiro, mabasa, zvinokonzeresa uye maonero. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.ApexSQL Discover -kuonekwa kweSQL Server mamiriro uye ane hukama masevhisi SSRS, SSAS uye SSIS.ApexSQL Refactor - chishandiso chekugadzirisa uye kufomatisa SQL kodhi. Inoshanda sekuwedzera kweSSMS kana Visual Studio.ApexSQL Model - kugadzira SQL Server chinhu dhayagiramu. Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.ApexSQL Chirongwa - chishandiso chekugadzirisa zvirongwa zveKuuraya. Inoshanda zvakare sekuwedzera kweSSMS.ApexSQL Yakakwana - chishandiso chinopedza otomatiki zvirevo zveSQL uye chinokutendera kuti uwedzere snippets yako (keyboard mapfupi ekugadzirisa otomatiki). Inoshanda zvakare sekuwedzera kweSSMS kana Visual Studio.ApexSQL Propagate - chishandiso chekushandisa SQL kodhi pane akati wandei dhatabhesi panguva.Kutsvaga kweApexSQL - chishandiso chekutsvaga data uye zvinhu zvakadzika zveSQL Server. Inoshanda sekuwedzera kweSSMS kana Visual Studio.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.
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
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
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
Iye zvino zvatakabata nemhinduro dzemahara, tichapa muchidimbu runyoro rwemhinduro dzakabhadharwa, izvo, zvechokwadi, zvine mashandiro ane simba.
ApexSQL Audit - Chishandiso chekuongorora dhatabhesi yekutevedzera zvinodiwa zvekuchengetedza, kusanganisira. HIPAA, GDPR, PCI inotsigirwa. Mishumo uye kuona kwekuchinja kwenhoroondo kunotsigirwa.Ona skrini uye vhidhiyo
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
ApexSQL Defrag - chishandiso chekutarisa uye kugadzirisa defragmentation.Ona skrini uye vhidhiyo
ApexSQL Basa - chishandiso chekugadzirisa mabasa, kusanganisira nhoroondo, hurongwa uye zviziviso.View screenshot
ApexSQL Log - chishandiso chekuverenga iyo dhizaini yekuongorora, kudzokorora kana kudzoreredza shanduko.Ona skrini uye vhidhiyo
ApexSQL Recover - kudzoreredza data rakakuvadzwa, rakadzimwa kana rakarasika.Ona skrini uye vhidhiyo
ApexSQL Ongorora - chishandiso chekuongorora hukama mudhatabhesi.Ona skrini uye vhidhiyo
ApexSQL Kuvaka - chishandiso chekugadzira otomatiki dhatabhesi. Inogona kubatana neshanduro control system.Ona skrini uye vhidhiyo
ApexSQL Enforce - SQL kodhi inovandudza.Ona skrini uye vhidhiyo
ApexSQL Gadzira chishandiso chekugadzira mamirioni emitsara yedata nekudzvanya kumwe chete. Kutumira kunze kwedata rekuyedza kuSQL, XML, CSV, JSON uye Excel kunotsigirwa.View screenshot
ApexSQL Mask - chishandiso chekutsvaga, kurongedza uye kuvharisa data rakavanzika mudhatabhesi. Iine 220+ akafanotsanangurwa masiki uye 55+ akavakirwa-mukati mafirita ekurongedza.View screenshot
ApexSQL Script - chishandiso chekugadzira DDL uye DML zvinyorwa uye zvinogoneka kumisikidza mapakeji.Ona skrini uye vhidhiyo
ApexSQL Source Control - chishandiso chekubatanidza shanduro yekudzora masisitimu neSSMS.Ona skrini uye vhidhiyo
ApexSQL Trigger -Kuongororwa kwedata mudhatabhesi uye kududzira muDML.Ona skrini uye vhidhiyo
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
Kana iwe uri kugadzirisa dambudziko rakaoma rekutarisa uye manejimendi, verenga zvedu zvakapfuura zvinyorwa paHabrΓ©:
Iwe unogona zvakare kunyorera kune yedu
Source: www.habr.com