4 ms·
I've never worked much with other databases other than SQL Server. But one time I had to work with Oracle and MySQL, I had trouble getting a good enough client
by blntechie 15y ago
I've never worked much with other databases other than SQL Server. But one time I had to work with Oracle and MySQL, I had trouble getting a good enough client (like SQL Server Management Studio) even though I was ready to pay.
May be it's my personal preference, I tried many clients (TOAD, DBArtisan, SQL Developer, SQL Plus etc.) and found that none was as polished (not that i'm mentioning functional) and integrates well with Windows as the one from Microsoft.
It's off topic, but the same applies for Visual Studio and other IDEs.
- s00pcan 15y agoI will say that the SQL Server Management Studio is a great tool, but because it's a GUI tool everything has to be buried in menus. If you plan on using it, read a guide first, because it's not entirely intuitive. It has the occasional cryptic error message or even unhandled exception, but my biggest annoyance is this: You can copy in rows from results and paste them to insert rows, but say you made a mistake and paste in hundreds of rows that don't fit the database schema: you will get hundreds of messagebox popups. The only way out I've found is to end the process.
- poissonpie 15y agoThe SQL Server Management tool is pretty good. And to be honest, I've actually never had a problem using SQL Server. It's been a solid, dependable database on any number of applications for me over the years. Granted, the businesses have been less on the startup side and more on the larger older organisation side of things.