469,609 Members | 1,183 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Problem with migrating huge tables from MySQL database.

Hi all,

I have to migrate the data from MySQL database to SQL Server using SSIS Wizard, also in this case I have used MySQL ODBC 3.51 Driver as a driver for migration. When I loaded the data about 10 millions rows, the migration completely works. But when I loaded the data about 18 millions rows, I got this message "Error loaded table_name [Source-table_name[1]]: An error occured executing the provided SQL command."

Here's the command I've used

Expand|Select|Wrap|Line Numbers
  1.  SELECT *
  2.  
  3. FROM table_name
  4.  
  5. WHERE Year(yy, a.time) = 2006 
I'm not sure whether the error caused by the driver or not.

If anybody knows how to solve this problem, please let me know

i would be very appreciated.

Thanks
Aug 2 '07 #1
1 1072
bxchen
7
I used DFSTrans to migrate 18 millions rows, it works fine. here is the web site: www.DirectFocusSoftware.com
Feb 1 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Murtix Van Basten | last post: by
2 posts views Thread by yasaswi | last post: by
3 posts views Thread by canigou9 (remove your socks to reply) | last post: by
reply views Thread by Kenneth P | last post: by
2 posts views Thread by Jean-Claude Adams | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.