Si suna neman madadin Microsoft SQL Server na iya zaɓar DBeaver, que kayan aikin giciye ne na kayan aiki. DBeaver abokin ciniki ne na SQL kuma kayan aikin gudanar da bayanai.
Shin da aka tsara don masu haɓakawa da tallafawa ba kawai Microsoft SQL ba, har ma da sauran ɗakunan bayanai masu yawa sanannen dangi kamar MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, da sauransu.
Har ila yau, zuwaYana tallafawa wasu bayanan NoSQL kamar MongoDB, Cassandra, Redis, Apache Hive, da sauransu. A yau za mu ga kyautar (al'umma) ta kyauta ta wannan kayan aiki.
Yana da mahimmanci a faɗi hakan ma akwai sigar da aka biya wanda zai iya ɗaukar NoSQLo idan kuna buƙatar wasu ƙarin fasali kamar haɗin Office ko kuma buƙatar taimako.
Siffofin DBeaver
Bayarwa yana goyan bayan duk shahararrun ɗakunan bayanai kamar: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, da sauransu.
Yana tallafawa kowane ɗakunan ajiya tare da direban JDBC. Kodayake a zahiri, zaku iya yin amfani da duk wani tushen bayanan waje wanda watakila ko bashi da direban JDBC.
Har ila yau, Ya dogara ne akan tsarin buɗe tushen kuma yana ba da damar rubuce-rubuce na ƙarin kari (kari).
Akwai saitin abubuwan toshe-wasu bayanai na musamman (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis a sigar 3.x) da kuma masu amfani da kayan gudanar bayanai daban-daban ( misali misali ERD).
Sauran siffofin da suka fito sune:
- Nazarin bayanai - Yana bayar da zane-zane na kayan adana bayanan mutum da kuma cikakken tsari.
- Shirya bayanai : Zaka iya shirya ko duba tebur. Kuna iya fitarwa zuwa fasali da yawa, kamar CSV, HTML, XML, XLS, XLSX.
- Bayanan ra'ayoyi masu yawa Don daidaitawa da nau'ikan bukatun mai amfani, misali, nuna abun cikin hoto (gif, png, jpeg, bmp) azaman hotuna.
- Gyara bayanan kan layi kuma a cikin keɓaɓɓun sarari
- Can kuma shiga tambayoyin SQL wanda za'a aiwatar dashi a cikin zaman DB kai tsaye bayan haɗin ya tabbata.
- Manajan haɗin: Akwai manajan haɗin yanar gizo wanda zai ba ku damar saita saitunan haɗi zuwa ɗakunan bayanai daban-daban kuma ku yi amfani da wasu kaddarorin da suka ci gaba kamar ramin SSH, wakili na SOCKS ko yin umarnin harsashi kafin ko bayan haɗin bayanan bayanai.
DBeaver daidai yake da kyau ga ƙwararru da masu kula da adana bayanai, kamar yadda yake yin aiki akan rumbunan adana bayanai da ƙwarewa, mai sauƙi, da dacewa.
Tare da DBeaver, rikitaccen tsarin adana bayanai da ayyukan bincike sun zama masu sauki fiye da yadda ake iya gani da farko. DBeaver baya buƙatar kowane ilimin fasaha na musamman don adana bayanan bayanan ku a cikin yanayin yau da kullun kuma yana bayar da taimako yayin buƙata.
Yadda ake girka DBeaver akan Linux?
Idan kuna sha'awar shigar da wannan kayan aikin, ya kamata ku san hakan daya daga cikin hanyoyin da muke da su domin girka DBeaver Community akan Linux ta hanyar Flatpak
Don girka Dole ne kawai mu buɗe tashar kuma a cikin ta aiwatar da wannan umarnin:
flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref
Tare da wannan, za su iya fara amfani da wannan aikace-aikacen a kan tsarin su. Kawai bincika mai ƙaddamar a cikin tsarin aikinku.
Idan baku iya samun sa ba, kuna iya gudanar da aikace-aikacen tare da umarnin mai zuwa:
flatpak run io.dbeaver.DBeaverCommunit
Shigarwa akan Debian, Ubuntu da abubuwan da suka samo asali
Idan masu amfani ne da Debian, Deepin OS, Ubuntu, Linux Mint a tsakanin sauran rarrabawa tare da tallafi don fakitin bashi, za su iya zazzage fakitin bashin aikace-aikacen.
Ga wadanda suke 64bit masu amfani da tsarin, kunshin da za a sauke shi ne mai zuwa:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Yayinda ga wadanda suke 32bit masu amfani da tsarin kunshin gininku shine:
wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb
Bayan sauke kunshin, zamu iya girka shi tare da umarnin mai zuwa:
sudo dpkg -i dbeaver-ce*.deb
Kuma abubuwan dogaro da zamu warware tare da:
sudo apt -f install
Shigarwa ta hanyar kunshin RPM
Wannan hanyar tayi kama da wacce ta gabata, kawai ana amfani da ita ne wajen rarrabawa tare da tallafi ga fakitin RPM, kamar Fedora, CentOS, RHEL, OpenSUSE da sauransu.
A wannan yanayin, fakitin da dole ne mu sauke su ne masu zuwa, 64 ragowa:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
Ko don tsarin 32-bit:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm
A ƙarshe mun shigar tare da:
sudo rpm -i dbeaver-ce-latest*.rpm