sql server import using odbc driver and mysql database
in Here is your first Forum
Sat Nov 25, 2017 4:39 pm
• 155 Posts
im trying to import my mysql database into sql server. i use the odbc driver to access the odbc dns i have in windows.
i am using the native client of sql server as the destinateion.
both source and destinate are on my localhost.
i get some errors regarding the datatype date. in my source it puts the value 23 as the datatype so i edit the mapping to be of type date.
once i do this for all columns of type date in the database i hit continue and i get errors that look like this:
TITLE: SQL Server Import and Export Wizard
The preview data could not be retrieved.
ERROR  [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.20-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"district"' at line 1 (myodbc5w.dll)
i do not know how to fix this. it comes up for all tables.