[dba-SQLServer] Replacement for SSMS and/or Query

[Jim Lawrence]

I do not know how good Toad for SQL is but Toad for Oracle was awesome.

Jim 

----- Original Message -----
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, August 22, 2017 9:15:32 AM
Subject: Re: [dba-SQLServer] Replacement for SSMS and/or Query

Since sending that email, I have found two, both of which I've heard of but
never used: Heidi SQL and Toad for SQL Server. I'll download them now and
kick their wheels.

A.

On Tue, Aug 22, 2017 at 11:45 AM, Damien Solodow <
Damien.Solodow at harrison.edu> wrote:

> There is a stand-alone SSMS package (which is free):
> https://docs.microsoft.com/en-us/sql/ssms/download-sql-
> server-management-studio-ssms
>
> Only other thing I can think of off-hand would be Visual Studio Code with
> the mssqlserver extension...
>
> DAMIEN SOLODOW
> IT Engineering Lead
> 317.447.6033 (office)
> HARRISON COLLEGE
>
> -----Original Message-----
> From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com]
> On Behalf Of Arthur Fuller
> Sent: Tuesday, August 22, 2017 11:43 AM
> To: Discussion concerning MS SQL Server <dba-sqlserver@
> databaseadvisors.com>
> Subject: [dba-SQLServer] Replacement for SSMS and/or Query
>
> Can you think of a replacement for SSMS, ideally free? I don't need all
> the functionality of SSMS, but I do need to be able to create queries,
> ideally graphically, execute them, and change them into views.
>
> You might wonder why I need this, since I already have the complete SQL
> Express package. It's a long story but I'll cut to the chase. A client has
> licensed a package from a vendor. This package runs on a server in the
> vendor's office, and is connected to over the net. The vendor has denied
> permission for me to install SQL Express on said machine, and even to tell
> me how to connect to said server remotely (otherwise I could run my copy of
> SSMS and connect remotely). So, at least for the moment, I'm pretty much
> stuck. It's not like I have a large number of tasks to perform. Just create
> a few queries and a couple of Views, which would subsequently serve as the
> data source for a couple of Crystal Reports not provided by the vendor's
> package.
>
> Any suggestions shall be gratefully received.
>
> Arthur
>
> --
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com