Reviews
“As an old Oracle DBA I think that sqlsplus is much better than sqlcmd…”
“It’s several orders of magnitude better than SQL Server 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 on SQL Server 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 Server user logons are working as intended. And, I will definitely pass the word along about your product. It’s simple and straightforward 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 Oracle 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 SQL Server 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 SQL Server db objects after a migration in a quick and spectacular way.
Sqlsplus for SQL Server 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 email and I wish you the best:
Zsolt
DOWNLOAD PRODUCT
SQLS*Plus shines as a versatile and extremely efficient SQL developer and production dba tool. It is also a very efficient tool for complex SQL Server reporting and automation tasks. Work that usually takes days can be accomplished in minutes.
SQLS*Plus for SQL Server is enable flexible data formatting with set linesize, set pagesize commands, report titles, report data grouping, aggregation, and many other extremely useful report formatting features.
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. This functionality is not present on standard SQL Server tools.
DOWNLOAD SQLS*Plus
SQLS*Plus PDF manual
Features
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
SQLS*Plus is trusted by hundreds of SQL Server database administrators and SQL database developers around the world.
SQLS*Plus for SQL Server is 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 for ms sql server
Supported SQL Server Versions
Microsoft Azure SQL Server Databases
Microsoft SQL Server 2019
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
Platforms
Cloud Amazon RDS and Microsoft Azure
SQL Server Enterprise
SQL Server Standard
SQL Server Express
Operating system: Windows
Review product features in the SQLS*Plus manual
Oracle to SQL Server Migration
Sql Server Migration Assistant is nice tool. But it will not convert your Oracle reports to SQL Server.
SQL Server reporting tools, like SQL Server Reporting Services (SSRS) are time consuming and hard to manage. With SQLS*Plus complex SQL*Plus Oracle reports can be moved to SQL Server almost instantly!
Execute SQL*Plus scripts in SQL Server environment.
Drastically minimize Oracle to SQL Server database migration time and cost 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 used by hundreds of database administrators, database developers, and IT operations engineers across the world. SQLS*Plus is used to execute database 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 Server migration.
SQLS*Plus fully supports JSON data processing – JSON output of SQL Server data.
PRICING
- Commercial and Personal use on a single SQL Server instance (with no linked servers)
- Single Site
- Named User
- Standard SQLS*Plus commands
- Unlimited Servers
- Single Site
- Named User
- Standard SQLS*Plus commands
- Product support for named user
- Unlimited Servers
- Single Site
- Unlimited Users
- Advanced SQLS*Plus commands
- Product support for enterprise
- Unlimited Servers
- Unlimited Sites
- Unlimited Users
- Advanced SQLS*Plus commands
- Product support for enterprise