-2

I need to take data from microsoft sql server DB (selected tables) to mysql database. how to achive this in a daily basis by using any open source ETL or Any other ways

Kannan
  • 1
  • I voted to close this as off-topic but I guess it is also too broad. Maybe it would be better to post this question at https://dba.stackexchange.com – Joakim Danielson Oct 19 '18 at 12:12

1 Answers1

2

For DB migration, you can use tools like : SQL SERVER data tools. Check it out here:

Database migration using SqlServer data tools

ETL is a much wider concept and you do a lot more stuff in it rather than just copying data from a table to another.

I've personally worked on Talend which is a open-source ETL tool.You can find tons of videos on youtube and elsewhere. In my opinion, you should understand what ETL is first and what it is capable of.

Here's a one to get you started:

Talend for Beginners

Let me know if this helps.

Mayank Porwal
  • 33,470
  • 8
  • 37
  • 58