고정 헤더 영역
상세 컨텐츠
본문
- Jun 14, 2016 Create License key, Activation Key, Serial Key Maker, Generate Product Key, Validate a software License Key in C#.NET. The C# Basics beginner course is a free C# Tutorial Series that helps.
- First time Data Studio users: If you have not used Data Studio before, you will be asked to authorize Data Studio to your account and agree to the terms and conditions. Complete the authorization process. When you first use Data Studio, you may also see a pop-up that asks to update your marketing preferences, go ahead and update them.
-->
Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with built-in charting of query result sets and customizable dashboards.
The source code for Azure Data Studio and its data providers is available on GitHub under a source code EULA that provides rights to modify and use the software, but not to redistribute it or host it in a cloud service. For more information, see Azure Data Studio FAQ.
SQL code editor with IntelliSense
“Aqua Data Studio is a single tool that manages all of our databases. We can edit SQL, and extract and visualize data all from within Aqua Data Studio only.” Kuiran Du, Business Analyst, Huawei Technologies Co., Ltd. (Large Enterprise, Telecommunications Equipment, Bahrain) TVID FE8-79A-C4F.
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. To learn how to use the SQL editor, see Use the SQL editor to create database objects.
Smart SQL code snippets
SQL code snippets generate the proper SQL syntax to create databases, tables, views, stored procedures, users, logins, roles, and to update existing database objects. Use smart snippets to quickly create copies of your database for development or testing purposes, and to generate and execute CREATE and INSERT scripts.
Azure Data Studio also provides functionality to create custom SQL code snippets. To learn more, see Create and use code snippets.
Customizable Server and Database Dashboards
Create rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases. To learn about insight widgets, and database (and server) dashboards, see Manage servers and databases with insight widgets.
Connection management (server groups)
Server groups provide a way to organize connection information for the servers and databases you work with. For details, see Server groups.
Integrated Terminal
Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, and ssh) in the Integrated Terminal window right within the Azure Data Studio user interface. To learn about the integrated terminal, see Integrated terminal.
Extensibility and extension authoring
Enhance the Azure Data Studio experience by extending the functionality of the base installation. Azure Data Studio provides extensibility points for data management activities, and support for extension authoring.
To learn about extensibility in Azure Data Studio, see Extensibility.To learn about authoring extensions, see Extension authoring.
Feature comparison with SQL Server Management Studio (SSMS)
Use Azure Data Studio if you:
- Need to run on macOS or Linux
- Are connecting to a SQL Server 2019 big data cluster
- Spend most of your time editing or executing queries
- Need the ability to quickly chart and visualize result sets
- Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell
- Have minimal need for wizard experiences
- Don't need to do deep administrative configuration
Use SQL Server Management Studio if you:
- Spend most of your time on database administration tasks
- Are doing deep administrative configuration
- Are doing security management, including user management, vulnerability assessment, and configuration of security features
- Make use of the Reports for SQL Server Query Store
- Need to make use of performance tuning advisors and dashboards
- Are doing Import/Export of DACPACs
- Need access to Registered Servers and want to control SQL Server services on Windows
Why Need Data Studio Key To Generate Key
Shell
| Feature | Azure Data Studio | SSMS |
|---|---|---|
| Azure Sign-In | Yes | Yes |
| Dashboard | Yes | |
| Extensions | Yes | |
| Integrated Terminal | Yes | |
| Object Explorer | Yes | Yes |
| Object Scripting | Yes | Yes |
| Project System | Yes | |
| Select from Table | Yes | Yes |
| Source Code Control | Yes | |
| Task Pane | Yes | |
| Theming | Yes | |
| Dark Mode | Yes | |
| Azure Resource Explorer | Preview | |
| Generate Scripts Wizard | Preview | |
| Import/Export DACPAC | Yes | |
| Object Properties | Preview | |
| Table Designer | Yes |
Query editor
| Feature | Azure Data Studio | SSMS |
|---|---|---|
| Chart Viewer | Yes | |
| Export Results to CSV, JSON, XLSX | Yes | |
| IntelliSense | Yes | Yes |
| Snippets | Yes | Yes |
| Show Plan | Preview | Yes |
| Client Statistics | Yes | |
| Live Query Stats | Yes | |
| Query Options | Yes | |
| Results to File | Yes | |
| Results to Text | Yes | |
| Spatial Viewer | Yes | |
| SQLCMD | Yes | |
| Notebooks | Yes | |
| Save Query as snippet | Yes |
Operating system support
| Feature | Azure Data Studio | SSMS |
|---|---|---|
| Linux | Yes | |
| macOS | Yes | |
| Windows | Yes | Yes |
Data engineering
| Feature | Azure Data Studio | SSMS |
|---|---|---|
| Create External Table Wizard | Yes | |
| HDFS Integration | Yes | |
| Notebooks | Yes |
Database administration
| Feature | Azure Data Studio | SSMS |
|---|---|---|
| Backup / Restore | Yes | Yes |
| Big Data Cluster Support | Yes | |
| Flat File Import | Preview | Yes |
| SQL Agent | Preview | Yes |
| SQL Profiler | Preview | Yes |
| Always On | Yes | |
| Always Encrypted | Yes | |
| Copy Data Wizard | Yes | |
| Database Engine Tuning Advisor | Yes | |
| Error Log Viewer | Yes | |
| Maintenance Plans | Yes | |
| Multi-Server Query | Yes | |
| Policy-Based Management | Yes | |
| PolyBase | Yes | |
| Query Store | Yes | |
| Registered Servers | Yes | |
| Replication | Yes | |
| Security Management | Yes | |
| Service Broker | Yes | |
| SQL Mail | Yes | |
| Template Explorer | Yes | |
| Vulnerability Assessment | Yes | |
| XEvent Management | Yes | |
| SQL Assessment API Integration | Yes |
Next steps
Get help for SQL tools
Contribute to SQL documentation
Did you know that you could edit the content yourself? If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.
Product overview
These resources provide an overview of IBM Data Studio.
-
IBM Data Studio product page: Get an overview of Data Studio and its features and benefits from this web page.
-
IBM Data Studio features: by component and data server: View this web page for a list of the features of Data Studio supported for various data servers.
-
What's new and changed in IBM Data Studio: Learn about the new enhanced capabilities of Data Studio from this web page. You can also view details about changed or deprecated features.
-
Getting started with IBM Data Studio for DB2: This free ebook explains how to install the Data Studio components, how to get started, and how to do key administration and application development tasks with Data Studio.
-
Getting started in IBM Data Studio: This topic explains how the Data Studio client and web console components work together, and how to set up Data Studio in a team environment.
-
Overview of IBM Data Studio: Read this topic to learn about IBM Data Studio, which consists of the client and web console. Use the client for database and database instance administration, application development, and query tuning tasks. Use the web console to monitor health and availability and to create and manage jobs.
-
IBM Data Studio information center: The information center contains overview, conceptual, and task information for Data Studio.
Solutions
Use these resources for information about database management solutions.
-
Overview of the InfoSphere Optim data management solution: Learn about the integrated tools that can help you with your tasks and responsibilities throughout the data lifecycle.
Planning
Before you install Data Studio, consult the following resources.
-
System requirements for IBM Data Studio: This web page lists the hardware and software requirements for installing and running Data Studio.
-
Mapping between Control Center and Data Studio capabilities: If you are familiar with the DB2 Control Center, this topic provides a mapping between the tasks that you did in the Control Center to the features of Data Studio and other tools you can use for those tasks.
-
Migrating from DB2 Control Center to IBM Data Studio: Learn how DB2 users can transition from the deprecated DB2 Control Center to Data Studio to perform the same administration tasks and more.
-
Limitations for sharing a common environment between IBM products based on Eclipse: See this web page to learn about the problems that might occur when you use Installation Manager to install certain Eclipse-based products, including Data Studio, into a shell-shared group.
-
Virtualizing InfoSphere Optim database tools with Citrix XenApp: Learn how to provide virtualized access to Data Studio and other Optim tools on a Citrix XenApp server so that users can perform application development tasks.
Installing
The following resources will help you to install the Data Studio components.
-
Download IBM Data Studio: You can download the product from this web page.
-
Installing IBM Data Studio client: Use this topic as the starting point for installing the Data Studio client.
-
Installing and configuring Data Studio web console: Use this topic as the starting point for installing the Data Studio web console.
Configuring
The following information center topics will help you configure the Data Studio components.
-
Setting up your work environment for database tasks: Learn how to connect to databases, create data development and design projects, and configure a team environment for your Data Studio work environment.
-
Configuring DB2 databases and subsystems for use with no-charge tuning features in IBM Data Studio: Learn about the facilities and objects you must enable on a DB2 data server before you can use Data Studio to tune single SQL statements that run on the data server.
-
Configuring the web console: Learn how you can enable access to the Data Studio web console by performing important security tasks, including resetting the default password and updating secure login certificates.
Designing
Consult these resources to understand how logical design and database modeling help to create an effective data management system.
-
Working with data diagrams: Use this topic to learn how you can use data diagrams in Data Studio to visualize and edit your data projects.
-
Modifying physical data models: This topic explains how to modify database-specific models that represent your relational data objects and their relationships. You can use these models to generate DDL statements and deploy them to a data server.
-
InfoSphere Data Architect information roadmap: For more robust data modeling and data integration capabilities, you can use InfoSphere Data Architect. This information roadmap provides links to key resources for that product.
Developing
Use these resources to learn how to best use Data Studio to develop database applications.
-
Creating scripts more efficiently in the SQL and XQuery editor: Read this article to learn how to use the features of this editor to enhance the capabilities of your database applications. The editor also gives you access to tools that help analyze and tune the performance of SQL queries.
-
Create, test, and deploy a DB2 SQL stored procedure: This tutorial explains how to create, test, deploy, and debug stored procedures on your data servers with Data Studio.
-
Developing web services with the workbench: Use this topic to learn how to use the Data Studio client to create and deploy web services that expose your database operations to client applications.
-
Developing Database Applications with IBM Data Studio and pureQuery: This intensive three-day course will teach you how to use Data Studio and InfoSphere® Optim™ pureQuery™ Runtime tools to develop database applications.
-
InfoSphere Optim pureQuery Runtime information roadmap: Data Studio includes a copy of IBM InfoSphere Optim pureQuery Runtime for use on the same computer as the Data Studio client, which you can use to build high-quality, better-performing database applications. This information roadmap provides links to key resources for that product.
Administering
Use these resources to help you administer and manage databases with Data Studio.
-
Administering databases with task assistants: This topic provides the main steps and illustrations to show how to use any task assistant in Data Studio. You use task assistants to create and run database administration commands.
-
Managing and scheduling database jobs with the Data Studio Web Console: This tutorial describes how to schedule and automate database operations with the job manager in the Data Studio web console.
-
Creating and managing jobs: Read this topic to learn how to create, schedule, and manage jobs with the Data Studio web console job manager. You can also perform some job-related tasks with the Data Studio client components if you configure them to work with the web console.
-
Use database catalog filtering in IBM Data Studio to view, manage, and work with database objects efficiently: This article describes a new Data Studio capability that filters a vast amount of cached metadata to significantly enhance the network and tool performance for object management tasks.
-
Scenario: Making basic database object changes with a change plan: This topic provides steps and illustrations for a scenario in which you make a change to the sample GSDB database. In the scenario, you use the change plan feature to contain the changes, identify impacted objects, and generate the command to apply the change.
-
Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio: This article explains how to use Data Studio to perform database backups, keep statistics current, and reorganize tables and indices as necessary on a DB2 data server.
Tuning
These resources can help you tune SQL statements to improve query and workload performance.
-
Tuning single SQL statements: This topic provides an overview of the steps that are involved in tuning single SQL statements with Data Studio.
-
Formatting SQL statements: This topic explains how to use the workflow assistant for query tuning in Data Studio to format an SQL statement so that you can better understand the structure of that statement.
-
Generating visual representations of access plans: This topic explains how the workflow assistant for query tuning in Data Studio can display the access plan for a statement as a diagram.
-
InfoSphere Optim Query Tuner and InfoSphere Optim Workload Query Tuner information roadmap: For a more in-depth set of solutions to improve the performance of queries and query workloads, you can use InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner. This information roadmap provides links to key resources for those product.
Monitoring
These resources explain how you can analyze database activity and performance.
-
Monitoring database health and availability: Use this topic to learn how to keep track of the health information of your databases with the Data Studio web console.
-
Optim Performance Manager information roadmap: For a more comprehensive set of tools to identify, diagnose, solve, and prevent database performance problems, you can use Optim Performance Manager. This information roadmap provides links to key resources for that product.
Troubleshooting
These resources provide you with information about identifying and resolving problems with Data Studio.
Why Need Data Studio Key To Generate Free
-
IBM Data Studio software support: Consult this web page for general support information regarding Data Studio.
-
Troubleshooting and support: Use these topics for troubleshooting database administration tasks and for details about contacting and gathering information for IBM Support.
