Jamey McElveen
Reputation: 18305
How can I sync my MSSQL database to MySQL?
I am using MSSQL as my transactional database. This database has 200+ tables with about 25 tables that hold 1M plus records. I want to replicate the data with the same structure into a MySql database for reporting. Is there a tool or method that can do this in a fairly real time manner?
Upvotes: 3
Views: 4891
Answers (1)
OMG Ponies
Reputation: 332581
Use SQL Server's Linked Server to access MySQL from SQL Server.
Upvotes: 2
Related Questions
- Sync between Sql Server and Mysql Server
- Sync a MS SQL Database with a MySQL Database
- Sync single table between MSSQL and MySQL
- Sync Tables from MySQL to MSSSQL
- One-way sync between MySQL and SQL Server
- Synching MSSQL and mysql database using C#
- Sync MySQL and MSSQL databases through windows service
- How to Synchronize SQLServer Database and MySQL Database
- SQL Server and MySQL Syncing
- Synchronizing SQL Server 2005 with MySQL