Si vari kutsvaga imwe nzira kune Microsoft SQL Server inogona kusarudza DBeaver, , que chishambadziro cheplatform-chikuva dhatabhesi. DBeaver ndeye SQL mutengi uye dhatabhesi manejimendi chishandiso.
Is yakagadzirirwa vagadziri uye inotsigira kwete chete Microsoft SQL, asiwo mamwe akawanda dhatabhesi hukama hwakakurumbira senge MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, nezvimwe.
Zvakare kuInotsigira mamwe maratidziro eNoSQL senge MongoDB, Cassandra, Redis, Apache Hive, nezvimwe. Nhasi tichaona yemahara (enharaunda) edition yeichi chishandiso.
Izvo zvakakosha kuti utaure izvo zvakare pane yakabhadharwa vhezheni iyo inogona kubata NoSQLo kana iwe uchida zvimwe zvekuwedzera maficha senge Hofisi yekubatanidza kana kuda rubatsiro.
DBeaver Zvimiro
dbeaver inotsigira ese akanyanya kufarirwa dhatabhesi senge: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, nezvimwe.
Inotsigira chero dhatabhesi ine mutyairi weJDBC. Kunyangwe muchokwadi, unogona kubata chero chekunze dhata sosi iyo inogona kana inogona kunge isina mutyairi weJDBC.
Uyewo, Iyo yakavakirwa pane yakavhurwa sosi sosi uye inobvumira kunyorwa kweakasiyana ekuwedzera (plugins).
Iko kune seti ye plug-ins yemamwe madhatabhesi (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis mushanduro 3.x) uye akasiyana dhatabhesi manejimendi zvinoshandiswa (semuenzaniso muenzaniso ERD) .
Zvimwe zvinhu zvinobuda pachena ndezvi:
- Kuongorora dhatabhesi - Inopa mifananidzo inoonekwa yezvinhu zve database uye yakazara maschematics.
- Data Editing : Unogona kugadzirisa kana kutarisa matafura. Iwe unogona kutumira kunze kune akawanda mafomati, senge CSV, HTML, XML, XLS, XLSX.
- Multiple data maonero kujairana nemhando dzakasiyana dzevashandisi, semuenzaniso, kuratidza zvemukati zvemifananidzo (gif, png, jpeg, bmp) semifananidzo
- Online data kugadzirisa uye munzvimbo yakatsaurirwa.
- Tinogonawo Joinha SQL mibvunzo iyo inomhanyisa muchikamu cheDB mushure mekubatanidzwa.
- Kubatanidza maneja: Iko kune yekubatanidza maneja iyo inokutendera iwe kumisikidza iyo yekubatanidza marongero kune akasiyana dhatabhesi uye zvakare kushandisa zvimwe zvemberi zvivakwa senge SSH tunnel, SOCKS proxy kana kumhanya shell mirairo pamberi kana mushure me database dhata.
DBeaver yakaenzana zvakaenzana kune vehunyanzvi uye hobbyist database maneja, sezvo ichiita kushanda pane dhatabhesi uye data intuitive, yakapusa, uye inyore.
Iine DBeaver, yakaoma dhatabhesi manejimendi uye yekuongorora mabasa ari nyore pane angaratidzika pakutanga kuona. DBeaver haidi chero ruzivo rwehunyanzvi rwekusimudzira dhatabhesi rako mune yepamusoro mamiriro uye inopa rubatsiro pazvinenge zvichidikanwa.
Maitiro ekuisa DBeaver paLinux?
Kana iwe uchida kuisa chishandiso ichi, iwe unofanirwa kuziva icho imwe yemaitiro atinawo kuitira kuti uise DBeaver Nharaunda paLinux kuburikidza neFlatpak
Kuisa Isu tinongofanirwa kuvhura terminal uye mairi ita unotevera kuraira:
flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref
Naizvozvi, ivo vanozokwanisa kutanga kushandisa iyi application pane avo masisitimu. Ingo tsvaga iyo yekutanga mune yako yekushandisa menyu.
Kana iwe usingakwanise kuiwana, unogona kumhanya nekushandisa nemirairo inotevera:
flatpak run io.dbeaver.DBeaverCommunit
Kuisirwa paDebian, Ubuntu uye zvigadzirwa
Kana ivo vari vashandisi veDebian, Deepin OS, Ubuntu, Linux Mint pakati pezvimwe zvinogoverwa nerutsigiro rwezvikwereti zvemadhibhodhi, vanogona kurodha pasi chikumbiro chedhi package.
Kune avo vari 64bit system vashandisi, homwe yekurodha pasi ndeiyi inotevera:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Panguva yeavo vari 32bit system inoshandisa iyo package yezvivakwa zvako ndeiyi:
wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb
Mushure mekurodha pasi pasuru, tinogona kuiisa nemirairo inotevera:
sudo dpkg -i dbeaver-ce*.deb
Uye kutsamira kwatinogadzirisa ne:
sudo apt -f install
Kuisirwa kuburikidza neRPM package
Iyi nzira yakafanana neiyo yapfuura, chete inoshanda kune kugoverwa nerutsigiro rweRPM mapakeji, senge Fedora, CentOS, RHEL, OpenSUSE nedzimwe.
Mune ino kesi, mapakeji atinofanira kurodha pasi anotevera, Makumi matatu nematatu:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
Kana ye32-bit masisitimu:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm
Pakupedzisira tinoisa ne:
sudo rpm -i dbeaver-ce-latest*.rpm