For all those Mac users out there who have felt a bit left out because all their Windows counterparts were able to run SQL commands and they weren’t – that is about to change.
Microsoft has now introduced a preview of a set of SQL Server command-line tools for Mac users – specifically, sqlcmd and bcp.
The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server. The utility is extremely useful for repetitive database tasks such as batch processing or unit testing.
The bulk copy program utility (bcp), bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in San Francisco in 2017!