question

Senthil-9135 avatar image
2 Votes"
Senthil-9135 asked RichardLandy-1124 published

Having more than one database in dedicated sql pool

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

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Senthil-9135,

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.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered RichardLandy-1124 published

Hello @Senthil-9135,

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.

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Senthil-9135,

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.

1 Vote 1 ·

Do we have any updates on this?

0 Votes 0 ·

Hi @ShivendooKumar-8455,

Not yet, it's coming.

1 Vote 1 ·
RichardLandy-1124 avatar image RichardLandy-1124 PRADEEPCHEEKATLA-MSFT ·

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.

0 Votes 0 ·
RichardLandy-1124 avatar image RichardLandy-1124 PRADEEPCHEEKATLA-MSFT ·

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.

0 Votes 0 ·
Show more comments