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.
Executing the same query for MSSQL in the crontab makes more sense.
Better to write code for inserting mssql using that cron job php file only..
Know how to insert data into mssql using php http://php.net/manual/ru/function.mssql-query.php