I-DbVisualizer - ithuluzi elihle kakhulu lokuphatha ama-DB ahlukahlukene

I-DbVisualizer yimenenja ephelele yemininingwane enezici ezinembile futhi isekela amapulatifomu ohlobo lwe-DB amaningi.

Es ithuluzi ledatha lomhlaba wonke labathuthukisi, ama-DBA nabahlaziyi, selokhu yabhalwa kwiJava ingasetshenziswa kuzo zonke izinhlelo zokusebenza ezinkulu nokufinyelela ezinhlwini zolwazi ezahlukahlukene.

Isibonelo (i-Oracle, i-SQL Server, i-DB2, iSybase, i-MySQL, i-SQLite) nakuzo zonke izinhlelo ezinkulu zokusebenza (iWindows, iMac OS, iLinux / i-Unix, njll.)

Mayelana ne-DBVisualizer

Inikeza isikhombimsebenzisi esibonakalayo esilula futhi esinamandla ngokusekelwa kwamamodeli ahlukahlukene wedatha. Iphinde isekele ukuxhumeka ngasikhathi sinye okuvumela ukuhlola nokuphatha izinto, ukwenza usesho lwe-SQL noma imininingwane yokubuka.

Leli thuluzi konke okukodwa liyithuluzi ledatha lomhlaba wonke labathuthukisi, abaphathi bedatha nabahlaziyi.

Yisixazululo esifanelekile, njengoba ithuluzi elifanayo lingasetshenziswa kuwo wonke amasistimu amakhulu wokusebenza afinyelela kulwazi oluningi.

Nge-DBVisualizer, uzoba nezici eziningi onazo, kufaka phakathi:

• Ukusekelwa okugcwele kwemininingwane kanye nezinhlelo zokusebenza
• Ukuphathwa kwento yedatha
• Ithebula lokuphathwa kwedatha
• Thumela izinto zedatha kanye nedatha yetafula
• Ukuthekelisa nokungenisa izilungiselelo zomsebenzisi kukuvumela ukuthi uthuthe kalula wonke amasethingi aye kwenye ikhompyutha noma i-akhawunti yomsebenzisi.
• Manje isekela amaphethini wokuthekelisa achazwe umsebenzisi.
• Ukutholwa okuzenzakalelayo kohlobo lwedatha etafuleni lokungenisa idatha.
• Ukudalwa okusha kwe-Trigger ne-Edishini: isisetshenziswa se-Oracle, i-DB2 ye-LUW, iMimer, iPostgreSQL, iSybase ASE, iSQL Server, i-MySQL, i-JavaDB / iDerby ne-Informix.
• Okusha, dala, hlela futhi uhlanganise: inqubo, umsebenzi, imodyuli, iphakheji nezinto zephakeji yohlelo lokusebenza lweCorpo e-Oracle, DB2 ye-LUW, Mimer, PostgreSQL, Sybase ASE, SQL Server, MySQL, JavaDB / Derby ne-Informix.
• Umsebenzi we-schema Export / Database ukuvumela ukuthekelisa i-DDL yezinto ze-schema, kufaka phakathi idatha yetafula ngefomethi ye-SQL noma ye-XML. Lokhu kungasetshenziselwa ukwakha kabusha noma ukuhambisa izinto kwenye iseva yedatha.
• Ifomethi ye-SQL enezinketho ezintsha.
• Ukusekelwa komaka bepharamitha.
• Ukusekelwa okungeziwe kokubuka nokuphatha iShejuli e-Oracle.

Ungayifaka kanjani iDbVisualizer kuLinux?

Si unentshisekelo yokukwazi ukufaka leli thuluzi elihle kusistimu yakho, Sizokuchazela ukuthi ungakwenza kanjani ngaphakathi kokusatshalaliswa kwe-Linux.

I-Debian, Ubuntu kanye nokuphuma

Abasebenzisi banoma ikuphi kwalokhu kusatshalaliswa ngokusekelwa kwamaphakeji wesikweletu, Bazokwazi ukufaka iDbVisualizer kumasistimu abo ngosizo lwephakheji elandelayo yedeb.

Sizovula i-terminal kuhlelo futhi kuyo sizothayipha umyalo olandelayo:

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

Lapho ifayela le-deb selilandiwe, ungafaka le phakheji kusistimu yakho ngosizo lomphathi wephakheji oyithandayo noma yenza ukufakwa kusuka esigungwini ngomyalo olandelayo:

sudo dpkg -i DbVisualizer.deb

Uma kwenzeka unezinkinga ngokuncika, lokhu kuzixazulula nge:

sudo apt -f install

I-RHEL, i-CentOS, i-Fedora, ne-OpenSUSE

Inqubo yokufaka kulezi zinhlelo ifana neyangaphambilini, lapha kuphela sizolanda iphakethe le-RPM elihambisanayo lohlelo lwethuNgakho-ke, noma yikuphi ukusatshalaliswa ngokusekelwa kwamaphakeji we-RPM kungenza lolu hlobo lokufaka.

Sizovula i-terminal futhi kuyo kufanele bathayiphe:

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

Lapho ukulanda sekuphelile, siqhubeka ukufaka iphakheji ngomyalo olandelayo:

sudo rpm -i DbVisualizer.deb

Okunye ukusatshalaliswa kwe-Linux

Kuko konke ukusatshalaliswa kwe-Linux, ungafaka lolu hlelo lokusebenza ngokulanda iskripthi sokufaka.

Ngakho-ke kufanele bavule i-terminal futhi kuyo sizothayipha umyalo olandelayo:

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

Lapho ukulanda sekuphelile, sizonikeza izimvume zokwenza lo mbhalo nge:

sudo chmod a+x dbvis_linux_10_0_15.sh

Futhi ngokuhamba kwesikhathi singaqalisa ukwenziwa kwalo mbhalo ohlelweni lwethu ukusebenzisa isifaki sohlelo lokusebenza ngomyalo olandelayo:

./dbvis.sh

Futhi ngokuyisisekelo inikeza "okulandelayo", "okulandelayo" no "okulandelayo".