![]() ![]() ![]() I've used everything from SQuirreL SQL Client (not bad, open source java) to SSMS to TOAD and this is far and away the best product I've used. 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. 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.įor me, dbForge Studio for MySQL is easily the closest in terms of look and feel to SSMS. 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. Kommentare: 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 |