azure 导入 bak_使用Azure Data StudioSQL Server数据导入

azure 导入 bak

Azure Data Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW.

Azure Data Studio是一个基于GUI的新工具，可在Windows，Mac OS和Linux操作系统上使用。 它连接到SQL Server，Azure数据库和SQL DW。

Database administrators and developers use SQL Server Management Studio to import the data into SQL Server. Is there any way to do so in Azure Data Studio? Let us explore this in further sections of the article.

数据库管理员和开发人员使用SQL Server Management Studio将数据导入SQL Server。 在Azure Data Studio中有什么方法可以这样做吗？ 让我们在本文的其他部分中对此进行探讨。

先决条件： (Prerequisite:)

Before we move further, you can go through below articles to get an overview of Azure Data Studio.

在继续进行操作之前，您可以阅读下面的文章以概述Azure Data Studio。

Getting started with Azure Data Studio; initial installation and configuration

Azure Data Studio入门； 初始安装和配置

In this article, we are going to explore the below points

在本文中，我们将探讨以下几点

• Extensions in Azure Data Studio
  Azure Data Studio中的扩展
• Importing data into SQL database using Azure Data Studio
  使用Azure Data Studio将数据导入SQL数据库
• Common errors
  常见错误

Azure Data Studio发行版本信息 (Azure Data Studio release versions information)

If you want to know about installed Azure Data Studio version, click on Help ->about

如果您想了解已安装的Azure Data Studio版本，请单击“帮助”->“关于”

We can see detailed information about Azure Data Studio release version.

我们可以查看有关Azure Data Studio发行版本的详细信息。

Azure Data Studio provides new functionality through the Extensions. Extensions provide a nice way to add more functionality to the base Azure Data Studio product.

Azure Data Studio通过扩展提供了新功能。 扩展提供了一种向基本Azure Data Studio产品添加更多功能的好方法。

Some of the important extensions available in the Azure Data Studio are as below:

Azure Data Studio中可用的一些重要扩展如下：

Extension	Comment
Redgate SQL Search	SQL Search is a free add-in that lets quickly search for SQL across databases
Server Reports	This gives information about server performance with below reports DB Space Usage DB Buffer Usage CPU Utilization Backup Growth Trend Wait counts
SQL Server Profiler	We can use this extension to trace SQL similar to SSMS Profiler.
SQL Server Agent	SQL Server Agent extension gives the ability to manage and troubleshoot SQL Server Agent jobs, alerts, operators, proxy etc.
SSMS Keymap	We can get SSMS keyboard shortcuts using this extension.
SQL Server Import	It allows importing flat files (.csv, .txt) or JSON files into SQL Server database.

延期	评论
Redgate SQL搜索	SQL搜索是一个免费的加载项，可让您跨数据库快速搜索SQL。
服务器报告	这将通过以下报告提供有关服务器性能的信息 数据库空间使用 数据库缓冲区使用率 CPU利用率 备份增长趋势 等待计数
SQL Server探查器	我们可以使用此扩展来跟踪类似于SSMS ProfilerSQL。
SQL Server代理	SQL Server代理扩展使您能够管理SQL Server代理作业，警报，操作员，代理等并进行故障排除。
SSMS按键图	我们可以使用此扩展名获得SSMS键盘快捷键。
SQL Server导入	它允许将平面文件（.csv，.txt）或JSON文件导入SQL Server数据库。

SQL Server Management Studio (SSMS) is one of the most important tools for SQL Server DBA’s and Developers to complete their work on a daily basis. In my previous tip, SQL Server management studio import wizard, we learned that SQL Server Management Studio Flat Fi