I have a crontab job in which data from csv file get insert into mysql table at regular interval.
Now i want the same table data to be inserted in ms sqlserver database.

I know i can write code again to take data from csv to ms sqlserver database.
But i want to avoid the same.

Is there a way programmatically to insert data into ms sqlserver database from mysql table.

I have search a lot but didnt succeed.

Recommended Answers

All 2 Replies

Executing the same query for MSSQL in the crontab makes more sense.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.