Forum Discussion
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...
Hello,
You can use SQL Server Management Studio Import Export
Or you can use Azure Data Factory Pipelines
Both options will allow you to move schemas and data from source to destination
https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver16
https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities?tabs=data-factory
Regards
Javier
You can use SQL Server Management Studio Import Export
Or you can use Azure Data Factory Pipelines
Both options will allow you to move schemas and data from source to destination
https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver16
https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities?tabs=data-factory
Regards
Javier
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?
- dbmsoutput I would be curious to hear if you have solved this problem. Did you end up implementing an ADF solution?
