Re: How to import my data from MYSQL to MS SQL ?

[Nishrin Naya]

Hello Hemant,

Thank you for your reply.
Hereby I provide full detail of the work done by me,

I create a new table PET in MYSQL using following query:

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

I enter one record using following query:

mysql> INSERT INTO pet
-> VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);

Then ;I create a Dsn for my database from C:\Windows\SysWOW64\odbcad32.exe

Next I open SQL Server Management Studio.
Under CREDIT database ,right click on it selected TASKS then IMPORT DATA,

Sql Server Import Export Wizard open.

I selected .Net Framework Data Provider for ODBC
Entered Dsn name,Clicked Next
Destination SQL Server Native Client 10.0,clicked Next.
Selected "Copy Data from one or more...",clicked next.
Selected table PET and clicked on Preview,an error message promt with following error:

ERROR [42000] [MySQL][ODBC 5.3(a) Driver][mysqld-5.0.41-community-nt]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 '"pet"' at line 1
(SQL Server Import and Export Wizard)


I hope My explain makes you clear about my error.
Hope to see your reply soon.
Thank you.