Having more than one database in dedicated sql pool

Question

Having more than one database in dedicated sql pool

Senthil 36

Hi All,

Is it possible to have more than one database in a single dedicated SQL pool or should we create new dedicated pool for each database?

Could someone please help me out on this one?

Note: Having more than one schema approach won't work as of now due to the product requirements

Regards,
Senthil

PRADEEPCHEEKATLA 91,861 Reputation points

2021-05-24T09:34:20.403+00:00

Hello @Senthil ,

Thanks for the question and using MS Q&A platform.

We are reaching out to product team to get confirmation on this ask and will update you as soon as we have a response.

Thank you for your patience.

Answer accepted by question author

0 additional answers

Your answer

PRADEEPCHEEKATLA 91,861 Reputation points

2021-05-24T09:34:20.403+00:00

Hello @Senthil ,

Thanks for the question and using MS Q&A platform.

We are reaching out to product team to get confirmation on this ask and will update you as soon as we have a response.

Thank you for your patience.

Answer 1

PRADEEPCHEEKATLA 91,861

Hello @Senthil ,

Thanks for the question and using MS Q&A platform.

Currently, this is not supported.

Every single dedicated SQL pool translates to one SQL database in the logical server.

Note: This feature (Synapse Gen3 or V3 (i.e., multi-clusters) where we will have multiple database support including cross-DB queries) is coming and I will let you know once it available.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

PRADEEPCHEEKATLA 91,861 Reputation points

2021-05-27T03:17:40.577+00:00

Hello @Senthil ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Shivendoo Kumar 761 Reputation points

2021-09-19T23:59:22.59+00:00

Do we have any updates on this?
PRADEEPCHEEKATLA 91,861 Reputation points

2021-09-20T05:39:28.437+00:00

Hi @Shivendoo Kumar ,

Not yet, it's coming.
Richard Landy 1 Reputation point

2021-09-21T07:46:42.38+00:00

Hi @PRADEEPCHEEKATLA ,

Do you have any ETA on when this feature will be in preview?
Is there another thread to follow, any more info would be really helpful.
Richard Landy 1 Reputation point

2021-09-21T07:48:48.197+00:00

Hi @PRADEEPCHEEKATLA ,

Do you have any ETA on when this feature will be in preview?
Is there another thread to follow, any more info would be really helpful.
PRADEEPCHEEKATLA 91,861 Reputation points

2021-09-21T08:23:36.3+00:00

Hi @Richard Landy ,

Not yet, it's coming and I will update this thread once it available.
MG 0 Reputation points

2023-04-13T08:21:39.72+00:00

Do we have any updates on this?
Shivendoo Kumar 761 Reputation points

2023-05-04T02:25:21.2666667+00:00

Hi,

Is there any update on this?
gb31 0 Reputation points

2023-10-04T05:12:57.47+00:00

Is there any update on this?

Share via

Having more than one database in dedicated sql pool

0 additional answers

Your answer