Azure SQL和Oracle内部部署同步或预定更新 [英] Azure SQL and Oracle On-premise Sync or scheduled update
问题描述
我们需要在Azure和Oracle内部部署SQL之间进行同步。同步可以是夜间同步或立即同步。
我找到了一篇文章 sync SQL Azure和SQL内部部署
数据库，但没有找到在SQL Azure和Oracle内部部署之间执行同步的方法。
感谢您的指导以实现它。
谢谢
我们需要在Azure和Oracle内部部署的SQL之间进行同步。同步可以是夜间同步或立即同步。
我找到了article to 同步SQL Azure和SQL内部部署数据库，但没有找到一种方法来执行SQL Azure和Oracle内部部署之间的同步
。
感谢您的指导以实现它。
谢谢
美好的一天 Rizwan ，
为了为您选择最佳解决方案，需要更多信息，例如可以在线或离线完成，这是一次性工作还是数据库需要每x次同步，等等......检查这些解决方案并选择符合您需求的
1.使用Azure数据工厂，您可以将数据从Oracle复制到Azure数据库。
https://docs.microsoft.com/en-us/azure/data-factory/connector-oracle
2.你。可以使用Azure数据库迁移服务（ DMS ）
https://azure.microsoft.com/en-us/resources/videos/how-to-migrate -oracle-to-sqldb-online /
3.您可以使用 SQL Server迁移助手（ SSMA ） for Oracle（OracleToSQL）
4。您可以手动将数据导出到Oracle的Blob并导入到Azure数据库
此外，我建议查阅以下文件：
- 可用于数据迁移方案的服务和工具
https://docs.microsoft.com/en-us / azure / dms / dms-tools-matrix- SQL Server迁移助手（ SSMA ） -
具有多个版本的本地应用程序，具体取决于您要迁移的数据源。
https://docs.microsoft.com/ en-us / sql / ssma / sql-server-migration-assistant？view = sql-server-2017- 使用 Azur将Oracle迁移到Azure SQL数据库e数据库迁移指南（用于查找符合您需求的解决方案的在线工具）
https://datamigration.microsoft.com/scenario/oracle-to-azuresqldb?step=1- SSMA for Oracle（OracleToSQL）
https://docs.microsoft.com/en-us/sql/ssma/oracle/getting-started-with-ssma-for-oracle-oracletosql < a href ="https://datamigration.microsoft.com/scenario/oracle-to-azuresqldb?step=1">- Azure数据库迁移服务 ;（ DMS ） -
Azure服务。 注意！使用Portal从Oracle迁移仅支持目标"Azure Database for PostgreSQL"。您可以使用PowerShell迁移到PostgreSQL并从那里迁移到Azure SQL数据库或
，它们具有更多目标选项，包括Azure SQL数据库（预览）。查看下一个视频演示链接 https://docs.microsoft.com/en-us/azure/dms/dms-overview- Azure数据库迁移服务（ DMS ）：迁移
Oracle到Azure SQL数据库 （预览） - 视频
https://azure.microsoft.com/en-us/resources/videos/how-to-migrate-oracle-to-sqldb-online/
Hi,
We need to do a sync between SQL in Azure and Oracle on-premise. The sync can be a nightly sync or immediate sync.
I did find an article to sync SQL Azure and SQL On-premise databases, but did not find a way out to perform the sync between SQL Azure and Oracle On-premise.
Appreciate your guidance to achieve it.
Thanks
Hi,
We need to do a sync between SQL in Azure and Oracle on-premise. The sync can be a nightly sync or immediate sync.
I did find an article to sync SQL Azure and SQL On-premise databases, but did not find a way out to perform the sync between SQL Azure and Oracle On-premise.
Appreciate your guidance to achieve it.
Thanks
Good day Rizwan,
In order to choose the best solution for you there is need for a lot more information like can it be done online or offline, is this a one time job or is the databases need to be sync every x time, and so on... check these solution and choose the one that fit your needs
1. using Azure Data Factory you can copy data from Oracle to Azure Database.
https://docs.microsoft.com/en-us/azure/data-factory/connector-oracle
2. You can use Azure Database Migration Service (DMS)
https://azure.microsoft.com/en-us/resources/videos/how-to-migrate-oracle-to-sqldb-online/
3. You can use SQL Server Migration Assistant (SSMA) for Oracle (OracleToSQL)
4. You can manually export data to the blob from Oracle and Import to the Azure Database
In addition I recommend to go over bellow documents:
- Services and tools available for data migration scenarios
https://docs.microsoft.com/en-us/azure/dms/dms-tools-matrix- SQL Server Migration Assistant (SSMA) - On-premises application with several versions according to the source of data you want to migrate.
https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017- Migrate Oracle to Azure SQL Database using Azure Database Migration Guide (Online tool to find the solution which fit your needs)
https://datamigration.microsoft.com/scenario/oracle-to-azuresqldb?step=1- Getting Started with SSMA for Oracle (OracleToSQL)
https://docs.microsoft.com/en-us/sql/ssma/oracle/getting-started-with-ssma-for-oracle-oracletosql- Azure Database Migration Service (DMS) - Azure Service. Note! Migration from Oracle using the Portal only supports target "Azure Database for PostgreSQL". You can migrate to PostgreSQL and from there to Azure SQL Database or using PowerShell which have more options for target including Azure SQL Database (preview). Check the next link for video demohttps://docs.microsoft.com/en-us/azure/dms/dms-overview
- Azure Database Migration Service (DMS): Migrate Oracle to Azure SQL Database (preview) - video
https://azure.microsoft.com/en-us/resources/videos/how-to-migrate-oracle-to-sqldb-online/
这篇关于Azure SQL和Oracle内部部署同步或预定更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
