Home > IT Answers > Database > Connect to remote SQL server from MySQL
Nitibansal
5 pts.
 Connect to remote SQL server from MySQL
MySQL, Remote SQL Server, SQL Server, SQL Server 2005, Unix
we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

Software/Hardware used:
sql server 2005
ASKED: August 24, 2010  4:51 AM
UPDATED: August 26, 2010  3:46 AM
RELATED QUESTIONS
Answer Wiki:
SQL Server Integration Services would be the easiest way to move data from a SQL Server to a MySQL server.
Last Wiki Answer Submitted:  August 26, 2010  3:46 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _