Hi Ravuri,
You can create a linked server on SQL Server Management Studio (SSMS) to connect to MYSQL database and retrive data from MYSQL database. Here have some links about create a linked server to MYSQL database server from SQL Server environment and then going to query data’s from MYSQL, please see:
http://sql-articles.com/blogs/creating-linked-server-to-mysql-from-sql-server/
http://dangermouseonsharepoint.wordpress.com/2009/05/26/using-sql-reporting-services-to-report-on-mysql-database/
Hope this helps.
Regards,
Charlie Liao
TechNet Community Support
No comments:
Post a Comment