SQL Server同步到MySQL程序

编程入门行业动态更新时间:2024-10-26 11:27:29

本文介绍了SQL Server同步到MySQL程序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

我想每隔30分钟或更短的时间从SQL Server数据库到MySQL数据库的11个表中连续约380000行数据进行同步.我怎样才能做到这一点?哪些程序可以做到这一点?

I want to continually sync every 30 mins or less around 380000 rows of data from 11 tables from a SQL Server database to a MySQL database. How can I do this? What programs can do this?

这篇文章，通常用于解决诸如由于以下原因，这些作为重复项对我不起作用.

This post, which is often used to close questions like these as a duplicate, does not work for me, for the following reasons.

SQL Server是CRM系统的一部分，我不确定它是否可能是精简版或其他版本，但是长话短说，我没有访问SQL Server Management Studio的权限.

The SQL Server is part of a CRM system, I'm not sure if it may be a lite version or something, but long story short I do not have access to the SQL Server Management Studio.

MySQL数据库是我的托管程序包的一部分，这意味着我可以通过phpmyadmin等访问它，但不能访问控制台或其他任何东西.而且显然我无法通过localhost访问它.

The MySQL database is part of my hosting package, which means I have access to it via phpmyadmin and the like, but not to the console or anything. And obviously I cannot access it via localhost.

因此，基本上，我正在寻找一种可能通过ODBC驱动程序连接到两个数据库并每隔x分钟/小时同步数据的方法.

So basically what I'm looking for is a way to connect to both databases, probably via ODBC drivers, and sync data every x minutes/hours.

推荐答案

我最终使用了一个名为Omega Sync的程序. 现在称为 Spectral Core Replicator .

I finally used a program called Omega Sync. Now called Spectral Core Replicator.

Omega Sync可以比较和同步数据库模式和表数据.同类数据库的架构比较和同步数据比较和同步，甚至用于不同种类的数据库比较和同步无限大小的数据库！

Omega Sync can compare and synchronize both database schema and table data. Schema comparison and synchronization for databases of same kind Data comparison and synchronization even for databases of different kind Compare and Synchronize databases of unlimited size!

支持的数据库