SQL Server sync to MySQL program
I finally used a program called Omega Sync. Now called Spectral Core Replicator.
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!
Supported databases
- Access
- SQL Server
- MySQL
- Oracle
- Interbase
- Firebird
- ODBC sources
I am not associated with this company or product in any way.
SQL Server and MySQL Syncing
You can create a linked server instance in SQL Server, with the MySQL instance.
Despite being completely proprietary, one of the nice connectivity features offered in SQL Server is the ability to query other servers through a Linked Server. Essentially, a linked server is a method of directly querying another RDBMS; this often happens through the use of an ODBC driver installed on the server.
Refer This article : step-by-step process SQL Server Linked Server to MySQL.
Providing you grant the MySQL user you connect on behalf of proper permissions, you can write to the MySQL instance accouding to you. So you can update stored procedures to do an additional step to insert records into MySQL.
Much easier solution is to use commercial application - Omega Sync from Spectral Core
Omega Sync can compare and synchronize both database schema and table data. You can even synchronize data of heterogeneous databases (for example, compare your local SQL Server database with a MySQL replica on your web site - and synchronize all the differences in just a few minutes).
Easiest way to synchronize two databases
The architecture in-vogue right now is to send stock updates into a queue (Service Broker, RabbitMQ), and have a process that handles the message by updating both databases. I.e., your application doesn't make database changes directly, it just sends messages into the queue.
That can be a big jump, though, so if that's too much effort up front you can just put a trigger on the SQL database and have the trigger also update the MySQL database, assuming you can set it up as a Linked Server in SQL.
Related Topics
How to Create Xml Schema from an Existing Database in SQL Server 2008
Get Records 10 Min Before System Datetime in SQL
Enable Full-Text Search on View with Inner Join
Oracle Insert Failure:Not a Valid Month
Update Columns with Null Values
Why Can't I Group by 1 When It's Ok to Order by 1
Getting a Dynamically-Generated Pivot-Table into a Temp Table
Tsql Datediff to Return Number of Days with 2 Decimal Places
How to List All the Column Names in Netezza
Convert Rows to Columns Using 'Pivot' in Mssql When Columns Are String Data Type
SQL Inner Join on Select Statements
#1222 - the Used Select Statements Have a Different Number of Columns
There Are No Primary or Candidate Keys in the Referenced Table
How to Deep Copy a Set of Data, and Change Fk References to Point to All the Copies
Group or Distinct After Join Returns Duplicates
Split Comma Separated String Table Row into Separate Rows Using Tsql