Let me reiterate, I have 4 mssql databases, located remotely. I have to design a utility that should extract the data from all 4 databases and should update/append in one table which is in mysql server. This should be handled by a scheduler. How to achieve this?
Asked
Active
Viewed 51 times
0
-
It's a bit unclear what you are trying to do. Do you want to move all data from the MSSQL databases you choose to MYSQL? I'm thinking that SSIS might be an option if you want to run it every day over a long period of time. There's also something called http://www.mysql.com/downloads/workbench/ which seems to be a possible option. I haven't used it though. – holder Mar 13 '18 at 08:32
-
Possible duplicate of [How to export SQL Server database to MySQL?](https://stackoverflow.com/questions/3917081/how-to-export-sql-server-database-to-mysql) – holder Mar 13 '18 at 08:40
-
I have specifically mentioned "to append the selected data", which is possible either using Views or procedure. Also it is not one time process. Rather I want to schedule that runs daily and append the incremental data. – Sandy Mar 13 '18 at 09:24