Skip to content

Latest commit

 

History

History
43 lines (31 loc) · 1.86 KB

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

File metadata and controls

43 lines (31 loc) · 1.86 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection f1_keywords helpviewer_keywords
Project Settings (Azure SQL Database) (AccessToSQL)
Project Settings (Azure SQL Database) (AccessToSQL)
cpichuka
cpichuka
01/19/2017
sql
ssma
conceptual
sql-migration-content
ssma.access.projectsettingssqlazure.f1
Project Settings dialog box, SQL Azure
SQL Azure settings

Project Settings (Azure SQL Database) (AccessToSQL)

The SQL Azure project settings let you configure the Azure SQL 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'.