Azure Data Warehouse User User Database

Question

I have procedures in my Azure data warehouse that need to create other Azure databases and then populate them with data from DW. Is there a way to store a stored procedure in an Azure data warehouse to create a separate Azure database? Then maybe create tables and populate them in this newly created Azure database?

Answer 1

You cannot create sqldatabase from stored procedures. Even if they are on the same server. We are dealing with two different logical servers (DW and SQLdatabase).

2. , azureDW SQLAzure ..

, .

Windows,   sqlazure,
 2. SQLdatabase,
 3. SQLDW SQLdatabase

Answer 2

SqlBulkCopy. .

- Elastic Database Jobs.