---
title: "GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/syncDatabaseIds"
method: GET
path: "/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/syncDatabaseIds"
tags: ["SyncGroups"]
---

# GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/syncDatabaseIds

`GET /subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/syncDatabaseIds`

Gets a collection of sync database ids.

## Path parameters

- `locationName` string, required
- `subscriptionId` string, required

## Query parameters

- `api-version` string, required

## Response `200`

Successfully retrieved collection of sync database ids.

- SyncDatabaseIdListResult — A list of sync database ID properties.
  - `value` SyncDatabaseIdProperties[] — Array of results.
    - `id` string — ARM resource id of sync database.
  - `nextLink` string — Link to retrieve next page of results.

## Other responses

- `default` — *** Error Responses: *** * 400 InvalidSyncGroupCreateOrUpdateRequest - The create or update sync group request body is empty. * 400 InvalidSyncMemberCreateOrUpdateRequest - The create or update sync member request body is empty. * 400 InvalidSyncAgentCreateOrUpdateRequest - The create or update sync agent request body is empty. * 400 InvalidDatabaseResourceId - Invalid database resource identifier. * 400 MismatchingSubscriptionWithUrl - The provided subscription did not match the subscription in the Url. * 400 InvalidSyncAgentResourceId - Invalid sync agent resource identifier. * 400 MismatchingResourceGroupNameWithUrl - The provided resource group name did not match the name in the Url. * 400 MismatchingServerNameWithUrl - The provided server name did not match the name in the Url. * 404 SubscriptionDoesNotHaveServer - The requested server was not found * 404 DatabaseDoesNotExist - User has specified a database name that does not exist on this server instance.

---

[API](https://skmtc.dev/azure/apis/sqlmanagementclient-b3f09239.md) · [All operations](https://skmtc.dev/azure/apis/sqlmanagementclient-b3f09239/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/sqlmanagementclient-b3f09239/revisions/61e7e0b93827/schema)