Forum Discussion

ObungiNiels's avatar
ObungiNiels
Resolver III
1 year ago
Solved

Deployment Process for Warehouse Projects

Hello fellow warehouse users,    I have a quite plain question: How are you realizing deployments processes of warehouses which are loaded with stored procedure definitions etc.?    In the past, ...
data warehouse
Warehouse
stuckerj's avatar
stuckerj
Helper I
7 months ago

Thanks!  This for simple backup and restore capabilities of the entire warehouse including multiple schemas--both for deployment pipeline and disaster recovery purposes.

 

I'm considering creating a Notebook with script to loop through the tables and copy the data. 

 

Any other options you'd recommend to consider?

Srisakthi's avatar
Srisakthi
Super User
7 months ago

Hi stuckerj ,

If you have schema deployed at target warehouse then you can try using and it works when both warehouses are in same workspace 

INSERT INTO targetwarehouse.[dbo].[table]
SELECT * FROM sourcewarehouse.[dbo].[table];
 
Regards,
Srisakthi