“As an old Oracle DBA I think that sqlsplus is much better than sqlcmd…”
“It’s several orders of magnitude better than sqlcmd and osql (but I’m sure you know that). Hell, for batch work I think it’s better than Oracle’s SQL*Plus. DEPS and GREP would definitely be welcomed additions to either tool (Microsoft’s sqlcmd, osql and Oracle’s SQL*Plus).”
“Very happy with the purchase and the item…”
“I found SQLS*Plus very useful when I was working with it. The ability to run scripts simple and easily from the command line or batch file is very useful.”
“Yes, the sqlsplus is great for what I need to do. I needed a quick way to check if the permissions I set on the SQL user logons are working as intended. And, I will definitely pass the word along about your product. It’s simple and straight forward to use. Thanks again. Great work and product! We need more Pros like you around.”
“I do like the product! It has some cool features that I wish SQL*Plus also had!!”
Do you see something that would make SQLS*Plus better for you?
I hate to say “nothing” but to tell you the truth, it’s always worked perfectly for the times I’ve needed it. I’ve used it in a few scheduled tasks for instance…that sort of thing. No big deal works perfectly!
Yes, I like it very much. There were two features what I used quite frequently/ One of them was the using of substitution variable in selects (which is a big lack in sqlcmd) and the other one was the DESCRIBE command with html output. It was very useful when I had to compare the structures of some db objects after a migration in a quick and spectacular way.
Sqlsplus would deserve more attention and I’d like to acquire it for my company… I will try to get obtained some new software, among others the excellent sqlsplus.
Again, thanks for your e-mail and I wish you the best:
SQLS*Plus is very flexible with the data formatting (set linesize, pagesize commands, report titles, report data grouping and aggregation, etc). SQLS*Plus supports use of variables (var, define, &, &&), interactively accepts user input into variables, spools data into TEXT, HTML, CSV and JSON output. Lots of other advanced functionality is available, such as BREAK and COMPUTE functionality.
While SQL Server Management Studio is a great GUI tool, SQLS*Plus shines as a versatile and extremely efficient production DBA tool and a very efficient command line tool for a complex SQL Server reporting and automation tasks
SQL Server command line tool trusted by hundreds of SQL Server database administrators and SQL database developers around the world
SQLS*Plus is very flexible with the data formatting (set linesize, pagesize commands, report titles, report data grouping, and aggregation, etc). SQLS*Plus supports use of variables (var, define, &, &&), interactively accepts user input into variables, spools data into TEXT, HTML, CSV and JSON output. Lots of other advanced reporting and data formatting functionality is available, such as BREAK and COMPUTE functionality.
SQLS*Plus is like an Oracle SQL*Plus / sqlplus that operates on:
- Microsoft Azure SQL Server Databases
- Microsoft SQL Server 2017
- Microsoft SQL Server 2016
- Microsoft SQL Server 2014
- Microsoft SQL Server 2012
- Microsoft SQL Server 2008R2
- Microsoft SQL Server 2008
- Microsoft SQL Server 2005
- Microsoft SQL Server 2000
- Cloud, SQL Server Enterprise, SQL Server Standard, and SQL Server Express database platforms
Operating system: Windows
Execute SQL*Plus scripts in SQL Server environment. Cut down Oracle to SQL Server database migration time for your Enterprise.
Use of SQLS*Plus is free for a personal use and for a commercial use on a single SQL Server instance (with no linked servers).
Purchase of an enterprise site support license/s is required for the use of SQLS*Plus in a multi-server, multi-instance, and multi-site SQL Server database environment. Use of BREAK and COMPUTE functionality requires a purchase of the enterprise site support license.
Who uses SQL Server SQLS*Plus?
SQLS*Plus for SQL Server is currently used by hundreds of DBAs, Database Developers, and Operations Engineers across the world. SQLS*Plus is used to execute DBA tasks, run SQL script(s) and to automate SQL database data processing and reporting batch jobs, as well as to convert Oracle SQL script(s) after Oracle to SQL migration.
SQLS*Plus fully supports JSON data processing – JSON output of SQL Server data.