This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
I want to move all the data from one warehouse to another warehouse in the same workspace, items like views, sp, tables etc. Are there any ways to achieve this ?
Any specific reason why not restore the warehouse as a new warehouse and you want to copy only tables, views and Sps?
that's a good workaround @Nandan Hegde but I have created a new warehouse with case insensitive string setting and now I want all my data from previous warehouse to my new custom collated warehouse.
Want to know if i do restore the warehouse as new warehouse so can I use my custom collated warehouse ?
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Just checking in to see if the below answer provided by @ Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Similar thread :
for restoring :
https://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool
Best way to sync data would be via ADF/data pipelines and code is via DACPAC
Hey ,
In case if the collations are different, then plz follow the below steps :
export the SQL database project and generate DACPAC from the original warehouse
Deploy the DACPAC to the new warehouse.
This would sync the schemas by creating tables, views and SPs
Post that create a data pipeline to sync data from 1 warehouse to another for all tables
Just checking in to see if the above answer provided by @ Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.