Sql  Server  Management  Implementation steps for Studio to connect to MySQL

targetGiven MySQL connection parameters (address and user), expect to use Microsoft; SqlServer Management Studio (hereinafter referred to as MSSSMS) connects to MySQL and directly queries or modifies data in MySQL in MSSSMS.realizationStep 1/4: Download and install MySqlConnector/ODBC at MySQL:: DownloadConnector/ODBCSelect the corresponding installation file based on the number of bits in the operating system

target

Given MySQL connection parameters (address and user), expect to use Microsoft; SqlServer Management Studio (hereinafter referred to as MSSSMS) connects to MySQL and directly queries or modifies data in MySQL in MSSSMS.

realization

Step 1/4: Download and install MySqlConnector/ODBC at MySQL:: DownloadConnector/ODBC

Select the corresponding installation file based on the number of bits in the operating system. During installation, you may be prompted to install Microsoft OLEDBDriver first. After successful installation, the following information will be displayed:

Step 2/4: Create DSN; (datasourcename) 

Step 3/4: Create a linked server

--Create Linked Server EXECsp_addlinkedserver@server ='crm', @ srvproduct='MySQL', @ provider='MSDASQL', @ datasrc='crmDNS' -- Delete linked server executesys.sp_dropserver@server ='crm'

Among them@ server=' crm' Refers to a custom service name@ datasrc=' crmDNS'& nbsp; Refers to the data source name in ODBC.

  Step 4/4: Using a demonstration

The above figure shows the query results

The above figure shows inserting data into the MySQL database in the SQL server database

Sql Server Management StudioMysqlrealization,Sql Server Management StudioMysql