Dumping mssql db from one server and restoring on another on Mac/Linux
In SQL Server you use BACKUP and RESTORE commands for this.  These both read and write files relative to the server, not the client.  So you'll need to write the backup to a storage location accessible to both SQL Server instances.  Backups can be written to and read from the local filesystem, SMB shares, or Azure Blob Storage.