Best Mssql Client For Mac -mysql

Download SQuirreL SQL Client for free. A Java SQL client for any JDBC compliant database. SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. SQLPro for MSSQL is the Premier application for editing and viewing SQL Server databases on mac os x. What's the best tool for for managing an MS SQL Server database on Mac OS X? What is the best MySQL client for Mac OS X or Windows? Mac OS X Applications: What is the best ocean tide app for the Mac OS X menu bar? Navicat Essentials for SQL Server (Mac OS X) - SQL Server GUI tool - MS SQL management Navicat is an ideal solution for SQL Server administration and development. Navicat is an ideal solution for SQL Server administration and development. When you save your TeamSQL queries, they are then available to you no matter where you are. Powerful search functionality means that searching in the cloud is as easy as searching on your computer. TeamSQL allows you to save and manage Oracle, MySQL, PostgreSQL, Microsoft SQL Server, Amazon Redshift SQL files or Redis commands using the Cloud.

  1. Free Mysql Client For Mac

Native Microsoft SQL Server client for iOS. An Objective-C wrapper around the open-source FreeTDS library.

Sample Usage

Errors

FreeTDS communicates both errors and messages. SQLClient rebroadcasts both via NSNotificationCenter:

Type Conversion

SQLClient maps SQL Server data types into the following native Objective-C types:

  • bigint → NSNumber
  • binary(n) → NSData
  • bit → NSNumber
  • char(n) → NSString
  • cursor → not supported
  • date → NSDate or NSString
  • datetime → NSDate
  • datetime2 → NSDate or NSString
  • datetimeoffset → NSDate or NSString
  • decimal(p,s) → NSNumber
  • float(n) → NSNumber
  • image → NSData
  • int → NSNumber
  • money → NSDecimalNumber (last 2 digits are truncated)
  • nchar → NSString
  • ntext → NSString
  • null → NSNull
  • numeric(p,s) → NSNumber
  • nvarchar → NSString
  • nvarchar(max) → NSString
  • real → NSNumber
  • smalldatetime → NSDate
  • smallint → NSNumber
  • smallmoney → NSDecimalNumber
  • sql_variant → not supported
  • table → not supported
  • text → NSString*
  • time → NSDate or NSString
  • timestamp → NSData
  • tinyint → NSNumber
  • uniqueidentifier → NSUUID
  • varbinary → NSData
  • varbinary(max) → NSData
  • varchar(max) → NSString*
  • varchar(n) → NSString
  • xml → NSString

*The maximum length of a string in a query is configured on the server via the SET TEXTSIZE command. To find out your current setting, execute SELECT @@TEXTSIZE. SQLClient uses 4096 by default. To override this setting, update the maxTextSize property.

†The following data types are only converted to NSDate on TDS version 7.3 and higher. By default FreeTDS uses version 7.1 of the TDS protocol, which converts them to NSString. To use a higher version of the TDS protocol, add an environment variable to Xcode named TDSVER. Possible values are4.2, 5.0, 7.0, 7.1, 7.2, 7.3, 7.4, auto.A value of auto tells FreeTDS to use an autodetection (trial-and-error) algorithm to choose the highest available protocol version.

  • date
  • datetime2
  • datetimeoffset
  • time

Testing

The SQLClientTests target contains integration tests which require a connection to an instance of SQL Server. The integration tests have passed successfully on the following database servers:

  • SQL Server 7.0 (TDS 7.0)
  • SQL Server 2000 (TDS 7.1)
  • SQL Server 2005 (TDS 7.2)
  • SQL Server 2008 (TDS 7.3)
  • TODO: add more!

To configure the connection for your server:

  • In Xcode, go to Edit Scheme... and select the Test scheme.
  • On the Arguments tab, uncheck Use the Run action's arguments and environment variables
  • Add the following environment variables for your server. The values should be the same as you pass in to the connect: method.
    • HOST (serverinstance:port)
    • DATABASE (optional)
    • USERNAME
    • PASSWORD

Free Mysql Client For Mac

Known Issues

PR's welcome!

  • strings: FreeTDS incorrectly returns an empty string ' for a single space ' '
  • money: FreeTDS will truncate the rightmost 2 digits.
  • OSX support: FreeTDS-iOS needs to be compiled to support OSX and Podspec updated
  • No support for stored procedures with out parameters (yet)
  • No support for returning number of rows changed (yet)
  • Swift bindings: I welcome a PR to make the API more Swift-friendly

##Demo ProjectOpen the Xcode project inside the SQLClient folder.

Installation

CocoaPods

CocoaPods is the preferred way to install this library.

  1. Open a Terminal window. Update RubyGems by entering: sudo gem update --system. Enter your password when prompted.
  2. Install CocoaPods by entering sudo gem install cocoapods.
  3. Create a file at the root of your Xcode project folder called Podfile.
  4. Enter the following text: pod 'SQLClient', '~> 1.0.0'
  5. In Terminal navigate to this folder and enter pod install.
  6. You will see a new SQLClient.xcworkspace file. Open this file in Xcode to work with this project from now on.

Manual

  1. Drag and drop the contents of the SQLClient/SQLClient/SQLClient folder into your Xcode project.
  2. Select Copy items into destination group's folder (if needed).
  3. Go to Project > Build Phases > Link Binary With Libraries.
  4. Click + and add libiconv.dylib.
Windows

Documentation

Credits

FreeTDS:http://www.freetds.org

FreeTDS-iOS:https://github.com/patchhf/FreeTDS-iOS

FreeTDS example code in C:http://freetds.schemamania.org/userguide/samplecode.htm

SQL Server Logo© Microsoft

-->

APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

To manage (query, monitor, etc.) your database you need a tool. While your databases can be running in the cloud, on Windows, or on Linux, your tool doesn't need to run on the same platform as the database.

There are many database tools available, so this article provides descriptions and pointers to some of the available tools for working with your SQL databases. If you need help deciding which tool you need, see Which tool should I use?.

GUI tools to manage databases

The following are the main graphical user interface (GUI) tools:

ToolDescriptionRuns on
Azure Data StudioAzure Data Studio is a free, light-weight tool, for managing databases wherever they're running. This preview release provides database management features, including an extended Transact-SQL editor and customizable insights into the operational state of your databases.Azure Data Studio runs on Windows, macOS, and Linux.
SQL Server Management Studio (SSMS)Use SQL Server Management Studio (SSMS) to query, design, and manage your SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.SSMS runs on Windows.
SQL Server Data Tools (SSDT)Turn Visual Studio into a powerful development environment for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.SSDT runs on Windows.
Visual Studio CodeAfter installing Visual Studio Code, install the mssql extension for developing Microsoft SQL Server, Azure SQL Database, and SQL Data Warehouse.Visual Studio Code runs on Windows, macOS, and Linux.

Command line tools to manage databases

The following are the main command-line tools:

ToolDescriptionRuns on
mssql-cli (preview)mssql-cli is an interactive command-line tool for querying SQL Server.Windows, macOS, and Linux
sqlpackagesqlpackage is a command-line utility that automates several database development tasks. macOS and Linux versions of sqlpackage are currently in preview.Windows, macOS, and Linux
SQL Server PowerShellSQL Server PowerShell provides cmdlets for working with SQLWindows, macOS, and Linux
sqlcmdsqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.Windows, macOS, and Linux
bcpThe bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.Windows, macOS, and Linux
mssql-scripter (preview)mssql-scripter is a multi-platform command line experience for scripting SQL Server databasesWindows, macOS, and Linux
mssql-confmssql-conf configures SQL Server running on Linux.Linux

Which tool should I choose?

  • Do you want to manage a SQL Server instance or database, in a light-weight editor on Windows, Linux or Mac? Choose Azure Data Studio
  • Do you want to manage a SQL Server instance or database on Windows with full GUI support? Choose SQL Server Management Studio (SSMS)
  • Do you want to create or maintain database code, including compile time validation, refactoring and designer support on Windows? Choose SQL Server Data Tools (SSDT)
  • Do you want to query SQL Server with a command-line tool that features IntelliSense, syntax high-lighting, and more? Choose mssql-cli
  • Do you want to write T-SQL scripts in a light-weight editor on Windows, Linux or Mac? Choose Visual Studio Code and the mssql extension

Additional tools

ToolDescription
Configuration ManagerUse SQL Server Configuration Manager to configure SQL Server services and configure network connectivity. Configuration Manager runs on Windows
SQL Server Migration AssistantUse SQL Server Migration Assistant to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and Sybase.
Database Experimentation AssistantUse Database Experimentation Assistant to evaluate a targeted version of SQL for a given workload.
Distributed ReplayUse the Distributed Replay feature to help you assess the impact of future SQL Server upgrades. Also use Distributed Replay to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
ssbdiagnoseThe ssbdiagnose utility reports issues in Service Broker conversations or the configuration of Service Broker services.

If you're looking for additional tools that are not mentioned on this page, see SQL Command Prompt Utilities.