Lokasi ngalangkungan proxy:   [ UP ]  
[Ngawartoskeun bug]   [Panyetelan cookie]                
Skip to content

Latest commit

 

History

History
62 lines (47 loc) · 2.08 KB

File metadata and controls

62 lines (47 loc) · 2.08 KB
title Manage SQL Server on Linux | SQL Server vNext CTP1
description
author rothja
ms.author jroth
manager jhubbard
ms.date 10-19-2016
ms.topic article
ms.prod sql-non-specified
ms.service
ms.technology
ms.assetid

Manage SQL Server on Linux

There are several ways to manage your SQL Server vNext CTP1 instances and databases running on Linux. This topic provides and orientation of the techniques and tools used for management with pointers to additional information. It also provides a list of common management tasks with links to additional information.

Management tools

The following tools can be used to help manage SQL Server on Linux.

Transact-SQL (TSQL)

T-SQL commands cover many management tasks and DMVs provide detailed monitoring information. Link to additional resources. Can be run from sqlcmd.exe, VS Code, or any other supported T-SQL client to SQL Server. Point to new cross platform DMVs. Talk about mapping of C: for some commands.

DMVTool

Show how DMVTool is a Linux-specific way of working with DMVs on the file system.

SqlPackage

Tool for exporting and importing databases.

SQL Server Management Studio (Windows client)

Talk about the ability to connect to SQL Server on Linux from Windows. Firewall and port requirements. General steps for getting started with screenshot of object browser (mabye numbered).

Management tasks

The following table provides a list of some common management tasks along with a pointer to more information.

Task Description
Backup and Restore TBD with links
etc. etc.

Next Steps

TBD