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?
+2
A:
Use SQL Server's Linked Server to access MySQL from SQL Server.
OMG Ponies
2010-10-29 21:01:10
I forgot mention the functionality is free, incorporated into SQL Server.
OMG Ponies
2010-10-29 21:07:12
Thanks, but, I am trying to use MSSQL for my transactional database and MySql fro my reporting database. I want to move data from MS-SQL to MySql not access MySql with MS-SQL
Jamey McElveen
2010-10-31 21:24:05
@Jamey McElveen: You misunderstand - that only depends on the permissions of the account you are connecting to MySQL (from SQL Server) as - if the account has appropriate permission, you can insert/update/delete data on the MySQL instance via SQL Server.
OMG Ponies
2010-10-31 21:26:02