How to import SQL server from MySql through ODBC
1. download and install the MySql ODBC Driver according to the operating system. add mysql DSN, select a dataset consistent with mysql, and set Connection Pooling Timeout 3. select SQL Server Import and Export Wizard, and select the data source. net FrameworkData Provider for Odbc, in ConnectionString, enter Driver = {MySQL ODBC 5.1 Driver}; server = localhost; database = xxx; persistsecurity info = True; SQL server mode = true, in DSN, enter the DSN 4. select Microsoft ole db Provider for SQL Server as the target, and set the type of each data table in mapping. set the Chinese column to nvarchar to avoid garbled characters in Chinese. you must also set mysql: set global SQL _mode = ansi_quotes. this is mainly used to solve the problem of unrecognizable quotation marks in SQL statements. this is from the column bitsCN.com of asd309202533.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
