MySQL
Entity Framework 6.3 and .NET Core 3 Support
.NET Core 3
.NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....
Apply Integrity Constraint to Your MySQL Database With the Help of dbForge Studio!
Our database tools team is pleased to announce the release of our dbForge MySQL products with a CHECK constraint support. We are looking forward...
MySQL Backup Strategies: How to Backup All and Multiple Databases
This article will outline two approaches to performing regular database backups. The first method involves backing up databases specified in a list, while the second entails bulk backing up of all databases. These procedures can be executed on both Linux and Windows platforms using dbForge Studio for MySQL.
Meet MariaDB 10.4 Support in MySQL Database Tools
We are glad to announce the release of the updated dbForge tools for MySQL. To ensure that the users of our MySQL tools can...
Connectivity to MariaDB Keeps Extending in dbForge Studio for MySQL
We are thrilled to inform our MySQL users that fresh and new dbForge Studio for MySQL, v8.1 has been just rolled out!
To ensure that...
Extended Connectivity in dbForge Tools for MySQL
We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL,...
Eight Supported by Eighth!
We would like to take this moment to thank the Oracle company for continuous development of the popular MySQL database! As you all might...
MySQL Documenting Has Never Been Easier!
We just love to make our users' life a bit easier. This time, we are excited to treat you with a brand new addition...
Reinvented dbForge Tools for MySQL Have Arrived!
After a grand update of dbForge Studio for MySQL, we haven't forgotten about the rest of the dbForge for MySQL product range. Our developers...
How To Import a .CSV file through the Command Line
In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio...
JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL
Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...
MySQL Case Sensitive Search in Entity Framework
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
Using HTTP Tunneling
Summary
This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL.
Introducing HTTP Tunneling
HTTP...
Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL
Entity Framework v5 and v6 support spatial data types. They are represented as two DbGeometry and DbGeography data types from System.Data.Entity.dll in .NET Framework...
Using MySQL Full-Text Search in Entity Framework
Introduction
MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:
Full-Text Search Functions (MySQL 5.5 stable...
Get 20% off on any Devart product (expires January 10th)!
Merry Christmas and Happy New Year!
As Christmas holidays are drawing closer, we offer you to get 20% off any product license order.
Don’t think twice,...
dbForge Studio for MySQL on Linux Operating Systems
Despite the fact that the dbForge database tools were developed only for Windows platforms, our active users (thanks to Tsvetkov) have found a way...
Comic video about developing dbForge Studio for MySQL
Our company has been working on its own MySQL GUI client development for over 6 years. Many features were implemented in this product in...
How to Get a List of Permissions of MySQL Users
In this article Devart describes how you can create a list of privileges of MySQL database users with the help of a data reports tool.
Provide your feedback on dbForge Studio for MySQL at UserVoice!
Please take part in voting for the new features for the next version of MySQL GUI Client.
How To: Create a MySQL Database Diagram Using a Sketch Image
With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.
dbForge Studio for MySQL has been nominated in Best IDE Product of 2010 DevProConnections Community Choice Awards!
Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by...
How To Create SQL Query in One Shot
In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.
Quick start in database development with Sakila database project
The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.
How To: Setup Daily MySQL Backup on Windows
Making database backups is one of the most important things in the process of administrating MySQL databases, because some critical data loss can be irreplaceable. To avoid data loss you should make backups of all active databases regularly. If you have a backup, you will be able to restore the whole database or some of its objects easily.
How to: Create MySQL Database in One Shot
Database Designer presents the database that is being created in the form of a database diagram.
Database Designer tool available in dbForge Studio for MySQL serves for creating databases visually.
Dynamic Database Creation in Entity Framework
Entity Framework 4 RC allows you to create and drop databases in run-time using SSDL for DDL generation. Now ObjectContext has CreateDatabase(), DropDatabase(), and...
Entity Framework 4 Release Candidate supported!
We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for...
Data Comparison Methods and Techniques
Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...
Entity Framework Canonical Functions
Article was updated on 3/4/2010
This article can be useful for programmers who want to develop cross-database applications and use the canonical functions.
Entity Framework Canonical...
Query Builder for MySQL v 1.10 – unlimited database connectivity and better performance
Devart announced the release of dbForge Query Builder for MySQL v 1.10, a professional tool for quick creation of any queries without code and...
dbForge Fusion 3.50 released! Enjoy more valuable features!
Devart has released today the updated version 3.50 of dbForge Fusion for MySQL - a powerful add-in for Microsoft Visual Studio, designed to simplify...
Be careful while using UNSIGNED data type in the routine body
Introduction
MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions.
Stored procedures are a set of SQL commands...
How to Save MySQL Database Diagrams as an Image
dbForge Studio for MySQL has the Database Designer functionality that allows you to build and view the structure of your database using the diagrams. You...
Designing Views with MySQL Query Builder
If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature....
Getting Started with MySQL Database Designer
Contents
What Is Database Designer?
How to Create a Database Diagram
Navigating the Diagram
How to Quickly Print Diagram
Saving and Restoring the Diagram
What...
Roadmap: dbForge for MySQL
Devart company decided to publish roadmap of dbForge for MySQL line to help you understand the future product development. This roadmad encompasses two products:...
Synchronizing views between MySQL databases
How to compare and synchronize MySQL views? Recently we discovered some tricks in schema synchronization process of MySQL databases. It's about how MySQL creates...
