Skip to content

Latest commit

 

History

History
82 lines (50 loc) · 6.64 KB

connecting-to-azure-sql-db-sybasetosql.md

File metadata and controls

82 lines (50 loc) · 6.64 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Connecting to Azure SQL Database (SybaseToSQL)
Connecting to Azure SQL Database (SybaseToSQL)
cpichuka
cpichuka
11/16/2020
sql
ssma
conceptual
sql-migration-content

Connecting to Azure SQL Database (SybaseToSQL)

To migrate Sybase databases to [!INCLUDE ssazure-sqldb], you must connect to the target instance of [!INCLUDE ssazure-sqldb]. When you connect, SSMA obtains metadata about all the databases in the instance of [!INCLUDE ssazure-sqldb] and displays database metadata in the Azure SQL Database Metadata Explorer. SSMA stores information of the instance of [!INCLUDE ssazure-sqldb] you are connected to, but does not store passwords.

Your connection to [!INCLUDE ssazure-sqldb] stays active until you close the project. When you reopen the project, you must reconnect to [!INCLUDE ssazure-sqldb] if you want an active connection to the server. You can work offline until you load database objects into [!INCLUDE ssazure-sqldb] and migrate data.

Metadata about the instance of [!INCLUDE ssazure-sqldb] is not automatically synchronized. Instead, to update the metadata in Azure SQL Database Metadata Explorer, you must manually update the [!INCLUDE ssazure-sqldb] metadata. For more information, see the "Synchronizing Azure SQL Database Metadata" section later in this topic.

Required Azure SQL Database Permissions

The account that is used to connect to [!INCLUDE ssazure-sqldb] requires different permissions depending on the actions that the account performs:

  • To convert ASE objects to [!INCLUDEtsql] syntax, to update metadata from [!INCLUDE ssazure-sqldb], or to save converted syntax to scripts, the account must have permission to log on to the instance of [!INCLUDE ssazure-sqldb].

  • To load database objects into [!INCLUDE ssazure-sqldb], the account must be a member of the db_ddladmin database role.

  • To migrate data to [!INCLUDE ssazure-sqldb], the account must be a member of the db_owner database role.

  • To run the code that is generated by SSMA, the account must have EXECUTE permissions for all user-defined functions in the ssma_syb schema of the target database. These functions provide equivalent functionality of ASE system functions, and are used by converted objects.

Establishing an Azure SQL Database Connection

Before you convert Sybase database objects to [!INCLUDE ssazure-sqldb] syntax, you must establish a connection to the instance of [!INCLUDE ssazure-sqldb] where you want to migrate the Sybase database or databases.

When you define the connection properties, you also specify the database where objects and data will be migrated. You can customize this mapping at the Sybase schema level after you connect to Azure SQL Database. For more information, see Mapping Sybase ASE Schemas to SQL Server Schemas (SybaseToSQL).

Important

Before you try to connect to [!INCLUDE ssazure-sqldb], make sure that your IP address is allowed through the [!INCLUDE ssazure-sqldb] firewall.

To connect to [!INCLUDE ssazure-sqldb]:

  1. On the File menu, select Connect to Azure SQL Database(this option is enabled after the creation of a project). If you have previously connected to [!INCLUDE ssazure-sqldb], the command name will be Reconnect to Azure SQL Database.

  2. In the connection dialog box, enter or select the server name of [!INCLUDE ssazure-sqldb].

  3. Enter, select or Browse the Database name.

  4. Enter or select Username.

  5. Enter the Password.

  6. SSMA recommends encrypted connection to [!INCLUDE ssazure-sqldb].

  7. Click Connect.

Synchronizing Azure SQL Database Metadata

Metadata about [!INCLUDE ssazure-sqldb] databases is not automatically updated. The metadata in Azure SQL Database Metadata Explorer is a snapshot of the metadata when you first connected to Azure SQL Database, or the last time that you manually updated metadata. You can manually update metadata for all databases, or for any single database or database object. To synchronize metadata:

  1. Make sure that you are connected to [!INCLUDE ssazure-sqldb].

  2. In Azure SQL Database Metadata Explorer, select the check box next to the database or database schema that you want to update. For example, to update the metadata for all databases, select the box next to Databases.

  3. Right-click Databases, or the individual database or database schema, and then select Synchronize with Database.

Next Step

The next step in the migration depends on your project needs:

See Also

Migrating Sybase ASE Databases to SQL Server - Azure SQL Database (SybaseToSQL)