Dışarıya aktar (0) Yazdır
Tümünü Genişlet
EN
Bu içerik dilinizde bulunmamaktadır ancak İngilizce sürümüne buradan bakabilirsiniz.
4 / 5 bunu faydalı olarak değerlendirdi - Bu konuyu değerlendir

Tools and Utilities Support (Azure SQL Database)

Updated: April 4, 2014

A variety of tools and utilities can be used with Windows Azure SQL Database. They are described in the following headings:

For solutions to common customer problems with Azure SQL Database, SQL Server Data Tools, and SQL Server Management Studio, see Database Lifecycle Management.

The sqlcmd Utility

The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Query Editor in sqlcmd mode, or in a Windows script file. sqlcmd can also run in an operating system (cmd.exe) job step of a SQL Server Agent job running on an on-premise instance of SQL Server. The sqlcmd utility uses OLE DB to execute Transact-SQL batches. For information related to using sqlcmd with Windows Azure SQL Database, see How to: Connect to Azure SQL Database Using sqlcmd.

Note The sqlcmd utility is supported by SQL Database, but a similar utility, named osql is not supported.

For more information about the sqlcmd Utility, see sqlcmd Utility in SQL Server Books Online.

Sql server Management Studio

Beginning with SQL Server 2008 R2 and SQL Server 2008 R2 Express, SQL Server Management Studio can be used to access, configure, manage and administer SQL Databases. Previous versions of SQL Server Management Studio are not supported.

SQL Server Management Studio combines graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators. For more information, see Using SQL Server Management Studio in SQL Server Books Online.

The Azure Platform Management Portal

You can use the Azure Platform Management Portal to provision your SQL Database servers, create logins, and configure the SQL Database firewall. In addition, you can create user databases in your servers, or export and import data-tier application export files (BACPAC). The portal also gives you an at-a-glance view of the health of your SQL Database servers. For more information about the Azure Platform Management Portal, see The New Management Portal.

The Management Portal for SQL Database

You can use the web-based Management Portal for SQL Database to manage SQL Databases and data-tier applications. You can create or drop databases. You can deploy a data-tier application package to create a user database, or extract a DAC package from an existing database. The portal supports basic database management tasks like designing and editing tables, views, and stored procedures, and authoring and running Transact-SQL queries. For more information, see Management Portal for Azure SQL Database.

Data-tier Applications

You can use data-tier applications (DACs) to collect the data-tier schemas and objects used by an application into a DAC package. The package forms a single unit for the design, deployment, and management of the schemas and objects. For more information, see Data-tier Applications in SQL Server Books Online.

SQL Database supports deleting, deploying, extracting, registering, and in-place upgrades of DACs. SQL Database also supports exporting the schema and data of a database as a DAC export file (BACPAC), which can then be imported to another SQL Database server or an instance of the SQL Server Database Engine.

You can use the Azure Management Portal to export and import DACs. You can use the Management Portal for SQL Database to extract and deploy DAC packages.

You can use the client utilities in SQL Server 2012 (or later) to perform all DAC operations in SQL Database. The client utilities in older versions of SQL Server or Microsoft Visual Studio support all DAC operations in SQL Database, except for export and import.

Generate and Publish Scripts Wizard

You can use the Generate and Publish Scripts Wizard to transfer a database from a local computer to Windows Azure SQL Database. For more information, see How to: Migrate a Database by Using the Generate Scripts Wizard (Azure SQL Database).

The Generate and Publish Scripts Wizard creates Transact-SQL scripts for your local database and the wizard uses them to publish database objects to Windows Azure SQL Database. For more information, see Using the Generate and Publish Scripts Wizard in SQL Server Books Online.

There is a new engine-type parameter for Windows Azure SQL Database. When you are scripting a database and the destination is Windows Azure SQL Database, set the engine parameter to SQL Database so that the Generate and Publish Scripts Wizard creates Transact-SQL that is compatible with Windows Azure SQL Database.

SQL Server Integration Services

You can transfer data to Windows Azure SQL Database by using SQL Server 2008 Integration Services (SSIS).

SQL Server 2008 R2 or later supports bulk copy for the transfer of data between an instance of Microsoft SQL Server and Windows Azure SQL Database.

The bcp Utility

You can transfer data to Windows Azure SQL Database by using the bulk copy utility (BCP.exe). The bcp utility bulk copies data between an instance of 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.

Starting with SQL Server 2008 R2, the bcp utility supports the queryout argument. When you use the queryout argument, make sure to append –d database_name argument, or the bcp utility will not be able to connect to the SQL Database.

For more information, see bcp Utility in SQL Server Books Online.

SQL Server Analysis Services

Starting with SQL Server 2008 R2, using SQL Database as a data source when running SQL Server Analysis Services on-premises is supported.

SQL Server Reporting Services

Starting with SQL Server 2008 R2, using SQL Database as a data source when running SQL Server Reporting Services on-premises is supported.

SQL Reporting

The Customer Technology Preview of SQL Reporting is also available. Azure SQL Reporting is a cloud-based reporting service built on Windows Azure SQL Database, SQL Server, and SQL Server Reporting Services technologies. You can publish, view, and manage reports that display data from SQL Database data sources.

SQL Server Management Objects (SMO)

A partial set of SQL Server Management Objects (SMO) are enabled by Windows Azure SQL Database. The partial set of SMO are only enabled in order to provide Management Studio access to SQL Database. These objects offer limited functionality and are not intended for use in applications. The following objects in the Microsoft.SqlServer.Management.Smo and Microsoft.SqlServer.Management.SqlParser.Intellisense namespaces are enabled:

 

Check

Index

Synonym

Column

IndexedColumn

Table

Database

Login

Trigger

DatabaseDdlTrigger

Schema

User

DatabaseRole

SystemDataType

UserDefinedDataType

DefaultConstraint

Server

UserDefinedFunction

ForeignKey

Statistic

UserDefinedTableType

ForeignKeyColumn

StatisticColumn

View

Parameter

StoredProcedure

If you use an object that is not supported, SMO will throw an exception. For more information, see SMO Exceptions (Azure SQL Database).

For more information about SQL Server Management Objects (SMO), see SQL Server Management Objects (SMO) in SQL Server Books Online.

SQL Server Migration Assistant (SSMA)

Starting with the SQL Server Migration Assistant 2008 for Access version 4.2 release, SSMA enables migrating Microsoft Access schema and data to Windows Azure SQL Database and adds support for Access 2010 databases.

In addition, the Microsoft SQL Server Migration Assistant 2008 for MySQL version 1.0 supports migrating MySQL schema and data to Windows Azure SQL Database.

For more information about SQL Server Migration Assistant (SSMA), see Migrating to SQL Server 2008 on the SQL Server Web site.

Microsoft Access

Microsoft Access 2010 supports connections to Windows Azure SQL Database over ODBC when used in conjunction with the latest SQL Server ODBC drivers. For more information, see Access 2010 and Azure SQL Database and Moving Access Data to the Cloud article in the TechNet Wiki.

PowerPivot for Excel

PowerPivot for Excel is an add-in that you can use to perform powerful data analysis in Excel 2010, bringing self-service business intelligence to your desktop. PowerPivot for Excel includes a window for adding and preparing data, and a PowerPivot tab on the Excel ribbon that you can use to manipulate the data in an Excel worksheet.

PowerPivot for Excel also includes a wizard that you can use to import data from SQL Databases. For more information, see PowerPivot for Excel in SQL Server Books Online.

See Also

Bunu faydalı buldunuz mu?
(1500 karakter kaldı)
Geri bildiriminiz için teşekkür ederiz

Topluluk İçeriği

Ekle
Show:
© 2014 Microsoft. Tüm hakları saklıdır.