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

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.

Having more than one database in dedicated sql pool

Accepted answer

PRADEEPCHEEKATLA-MSFT 89,646 Reputation points Microsoft Employee

2021-05-25T05:23:04.247+00:00

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.
Please sign in to rate this answer.

3 people found this answer helpful.
PRADEEPCHEEKATLA-MSFT 89,646 Reputation points Microsoft Employee

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 741 Reputation points

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

Do we have any updates on this?

PRADEEPCHEEKATLA-MSFT 89,646 Reputation points Microsoft Employee

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-MSFT ,

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-MSFT ,

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-MSFT 89,646 Reputation points Microsoft Employee

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 741 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?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Having more than one database in dedicated sql pool

0 additional answers

Your answer