I have a Sql Database in Azure Cloud and I have a Sql Server Database in another server outside the Azure Cloud. I want to configurate a replication between my Azure Sql DataBase and the Sql Server outside the Cloud.
It can be possible?
Asked
Active
Viewed 559 times
0
-
Are you trying to replicate from Azure SQL to on-premises SQL or the other way around? – Nick.Mc Oct 07 '19 at 02:04
1 Answers
1
Yes, you can configurate a replication between your Azure SQL Database and the SQL Server outside the Cloud.
There are many ways can help your copy your SQL server database to Azure SQL database:
- If your database is not very large, Data Migration Assistant to help you migrate your database from SQL server to Azure SQL Server.
- Azure Database Migration Service: Tutorial: Migrate SQL Server to a single database or pooled database in Azure SQL Database offline using DMS.
- SSMS, right click databse-->
Tasks-->Deploy Database to Azure SQL database
Configurate a replication from Azure SQL Database and the SQL Server outside the Cloud:
For example:
- Export your Azure SQL database as bacpac file and restore it in your SQL server.
Reference:
- Azure SQL database: Export an Azure SQL database to a BACPAC file
- SQL Server: Import a BACPAC File to Create a New User Database
You also can reference this blog: How do I copy SQL Azure database to my local development server?
Hope this helps.
Leon Yue
- 15,693
- 1
- 11
- 23
-
-
You're welcome,@YoniCastañeda . If my answer is helpful for you, you can accept it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). This can be beneficial to other community members. Thank you. – Leon Yue Oct 08 '19 at 00:57
-
2Neither of these are replication options, they're one-offs (that can admittedly be run repeatedly) – Nick.Mc Oct 09 '19 at 22:21