Skip to content

project-settings-azure-sql-db-accesstosql.md

Latest commit

 

History

History
41 lines (29 loc) · 1.78 KB

project-settings-azure-sql-db-accesstosql.md

File metadata and controls

41 lines (29 loc) · 1.78 KB
title Project Settings (Azure SQL DB) (AccessToSQL) | Microsoft Docs
ms.prod sql
ms.custom
ms.date 01/19/2017
ms.reviewer
ms.technology ssma
ms.topic conceptual
helpviewer_keywords
Project Settings dialog box, SQL Azure
SQL Azure settings
ms.assetid bbb8a204-d0e4-4f0b-9709-271feb1f136e
author Shamikg
ms.author Shamikg

Project Settings (Azure SQL DB) (AccessToSQL)

The SQL Azure project settings let you configure the SQL Azure database suffix to be added in the connection dialog and also allow implementing heartbeat mechanism in SQL Azure connection.

The SQL Azure pane is available in the Project Settings and Default Project Settings dialog boxes.

  • Use the Project Settings dialog box to set configuration options for the current project. To access the SQL Azure settings, on the Tools menu, select Project Settings, click General at the bottom of the left pane, and then select SQL Azure.

  • Use the Default Project Settings dialog box to set configuration options for all projects. To access the SQL Azure settings, on the Tools menu, select DefaultProject Settings, select the project type as "SQL Azure" in Migration Target Version combo box to access the settings in SQL Azure pane, click General at the bottom of the left pane, and then select SQL Azure.

Options

Connectivity

Heartbeat Interval

Specifies a time interval to be used for heartbeat mechanism to keep the SQL Azure connection alive in 'minutes : seconds' format.

Default Value:'4:45'

The value should be specified in 'm:ss' format (for example, '4:45' or '0:50').

SQL Azure Server Suffix

Specifies the SQL Azure server suffix

Default Value: 'database.windows.net'.