I-DbVisualizer-sisixhobo esihle sokulawula ii-DBs ezahlukeneyo

I-DbVisualizer ngumphathi wedatha ebanzi eneempawu ezinomdla kwaye ixhasa amaqonga ohlobo lwe-DB.

Es isixhobo solwazi jikelele sabaphuhlisi, ii-DBA kunye nabahlalutyi, okoko yabhalwa kwiJava inokusetyenziswa kuzo zonke iinkqubo eziphambili zokusebenza kunye nokufikelela kuluhlu olubanzi lolwazi.

Umzekelo (i-Oracle, iSQL Server, i-DB2, iSybase, i-MySQL, i-SQLite) nakuzo zonke iinkqubo ezinkulu zokusebenza (iWindows, iMac OS, iLinux / iUnix, njl.

Malunga ne-DBVisualizer

Inika ujongano olulula nolomeleleyo ngenkxaso yemodeli ezahlukeneyo zedatha. Ikwaxhasa unxibelelwano ngaxeshanye oluvumela ukuphonononga nokulawula izinto, ukwenza uphando lwe-SQL okanye ukubonisa ulwazi.

Esi sixhobo sonke-in-esinye sisixhobo sedatha kwindawo yonke yabaphuhlisi, abalawuli beenkcukacha kunye nabahlalutyi.

Sisisombululo esifanelekileyo, njengoko isixhobo esinye sinokusetyenziswa kuzo zonke iinkqubo ezinkulu zokusebenza ezifikelela kuluhlu olubanzi lolwazi.

Nge-DBVisualizer, uya kuba nezinto ezininzi onazo, kubandakanya:

• Idatha epheleleyo kunye nenkxaso yenkqubo yokusebenza
• Ulawulo lwezinto zedatha
• Itafile yolawulo lwedatha
• Ukuthumela ngaphandle izinto zedatha kunye nedatha yetafile
• Ukuthumela ngaphandle nokungenisa useto lomsebenzisi kukuvumela ukuba uhambise ngokulula zonke iisetingi kwenye ikhomputha okanye iakhawunti yomsebenzisi.
• Ngoku ixhasa iipateni ezichaziweyo zokuthumela ngaphandle komsebenzisi.
• Ukufunyanwa okuzenzekelayo kohlobo lwedatha kwitafile yokungenisa idatha.
• Indalo entsha yokuDala kunye noHlelo: isibonelelo se-Oracle, i-DB2 ye-LUW, iMimer, iPostgreSQL, iSybase ASE, iSQL Server, i-MySQL, iJavaDB / iDerby kunye ne-Informix.
• Entsha, yenza, uhlele kwaye uqokelele: inkqubo, umsebenzi, imodyuli, iphakheji kunye nezinto zephakeji yesicelo seCorpo kwiOracle, DB2 yeLUW, iMimer, iPostgreSQL, iSybase ASE, iSQL Server, i-MySQL, iJavaDB / iDerby kunye ne-Informix.
• Umsebenzi we-schema Export / Database uvumela ukuba uthumele ngaphandle i-DDL yezinto ze-schema, kubandakanya idatha yetafile kwifomathi ye-SQL okanye ye-XML. Oku kunokusetyenziselwa ukwakha okanye ukuhambisa izinto kwenye indawo yedatha.
• Ifomathi ye-SQL enokhetho olutsha.
• Inkxaso yabamakishi beparameter.
• Inkxaso eyongezelelweyo yokujonga kunye nokulawula iShedyuli kwiOracle.

Uyifaka njani i-DbVisualizer kwiLinux?

Si unomdla wokuba ukwazi ukufaka esi sixhobo sikhulu kwinkqubo yakho, Siza kuchaza ukuba ungayenza njani ngaphakathi kolwabiwo lweLinux.

I-Debian, Ubuntu kunye neziphumo

Abasebenzisi balo naluphi na olu lonikezelo ngenkxaso yeephakeji zetyala, Bazokwazi ukufaka i-DbVisualizer kwiinkqubo zabo besebenzisa le phakheji ilandelayo yedebhu.

Siza kuvula i-terminal kwaye siza kuchwetheza lo myalelo ulandelayo:

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

Nje ukuba ifayile ye-deb ikhutshelwe, ungayifaka le phakheji kwinkqubo yakho ngoncedo lomphathi wephakheji oyikhethileyo okanye yenza ufakelo kwisiphelo sendlela ngalo myalelo ulandelayo:

sudo dpkg -i DbVisualizer.deb

Kwimeko yokuba unengxaki yokuxhomekeka, ezi zisombulule nge:

sudo apt -f install

RHEL, CentOS, Fedora, kwaye uvuleSUSE

Inkqubo yofakelo kwezi nkqubo ifana neyangaphambili, apha kuphela siza kukhuphela iphakheji ye-RPM ehambelana nenkqubo yethuKe ngoko, nakuphi na ukuhanjiswa ngenkxaso yeephakeji ze-RPM kunokwenza olu hlobo lofakelo.

Siza kuvula i-terminal kwaye kuyo kufuneka ichwetheze:

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

Nje ukuba ukhuphelo lwenziwe, siyaqhubeka ukufaka ipakethi ngalo myalelo ulandelayo:

sudo rpm -i DbVisualizer.deb

Olunye ulwabiwo lweLinux

Ngalo lonke usasazo lweLinux, ungasifaka esi sicelo ngokukhuphela iskripthi sokufaka.

Ke kufuneka bavule i-terminal kwaye siza kuchwetheza lo myalelo ulandelayo:

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

Nje ukuba ukhuphelo lwenziwe, siza kunika imvume yokuphumeza esi skripthi ngo:

sudo chmod a+x dbvis_linux_10_0_15.sh

Emva kwexesha sinokuqhuba esi skripthi kwinkqubo yethu yokuqhuba isifakelo sesicelo ngalo myalelo ulandelayo:

./dbvis.sh

Kwaye ngokusisiseko inika "ngokulandelayo", "ngokulandelayo" kunye "ngokulandelayo".