Frequently Asked Questions
Common questions about SQLPro for MSSQL, SQL Server, and T-SQL.
Product
What is SQLPro for MSSQL?
SQLPro for MSSQL is a native database client for macOS, iOS, and Windows. It lets you connect to, query, and manage Microsoft SQL Server databases from a single app -- without needing a virtual machine or Java runtime.
Which SQL Server versions are supported?
SQLPro for MSSQL supports Microsoft SQL Server 2005 and above, including SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, Amazon RDS for SQL Server, and Google Cloud SQL for SQL Server.
Which platforms does SQLPro for MSSQL run on?
SQLPro for MSSQL is available on macOS, iOS/iPadOS, and Windows.
Is SQLPro for MSSQL a native app?
Yes. SQLPro for MSSQL is built with Swift and Objective-C on macOS and iOS. It is not a Java or Electron app, so it launches instantly and uses minimal system resources.
Does SQLPro for MSSQL require Java or a virtual machine?
No. SQLPro for MSSQL is 100% native and does not require Java, the JVM, or a Windows virtual machine to connect to SQL Server.
Does SQLPro for MSSQL support SSH tunneling?
Yes. SQLPro for MSSQL supports SSH tunneling, allowing you to securely connect to remote SQL Server instances through an SSH server.
Can I connect to Azure SQL Database?
Yes. SQLPro for MSSQL works with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Can I connect to Amazon RDS for SQL Server?
Yes. SQLPro for MSSQL supports Amazon RDS for SQL Server and SQL Server running on Amazon EC2 instances.
Does SQLPro for MSSQL support dark mode?
Yes. SQLPro for MSSQL supports dark mode on macOS, iOS, and Windows, and will follow your system appearance settings.
Can I import and export data?
Yes. SQLPro for MSSQL can import data from CSV, JSON, and SQL files, and export query results to CSV, JSON, XML, and SQL formats.
Does SQLPro for MSSQL support autocomplete?
Yes. The query editor includes syntax highlighting and autocomplete for table names, column names, stored procedures, and T-SQL keywords.
Does SQLPro for MSSQL support the GO batch separator?
Yes. SQLPro for MSSQL fully supports the GO batch separator, just like SQL Server Management Studio.
Can I run multiple queries at once?
Yes. SQLPro for MSSQL supports multiple result sets, so you can execute several queries and see all results displayed simultaneously.
Pricing
How much does SQLPro for MSSQL cost?
SQLPro for MSSQL offers monthly subscriptions, yearly subscriptions, and a one-time lifetime license. Visit the pricing page at macsqlclient.com/store for current prices.
Is there a free trial?
Yes. SQLPro for MSSQL offers a free trial so you can evaluate the app before purchasing. Download it from macsqlclient.com/download.
Is there a lifetime license option?
Yes. SQLPro for MSSQL offers a true lifetime license. This is a one-time purchase that includes all future updates at no additional cost.
Is SQLPro for MSSQL free for students?
Yes. Students with a valid student email address can request a free one-year license at sqlprostudio.com/edu/.
Does the iOS app require a separate purchase?
No. Monthly and yearly subscriptions include access on macOS, iOS, and Windows. You do not need to pay separately for the iOS app.
SQL Server
What is T-SQL?
T-SQL (Transact-SQL) is Microsoft's extension of the SQL language used by SQL Server. It adds features like local variables, error handling (TRY/CATCH), and procedural programming constructs to standard SQL.
What is the difference between SQL Server and MySQL?
SQL Server is developed by Microsoft and uses T-SQL. It is common in enterprise Windows environments. MySQL is open-source and popular for web applications. They use different SQL dialects and have different licensing models.
What is Azure SQL Database?
Azure SQL Database is a fully managed cloud database service from Microsoft. It provides SQL Server compatibility without the need to manage infrastructure. SQLPro for MSSQL connects to Azure SQL Database directly.
What is a stored procedure in SQL Server?
A stored procedure is a precompiled collection of T-SQL statements stored in the database. It can accept parameters, perform data modifications, and return results. Stored procedures execute on the server, reducing network round trips.
What is the GO batch separator?
GO is a batch separator used by SQL Server tools (including SSMS and SQLPro for MSSQL). It signals the end of a batch of T-SQL statements. GO is not a T-SQL statement itself -- it is a command recognized by the client tool.
What is a database index in SQL Server?
An index is a data structure that speeds up row lookups. SQL Server supports clustered indexes (which define the physical order of rows) and non-clustered indexes (which are separate lookup structures). Proper indexing is critical for query performance.
Comparisons
How does SQLPro for MSSQL compare to SQL Server Management Studio?
SSMS is Windows-only and free. SQLPro for MSSQL is a native macOS/iOS/Windows client that provides a similar workflow without needing a virtual machine on Mac. See the full comparison at macsqlclient.com/compare/ssms.
How does SQLPro for MSSQL compare to Azure Data Studio?
Azure Data Studio is a cross-platform Electron-based tool from Microsoft. SQLPro for MSSQL is a native app with faster startup and lower memory usage. See the full comparison at macsqlclient.com/compare/azure-data-studio.
How does SQLPro for MSSQL compare to DBeaver?
DBeaver is Java-based and supports many databases. SQLPro for MSSQL is a native, lightweight client focused on SQL Server with fast startup and low memory usage. See the full comparison at macsqlclient.com/compare/dbeaver.
How does SQLPro for MSSQL compare to DataGrip?
DataGrip is a full JetBrains IDE with advanced refactoring and VCS features but high resource usage. SQLPro for MSSQL is a lightweight native client focused on database management. See the full comparison at macsqlclient.com/compare/datagrip.