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.
Dear Arjun_Sarankulu,
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.