5 ms·

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.

neves 9y ago
I also would like to know. I use Management studio at work. It would be great to find a good multiplataform that I can use everywhere.
- FuriouslyAdrift 9y ago
  I use DBeaver for cross platform support of SQL Servr at work. Obvious missing things like Query Plan support and all the newer goodies. For basic query design and ad hoc work it's great.
kthejoker2 9y ago
Ssms has menus and GUIs and such for all the non database SQL Server items like SSIS, SSAS (full cube browser), SQL agent, CLR, plus creating more advanced objects like Credentials and application roles and scenarios like suggesting indexes and performing DB maintenance. This is purely a database development tool, at least in its current form.
rajadigopula 9y ago
SCM?! If it can, then I am sold.
ElatedOwl 9y ago
On my first cursory glance: no table designer, no execute stored procedure GUI There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.
- timlin 9y ago
  What do you mean "inline text search for sproc"? I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN. If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.
  - ElatedOwl 9y ago
    In the object explorer just some text input that would filter accordingly. Some of our databases have a TON of tables/sprocs and it would be a nice convenience. SQL Hunting Dog looks exactly like what I've been wanting, thanks for the recommendation!
styfle 9y ago
My first thought is any SSMS specific plugins such as RedGate SQL Search and version control.

I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.

neves 9y ago

I also would like to know. I use Management studio at work. It would be great to find a good multiplataform that I can use everywhere.

FuriouslyAdrift 9y ago
I use DBeaver for cross platform support of SQL Servr at work. Obvious missing things like Query Plan support and all the newer goodies. For basic query design and ad hoc work it's great.

kthejoker2 9y ago

Ssms has menus and GUIs and such for all the non database SQL Server items like SSIS, SSAS (full cube browser), SQL agent, CLR, plus creating more advanced objects like Credentials and application roles and scenarios like suggesting indexes and performing DB maintenance. This is purely a database development tool, at least in its current form.

rajadigopula 9y ago

SCM?! If it can, then I am sold.

ElatedOwl 9y ago

On my first cursory glance: no table designer, no execute stored procedure GUI There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.

timlin 9y ago
What do you mean "inline text search for sproc"? I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN. If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.
- ElatedOwl 9y ago
  In the object explorer just some text input that would filter accordingly. Some of our databases have a TON of tables/sprocs and it would be a nice convenience. SQL Hunting Dog looks exactly like what I've been wanting, thanks for the recommendation!

styfle 9y ago

My first thought is any SSMS specific plugins such as RedGate SQL Search and version control.