Fixed an issue that occurred during schema synchronization and added an unnecessary CREATE TRIGGER to the synchronization script (D122527).Fixed the incorrect highlighting caused by the document window losing focus on input (D126504).Fixed an issue that occurred when exporting/importing data from the command line (D126097, D124902).Fixed an issue that occurred when loading a SQL document (D102969, D113339, D120431).Fixed the incorrect display of fonts that occurred when opening the Studio on Linux or macOS via CrossOver (D118342, D119809).Fixed an internal application error that occurred when opening the Studio on Linux or macOS via CrossOver (D122762).Fixed an internal application error in SQL Editor (D124281).Fixed an issue that occurred when creating a trigger (D124277).Fixed an issue that occurred when updating data in Session Manager (D115292).Improved the modification mechanism for procedures and functions when saving an object, the Studio does not create a temporary object with a 'dvrt_' prefix in the title (D120566).Fixed an issue in the table editor that occurred when opening a table with the # character in the title (D121640).Removed the cause of warnings in database backup scripts the ALTER TABLE ENABLE KEYS command is applied to MyISAM tables only (D125793).Removed the automatic creation of an empty debug.log file when opening the Studio (D119291).Improved table mapping error diagnostics in Data Compare (D124165).Added support for authentication via AWS Identity and Access Management (IAM).I found myself opening up a new SQL window, copying my code, pasting into the new tab, modifying and copying back to the Query Text tab. Sometimes you just need to do a quick edit to a view and it's a bit frustrating to deal with. The "Edit View" feature is a little clunky-you cannot edit SQL directly in the SQL tab, and when you try to do it in the Query Text tab, it constantly throws errors as you type. You can also easily output data to all kinds of formats including Excel, Sheets, csv, xml, etc., and save templates so that you can quickly generate the same reports. Also, one of the best features is the automated code formatting command (CTRL-K, D), which takes my sloppy, ill-formated SQL and turns it into beautifully formatted SQL. The data generation feature is nice as well, as you can generate a lot of test data quickly. The ability to mark different databases with shapes and colors is a thoughtful feature and reduces the chances of accidentally making a change in live instead of dev. The Visual Studio Blue makes it feel like I'm working with my old friend SSMS. The code completion feature is so much quicker than SSMS, I love that you can set the delay, and it saves me a lot of typing in addition to keeping the case consistent within my SQL. I love being able to completely copy a database from one server to another with a few clicks, which makes it super quick to keep my dev environment in sync with the live database. I love this software and it offers a great value over its competitors and a shortened learning curve for those of use who use SSMS. I ended up liking MySQL/dbForge Studio so much that I'm going to use MySQL as my go-to database technology on my projects going forward. I was a little embarrassed about my lack of MySQL skills, so in about 30 seconds dbForge Studio was able to copy my sandbox DB over to a local MySQL server I set up so that I could play around with it and learn the nuances of MySQL over MSSQL. I was able to install, connect to the sandbox they gave me, and dive right in. For me, dbForge Studio for MySQL is easily the closest in terms of look and feel to SSMS. I have used the MSSQL version of dbForge Studio in the past, so when I realized they offered a MySQL version, I decided to give it a try. I took on a new client recently, and they are a MySQL shop, so I had to find a tool where the learning curve wouldn't waste a lot of my time. I like MSSQL/SSMS so much, and I'm so stubborn, that I stupidly connect to MSSQL when I am doing PHP pages. I've been using it forever, and I think it's perhaps one of the best free pieces of software on the planet given what you can do with it. So, for the record I'm an MSSQL guy from way back, and SSMS is my friend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |