CODEWITHSUNDEEP
azureazure-elasticpoolazure-data-factory
Oleksii Klipilin
Oleksii Klipilin

Reputation: 1936

Azure Data Flow create many databases in SQL Elastic Pool from one database

I'm quite new in 'Azure'. Is it possible to create many databases in SQL Elastic Pool by Azure Data Factory (Data Flow)?

Given:

Table

Row1 | Value1
Row2 | Value2

After execution I need to get two databases in specific elastic pool. One DB named: "Value1", second DB named: "Value2".

Upvotes: 0

Views: 93

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

According my experience, Data Flow doesn't have the feature or component can help you create the databases. We can not do that with Data Flow.

With Data Factory, I have an idea is that you can create a stored procedure which create database in elastic pool with source column data in sink database, using Foreach to copy data from source table and call the stored procedure in sink.

Hope this helps.

Upvotes: 0

Related Questions