dbForge Studio for MySQL 10.1 has hit the shelves!
Sure, Devart packed it with shinier features and squashed a ton of improvements. But which side of the fence are you?
Will your favorite MySQL IDE be stuck in the last season? Or will you jump in to upgrade?
Let’s find out!
What’s Up for dbForge Studio for MySQL 10.1?
Do you know that feeling when your favorite tool just leveled up? You get the jitters when you can’t or don’t upgrade. It’s a mix of frustration and anticipation.
It’s like a kid standing outside the candy store with the door just locked in front of him. He can smell the sweetness. It’s mouth-watering.
But it’s out of reach.
Sure, it’s a download away for those with Express Edition. But the goodness is incomplete.
It’s also a download away for those with subscription and perpetual licenses. So, you can feel the productivity bliss right out the window.
But then boom! You didn’t make it. Your license expired before it got out.
How frustrating!
So, this article will help you decide if you will jump on the upgrade bandwagon or not.
So, what’s up with 10.1?
Key Features of dbForge Studio for MySQL 10.1:
MySQL 9 and Heatwave Support
Kamatera MySQL Cloud Support
Enhanced Database Diagram Features
Data Generator: Append Timestamp to File Names
Generate Scripts: Include Security Permissions
Data Exports Improvement: CSV and Excel Export Options
Automation and Workflow Enhancements: Command Line Report Generation
But there’s more.
Devart added a few more twists, according to the release notes:
Added the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on Amazon Web Services (AWS).
Made a facelift to the Query History window.
Added quick access to Devart Academy directly from the interface.
Fixed a ton of bugs.
Curious?
We will give you the lowdown on the key features, data exports, and automation power-ups in a moment.
So, let’s dive in.
Key Features of dbForge Studio for MySQL 10.1
Let’s start with the more explosive power-ups of your favorite MySQL IDE. Your productivity is always the top priority. And the 10.1 upgrade is not meh.
MySQL 9 and Heatwave Support
How does it feel when MySQL jumps to the next version and your favorite tool is not on the guest list?
It’s unbelievable, isn’t it?
But dbForge Studio for MySQL 10.1 already joined the party. Check out the invite below:
So, no worries if your new project uses MySQL 9. Enjoy the dbForge tool experience of ease and productivity with the latest and greatest of MySQL.
MySQL 9 is from Oracle. And dbForge Studio for MySQL 10.1 supports another Oracle goody – Heatwave. There are Heatwave-specific MySQL syntaxes. The good news is they are now supported in 10.1 via the Code Completion. Take a look below:
This is great if you use Heatwave and want to avoid specific syntax errors from them.
Kamatera MySQL Cloud Support
What happens when you’re craving for the new dbForge Studio for MySQL, but your cloud provider didn’t get the memo?
It stings a little, isn’t it?
But if it’s Kamatera, you don’t have to fret. Because 10.1 got them covered. So, the next thing to do is to connect your dbForge Studio for MySQL to it. Look for your MySQL server IP address and port in Kamatera and let dbForge Studio for MySQL use it. Take a look below:
Click Connect and taste the usual dbForge seamless experience with Kamatera cloud.
Enhanced Database Diagram Features
There’s one little tidbit in the database diagram but this one is so useful. So, let me elaborate.
Imagine you have a diagram with at least 20 tables. You’re at a designer bliss. You moved the tables here and there. Then, you added relations. Finally, you saved it.
But now you zoom out to see everything you’ve done.
It’s awful. The lines and arrows are a mess. It intersects tables and you can’t see where it’s going. But dbForge Studio for MySQL has Reroute and Clear Waypoints to deal with this mess and remove those intersections.
Problem solved?
Not yet. You have to select the relations before you can Clear Waypoints or Reroute. Should you select the lines one by one?
Not anymore.
The new feature lets you select all relations at once. Right-click on the canvas and choose Select All Relations. Or, press the keyboard shortcut Ctrl-Shift-A.
Check it out below. It’s boxed in green.
It doesn’t feel like a chore anymore, isn’t it? It’s a nifty feature.
Data Generator: Append Timestamp to File Names
Are you like me who does SQL stuff every day?
Then, data is like a gold mine to you. Besides what can an empty database do?
That’s why dbForge Studio for MySQL has this smart Data Generator for all your data needs. Generate a tiny database with a few rows or a gigantic one with millions or more rows. Use it for development and testing, and see if your app will run fine with it.
Every option you choose in the data generator can be stored. So, you can open it and generate the same data again. The filename you set can mean different things for different purposes. Sometimes, you need to have a timestamp in the filename to remind you that it stores the options for the data on that day.
And here’s the good news: You don’t have to manually type the timestamp. It’s a checkbox away. Just click it and the timestamp goes right to the filename. Take a look below:
Simply follow the data generation wizard as you normally do. Then, click the Append timestamp to the file name. And finally, click Generate.
That’s it.
It saves you a few keystrokes on typing the timestamp manually.
Generate Scripts: Include Security Permissions
Sometimes, when I back up a database for first-time deployment to production, I don’t include the permissions. I set the permissions after the restore. That works for simple setups.
But if it’s tricky and more complex to set up after restoration, you have the option to include the permissions during scripting.
That’s what 10.1 of dbForge Studio for MySQL does for you. Now there’s an option to include permissions during general scripting, backup, and new database projects.
Check out a sample for the Database Backup Wizard:
This is another time-saver for scripting and moving databases.
Data Exports Improvement: CSV and Excel Export Options
It’s very routine to support users and do ad hoc queries to provide the results in a certain format, like Excel or CSV.
That’s why there’s another time-saver to do this in dbForge Studio for MySQL 10.1. Just right-click the results and select Copy Data As. Choose between CSV or Excel and between file or clipboard.
Not a big deal, right? It’s very easy.
You can also highlight a portion of the results grid before you right-click. See a sample for a CSV output below:
Since 9 rows were selected, expect a CSV file with 9 rows too. Here’s the output CSV file viewed from Notepad++:
Of course, you can also choose Excel. Check out the sample below:
Another lifesaver for routine tasks, don’t you think?
Schema and Data Comparison Automation and Report Generation
Have you ever deployed changes to your MySQL databases? If you forgot a new table column or a changed stored procedure, your app is toast. It will break big time!
The result?
Embarrassment to you and your team!
You can avoid that if you have a schema comparison tool. You can compare two databases. One is from development and the other is from production. It will show you what changed and let you sync the two.
You can apply the same between development and test environments or whatever reason you want to compare.
dbForge Studio for MySQL has this and more. It can also compare differences in data.
But there’s more in 10.1.
You can now automate the comparison and generate the report. That means you can schedule it before you go home and let it do its job. The next morning you will have the report ready.
Cool, isn’t it?
Comparison and Automation Example
Check out the following where I compare two databases from my local MySQL server in Windows and another in an Ubuntu MySQL server:
See the green boxed area? That’s where you will start the automation. It will use your comparison settings. When you click Save and select Save Command Line, you need to provide more settings to generate a batch file (*.bat).
See the next window below:
The above setup will do a comparison only. No synchronization. Then, it will generate a report in HTML format. Note that the CLI command should use valid credentials and permissions to connect to MySQL and compare.
The above shows that the configuration is validated and is okay.
The next thing you will do is to save the batch file by clicking Save. Then, outside of dbForge Studio for MySQL, use a scheduling app like Windows Task Scheduler to run the batch file on your desired schedule.
If you’re having a hard time comparing and syncing two databases manually, this is your salvation. Free yourself from manual work.
Conclusion
You just saw what dbForge Studio for MySQL 10.1 can do for you. It proved to be a MySQL Swiss army knife in my experience.
So, what’s your decision?
Database tasks will no longer be a chore because they will be easier than ever. Easier tasks mean going home early to be with family or enjoying a date with someone special.
So, why not upgrade?
And if your workflow takes more than just MySQL or MariaDB, you can also get updated dbForge Studio as part of the multidatabase solution dbForge Edge. It's a versatility database client that covers Oracle, SQL Server, PostgreSQL, and various cloud services as well.
Top comments (0)