DbVisualizer - chishandiso chakanakisa chekugadzirisa akasiyana maDB

DbVisualizer ndeye yakazara dhatabhesi maneja ane intuitive maficha uye inotsigira akawanda DB mhando mapuratifomu.

Es a universal database chishandiso chevagadziri, DBAs uye vaongorori, kubvira zvanyorwa paJava inogona kushandiswa mune ese makuru masisitimu anoshanda uye kuwana kune akasiyana dhatabhesi.

Semuenzaniso (Oracle, SQL Server, DB2, Sybase, MySQL, SQLite) uye pane ese makuru mashandiro ekushandisa (Windows, Mac OS, Linux / Unix, nezvimwewo)

Nezve DBVisualizer

Iyo inopa yakapusa uye ine simba interface ine rutsigiro rwemhando dzakasiyana dhatabhesi. Iyo zvakare inotsigira kubatana panguva imwe chete iyo inobvumidza kuongorora uye kugadzirisa zvinhu, kuitisa SQL kutsvaga kana kuona ruzivo.

Ichi chese-mu-chimwe chishandiso chiri chepasirese dhatabhesi chishandiso chevagadziri, vatariri ve database, uye vaongorori.

Iyo ndiyo mhinduro kwayo, sezvo chishandiso chimwe chete chinogona kushandiswa pane ese makuru mashandiro esisitimu anowana akasiyana siyana dhatabhesi.

Uine DBVisualizer, uchave nezvakawanda zvaunogona, zvinosanganisira:

• Rutsigiro ruzere rwematafura uye masisitimu anoshanda
• Dhatabhesi chinhu manejimendi
• Dhata manejimendi tafura
• Export dhatabhesi zvinhu uye tafura data
• Kuburitsa uye kupinza marongero emushandisi zvinokutendera kuti utamire zvirinani zvigadziriso kuenda kune imwe komputa kana account yemushandisi.
• Ikozvino inotsigira mushandisi yakatsanangurwa yekunze maitiro.
• Otomatiki kuona kweiyo data mhando mune iyo data yekungenisa tafura.
• Nyowani Trigger Kugadzira uye Edhisheni: sosi yeOracle, DB2 yeLUW, Mimer, PostgreSQL, Sybase ASE, SQL Server, MySQL, JavaDB / Derby uye Informix.
• Nyowani, gadzira, gadzira uye nyora: maitiro, basa, module, package uye zvinhu zveiyo Corpo application package muOracle, DB2 yeLUW, Mimer, PostgreSQL, Sybase ASE, SQL Server, MySQL, JavaDB / Derby uye Informix.
• A schema Export / Dhatabhesi basa rinokutendera kuti ubudise iyo DDL yezvinhu zve schema, kusanganisira tafura data mune SQL kana XML fomati. Izvi zvinogona kushandiswa kuvaka kana kufambisa zvinhu pane imwe dura re database.
• SQL fomati ine sarudzo itsva.
• Tsigiro yemamaki eparamende.
• Yekuwedzera rutsigiro rwekutarisa uye kugadzirisa iyo scheduler muOracle.

Maitiro ekuisa DbVisualizer paLinux?

Si Uri kufarira here kugona kuisa ichi chishandiso chikuru pane yako system, Tichazotsanangura kuti ungazviita sei mukati mekugovera kwako Linux.

Debian, Ubuntu uye zvigadzirwa

Vashandisi vechero ipi yeizvi zvekugovera nerutsigiro rwezvikwereti zvemadhiri, Ivo vanozogona kuisa DbVisualizer pane avo masisitimu nerubatsiro rweinotevera dhiza package.

Tichavhura terminal mune ino system uye mairi tinonyora unotevera kuraira:

wget -O DbVisualizer.deb http://www.dbvis.com/product_download/dbvis-10.0.15/media/dbvis_linux_10_0_15.deb

Kamwe iyo dhi faira rave kurodha pasi, unogona kuisa iyi package pane yako system nerubatsiro rweyaunofarira package package kana ita iyo yekuisirwa kubva kune iyo terminal neinotevera kuraira:

sudo dpkg -i DbVisualizer.deb

Kana paine matambudziko nezvinotsamira, izvi zvinozvigadzirisa ne:

sudo apt -f install

RHEL, CentOS, Fedora, uye vhuraSUSE

Maitiro ekumisikidza pane aya masisitimu akafanana neayo apfuura, chete pano isu tichaenda kurodha pasi inoenderana RPM package yeedu systemNaizvozvo, chero kugoverwa nerutsigiro rweRPM mapakeji kunogona kuita iyi mhando yekumisikidza.

Tichavhura terminal uye mairi vanofanira kunyora:

wget -O DbVisualizer.rpm http://www.dbvis.com/product_download/dbvis-10.0.15/media/dbvis_linux_10_0_15.rpm

Kana kurodha pasi kwaitwa, isu tinoenderera mberi nekuisa iyo package pamwe nemirairo inotevera:

sudo rpm -i DbVisualizer.deb

Zvimwe zvekuparadzirwa kweLinux

Kune mamwe ese ekuparadzirwa kweLinux, unogona kuisa iyi kunyorera nekuodha pasi yekumisikidza script.

Saka ivo vanofanirwa kuvhura terminal uye mairi tichaenda kutaipa unotevera kuraira:

wget http://www.dbvis.com/product_download/dbvis-10.0.15/media/dbvis_linux_10_0_15.sh

Kana kurodha pasi kwaitwa, isu tichaenda kupa iyi mvumo yekushandisa script ne:

sudo chmod a+x dbvis_linux_10_0_15.sh

Uye gare gare isu tinokwanisa kuitisa kuisirwa kwescript ino pane yedu system kumhanyisa iyo yekuisa yekuisa nemutemo unotevera:

./dbvis.sh

Uye chaizvo iri kupa "inotevera", "inotevera" uye "inotevera".