将Oracle数据库与SQL Azure同步
我想将本地Oracle数据库与SQL Azure同步.当前，我为本地应用程序(Dell和SQL Server都在本地)安装了DTS软件包.如果我将SQL Server移至Azure，应如何设计此过程?
I would want to sync up on-premises Oracle database with SQL Azure. Currently I have a DTS package setup for my on-premises applications (both Oracle and SQL Server being on-premise). If I move the SQL Server to Azure, how should this process be designed?
您必须选择迁移到Azure的选项:
you have to options for moving to Azure:
- 移动到Azure SQL数据库
- 在Azure中配置SQL Server VM
后者将具有与常规本地SQL Server相同的功能集.前者的功能并不完全等同于SQL Server.Azure SQL数据库只是数据库引擎的一部分，没有SSIS，SSAS，复制甚至TSQL都不完全等同于SQL Server.
the latter will have the same feature set as your regular on-premise SQL Server. The former is not fully-feature equivalent to SQL Server. Azure SQL Database is just the Database engine part, no SSIS, SSAS, Replication and even TSQL is not fully equivalent to SQL Server.
如果使用VM方法，可以安全地假设您仍然可以运行现有程序包.但是，您需要考虑云中Azure和本地Oracle数据库之间的延迟.
If you use the VM approach, its safe to assume you can still run your existing packages. However, you need to consider latency between Azure in the cloud and your on-premise Oracle database.
您还可以构建自定义解决方案来同步数据库，甚至使用Sync Framework.请参阅:数据库同步:Oracle和SQL Compact 2层，只需将SQL Compact替换为与Azure SQL数据库一起使用的SqlSyncProvider.如果还想使用WCF，则可以将示例更改为使用n层方法.
you may also build a custom solution to sync the databases or even use Sync Framework. see: Database Sync: Oracle and SQL Compact 2-Tier , just replace the SQL Compact with the SqlSyncProvider which works with the Azure SQL Database. You can change the sample to use an n-tier approach if you want to use WCF as well.