Si bafuna enye indlela kuMicrosoft SQL Server engakhetha i-DBeaver, lokho iyithuluzi ledatha eliwela amapulatifomu. I-DBeaver iyithuluzi lokuphathwa kwamakhasimende we-SQL kanye nedatha.
Kuyinto eyenzelwe onjiniyela futhi ayisekeli iMicrosoft SQL kuphela, kepha futhi neminye imininingwane eminingi Ubudlelwano obudumile obufana ne-MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, njll.
Futhi ku-Ixhasa imininingwane ethile yeNoSQL efana neMongoDB, iCassandra, Redis, Apache Hive, njll. Namuhla sizobona uhlelo lwamahhala (lomphakathi) lwaleli thuluzi.
Kubalulekile ukusho lokho futhi kukhona inguqulo ekhokhelwayo engaphatha i-NoSQLo uma udinga ezinye izici ezengeziwe njengokuhlanganiswa kweHhovisi noma udinga usizo.
Izici ze-DBeaver
I-DBeaver isekela yonke imininingwane ethandwa kakhulu njenge: I-MySQL, i-PostgreSQL, i-MariaDB, i-SQLite, i-Oracle, i-DB2, i-SQL Server, i-Sybase, i-MS Access, i-Teradata, i-Firebird, i-Derby, njll.
Isekela noma iyiphi i-database enomshayeli we-JDBC. Yize empeleni, ungakhohlisa noma imuphi umthombo wangaphandle wedatha ongahle abe nomshayeli we-JDBC.
Futhi, Kususelwa kunhlaka yomthombo ovulekile futhi kuvumela ukubhalwa kwezandiso ezahlukahlukene (ama-plugins).
Kukhona isethi yama-plug-ins yolwazi oluthile (i-MySQL, i-Oracle, i-DB2, i-SQL Server, i-PostgreSQL, i-Vertica, i-Informix, i-MongoDB, i-Cassandra, i-Redis ngohlobo lwe-3.x) nezinsiza ezihlukile zokuphathwa kwedatha ( isibonelo isibonelo i-ERD).
Ezinye izici ezigqamile yilezi:
- Ukuhlaziywa kwedatha - Inikeza imidwebo ebonakalayo yezinto ezigciniwe ezihlukile kanye nezikimu eziphelele.
- Ukuhlela idatha : Ungahlela noma ubuke amatafula. Ungathumela kumafomethi amaningi, njenge-CSV, HTML, XML, XLS, XLSX.
- Ukubukwa kwedatha eminingi Ukuzivumelanisa nezidingo ezahlukahlukene zomsebenzisi, ngokwesibonelo, ukubonisa okuqukethwe kwezithombe (i-gif, png, jpeg, bmp) njengezithombe.
- Ukuhlelwa kwedatha eku-inthanethi nasendaweni enikezelwe.
- Ngiyakwazi futhi Joyina imibuzo ye-SQL okuzokwenziwa kuseshini ye-DB ngemuva nje kokusungulwa kokuxhumeka.
- Imenenja yokuxhuma: Kukhona imenenja yokuxhuma ekuvumela ukuthi ulungiselele izilungiselelo zokuxhuma kulwazi oluhlukile futhi usebenzise ezinye izakhiwo ezithuthukile njengomhubhe we-SSH, ummeleli we-SOCKS noma usebenzise imiyalo yeShell ngaphambi noma ngemuva kokuxhumeka kwe-database.
I-DBeaver ilungele ngokulinganayo abaphathi be-database nabasebenza ngokuzilibazisa, njengoba yenza ukusebenza kulwazi nemininingwane enembile, elula, futhi elula.
Nge-DBeaver, imisebenzi eyinkimbinkimbi yokuphathwa kwedatha nokuhlaziywa kulula kunalokho okungabonakala ekuqaleni. I-DBeaver ayidingi noma yiluphi ulwazi olukhethekile lobuchwepheshe ukwenza isipele i-database yakho esimweni esisesikhathini futhi inikeze usizo lapho ludingeka.
Ungayifaka kanjani i-DBeaver ku-Linux?
Uma unentshisekelo yokufaka leli thuluzi, kufanele wazi lokho enye yezindlela esinazo ukuze ufake i-DBeaver Community kuLinux ngeFlatpak
Ukufaka Kumele sivule ukuphela futhi lapho senza umyalo olandelayo:
flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref
Ngalokhu, bazokwazi ukuqala ukusebenzisa lolu hlelo kuzinhlelo zabo. Vele useshe isiqalisi ngaphakathi kwemenyu yakho yohlelo lokusebenza.
Uma ungayitholi, ungaqhuba uhlelo lokusebenza ngomyalo olandelayo:
flatpak run io.dbeaver.DBeaverCommunit
Ukufaka ku-Debian, Ubuntu kanye nokuphuma kokunye
Uma bengabasebenzisi beDebian, i-Deepin OS, Ubuntu, iLinux Mint phakathi kokunye ukusatshalaliswa ngokusekelwa kwamaphakeji wedeb, bangalanda iphakethe lesicelo sohlelo lokusebenza.
Okwalabo Abasebenzisi besistimu abangama-64bit, iphakethe elizolandwa yileli elilandelayo:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Ngenkathi kulabo abakhona Abasebenzisi bohlelo lwe-32bit iphakethe lokwakha kwakho yile:
wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb
Ngemuva kokulanda iphakheji, singayifaka ngomyalo olandelayo:
sudo dpkg -i dbeaver-ce*.deb
Futhi ukuncika esixazulula ngakho:
sudo apt -f install
Ukufaka ngephakeji le-RPM
Le ndlela ifana neyedlule, isebenza kuphela ekusatshalalisweni okusekelwa amaphakheji we-RPM, afana neFedora, i-CentOS, i-RHEL, i-OpenSUSE nokunye.
Kulokhu, amaphakheji okufanele siwalande ayalandela, 64 izingcezu:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
Noma izinhlelo ezingama-32-bit:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm
Ekugcineni sifaka nge:
sudo rpm -i dbeaver-ce-latest*.rpm