April 21, 2016 at 11:30 am
Hello,
Today, I am able to connect from SQLServer 2K8 to MySQL servers inside the company by using MySQL Connector/ODBC and running the following:
EXEC('SELECT * FROM OPENQUERY (system_dsn_name, SELECT .... FROM ... WHERE ...) ');
We just about to moved MySQL server to AWS. How will we be able to connect to it from our SS2008 then?
April 22, 2016 at 4:53 am
rightontarget (4/21/2016)
Hello,Today, I am able to connect from SQLServer 2K8 to MySQL servers inside the company by using MySQL Connector/ODBC and running the following:
EXEC('SELECT * FROM OPENQUERY (system_dsn_name, SELECT .... FROM ... WHERE ...) ');
We just about to moved MySQL server to AWS. How will we be able to connect to it from our SS2008 then?
There are few things that may cause you issues:
1. Is your mysql engine running in AWS on EC2 or RDS?
2. Is your MySQL engine within a Virtual Private Cloud
3. Are you running a VPN when connecting from your internal network to the AWS internal network?
If connectivity is indeed possible i.e. all your AWS ACL rules, security groups allow access from the NAT IP address of your SQL server nothing needs to change as in your code you are just consuming an ODBC Connection. So as long as you can reconfigure your ODBC connection to connect to the mySQL instance hosted in AWS it should work.
MCITP SQL 2005, MCSA SQL 2012
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply