Forum Discussion
dbmsoutput
Jan 07, 2024Copper Contributor
Copy schema (with data) from one Azure SQL database to another Azure SQL database
Hallo, We need copy 3 schemas (incl tables, indexes, keys and data) to another Azure SQL database. We decided to switch from 2 database to one more powerful. There is a lot of data, smallest dat...
dbmsoutput
Jan 18, 2024Copper Contributor
Javier_Villegas thank you.
SSMS and BCP are not real options, i tried but i need copy more than 1TB data. SSMS and BCP from cliënt are very slow. Both our databases are Azure SQL.
ADF i need investigate, didn't use it before. Is it puur Azure task and do you can easy select and copy full schema's or 300 tables at once?
Jan 18, 2024
- Cheef87Feb 16, 2024Copper Contributordbmsoutput I would be curious to hear if you have solved this problem. Did you end up implementing an ADF solution?