We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,386 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

data from mysql to ms sqlserver database

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.

3
Contributors
2
Replies
10 Hours
Discussion Span
7 Months Ago
Last Updated
3
Views
Arjun_Sarankulu
Junior Poster
169 posts since Jan 2011
Reputation Points: 7
Solved Threads: 1
Skill Endorsements: 0

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

pritaeas
Posting Prodigy
Moderator
9,316 posts since Jul 2006
Reputation Points: 1,178
Solved Threads: 1,467
Skill Endorsements: 86

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

rayidi
Junior Poster in Training
83 posts since May 2011
Reputation Points: 13
Solved Threads: 2
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0648 seconds using 2.69MB