Si bajonge enye indlela kuMicrosoft SQL Server banokukhetha i-DBeaver, que sisixhobo sedatha esinqamlezileyo. I-DBeaver ngumthengi we-SQL kunye nesixhobo solawulo lwedatha.
Ngaba yenzelwe abaphuhlisi kwaye ayixhasi kuphela iMicrosoft SQL, kodwa kunye nolunye ugcino lwedatha Ulwalamano oludumileyo njenge-MySQL, i-PostreSQL, i-SQLite, i-Oracle, i-DB2, iMariaDB, iSybase, iTeradata, iNetezza, njl.
Kwakhona kwiIxhasa ezinye iinkcukacha zeNoSQL ezinjengeMongoDB, iCassandra, Redis, Apache Hive, njl. Namhlanje siza kubona ushicilelo lwasimahla (loluntu) lwesi sixhobo.
Kubalulekile ukukhankanya loo nto nayo kukho ingxelo ehlawulelweyo enokuphatha iNoSQLo ukuba ufuna ezinye izinto ezinje ngokudityaniswa kweOfisi okanye ufuna uncedo.
Iimpawu zeDBeaver
DBever ixhasa lonke ugcino lwedatha oludumileyo olufana noku: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, njl.
Ixhasa nasiphi na isiseko sedatha esinomqhubi weJDBC. Nangona ngokwenyani, unokukhohlisa nawuphi na umthombo wangaphandle wedatha onokuthi okanye angabinakho umqhubi weJDBC.
Kwakhona, Isekwe kwisakhelo somthombo ovulekileyo kwaye ivumela ukubhalwa kwezandiso ezahlukeneyo (iiplagi).
Kukho iseti ye-plug-ins yolwazi oluthile (i-MySQL, i-Oracle, i-DB2, i-SQL Server, i-PostgreSQL, iVertica, i-Informix, i-MongoDB, iCassandra, iRedis kwinguqulo 3.x) kunye nezinto ezahlukeneyo zolawulo lwedatha (umzekelo, ERD) .
Ezinye izinto ezibalaseleyo zezi:
- Uhlalutyo lwedatha -Ubonelela ngemizobo ebonakalayo yezinto ezizodwa kunye neskimu esipheleleyo.
- Ukwaziswa kwedatha -Ungahlela okanye ujonge iitafile. Ungathumela ngaphandle kwiifomathi ezininzi, ezinje nge-CSV, HTML, XML, XLS, XLSX.
- Iimbono ezininzi zedatha Ukuziqhelanisa neemfuno ezahlukeneyo zomsebenzisi, umzekelo, ukubonisa umxholo womfanekiso (gif, png, jpeg, bmp) njengemifanekiso.
- Ukuhlelwa kwedatha ekwi-Intanethi nakwindawo ezinikezelweyo.
- Ndiyakwazi Joyina imibuzo ye-SQL eya kwenziwa kwiseshoni ye-DB kanye emva kokuba uqhagamshelo lusekiwe.
- Umlawuli woxhumano: Kukho umphathi woqhakamshelwano ekuvumela ukuba uqwalasele useto loqhagamshelo kulwazi olwahlukeneyo kwaye usebenzise ezinye iipropathi eziphambili ezinje ngeSSH itonela, ummeli weSOCKS okanye usebenzise imiyalelo yegobolondo ngaphambi okanye emva koqhagamshelo lwedatha.
I-DBeaver ilungile ngokulinganayo kubaphathi beenkcukacha zeengcali kunye ne-hobbyist, ukwenza ukusebenza kulwazi kunye nedatha enomdla, elula, kwaye elula.
Nge-DBeaver, ulawulo olunzima lwedatha kunye nemisebenzi yohlalutyo kulula kunokuba kunokubonakala ekuqaleni. I-DBeaver ayifuni naluphi na ulwazi olukhethekileyo lobuchwephesha ukubuyisela isiseko sedatha yakho kwimeko ehlaziyiweyo kwaye inike uncedo xa kufuneka njalo.
Uyifaka njani i-DBeaver kwiLinux?
Ukuba unomdla wokufaka esi sixhobo, kuya kufuneka uyazi ukuba enye yeendlela esinazo ukufaka iDBeaver Community KwiLinux ngeFlatpak
Ukufaka Kufuneka sivule i-terminal kwaye kuyo senze lo myalelo ulandelayo:
flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref
Ngale nto, baya kuba nakho ukuqala ukusebenzisa esi sicelo kwiinkqubo zabo. Khangela nje isiqalisi ngaphakathi kwimenyu yesicelo sakho.
Ukuba awuyifumani, ungaqhuba usetyenziso ngalo myalelo ulandelayo:
flatpak run io.dbeaver.DBeaverCommunit
Ukufakwa kwi-Debian, Ubuntu nakwiziphumo
Ukuba bangabasebenzisi beDebian, i-Deepin OS, Ubuntu, iLinux Mint phakathi kolunye unikezelo ngenkxaso yeephakeji zetyala, banokukhuphela iphakheji yesicelo.
Kulabo ba Abasebenzisi benkqubo ye-64bit, iphakheji yokukhuphela yile ilandelayo:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Ngelixa kwabo bakhoyo Inkqubo yabasebenzisi be-32bit iphakheji yoyilo lwakho yile:
wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb
Emva kokukhuphela iphakheji, sinokuyifaka ngalo myalelo ulandelayo:
sudo dpkg -i dbeaver-ce*.deb
Kwaye ukuxhomekeka esisombulula ngako:
sudo apt -f install
Ukufakwa ngephakheji ye-RPM
Le ndlela iyafana neyangaphambili, isebenza kuphela kulwabiwo olunenkxaso yeephakeji ze-RPM, ezinje ngeFedora, CentOS, RHEL, OpenSUSE nezinye.
Kule meko, iiphakheji ekufuneka sizikhuphile zezi zilandelayo, Iibhithi ezingama-64:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
Okanye iinkqubo ezingama-32:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm
Okokugqibela sifaka kunye:
sudo rpm -i dbeaver-ce-latest*.rpm