[thomas7263]

peterlaursen wrote on Feb 18 2006, 01:29 PM:

Yes this is a restriction with the demo version.  It lets you only import one table at a time.

And I verified this myself recntly with the cutomer data that I wrote about.  196 (to be exact) files imported with one job.  It ran for 11 hours on a 1.5 Ghz computer here – while I was sleeping most of the time.  😀

[post=”8778″]<{POST_SNAPBACK}>[/post]

I hate to bug you again since you have been so helpful but when I get to final stage of the migration wizard I can't find a way to apply my mapping changes to all files. I make the change to the top row but I don't see an 'apply to all' option or a way to copy this mapping down to the other 500 files. Similarly, by default the source and destination are the same. From the looks of it I will have to change the destination to my table for each of the 500 files.

[thomas7263]

Beautiful!

It works. Thanks, this will save me a lot of time. One last question before I pay for the full version of SQLyog Enterprise. The trial version only lets you load one source at a time. In the full version when I change the mapping will it apply to all sources? If not I would have to redo the mapping for all 500 files. Once again your help is truly appreciated.

[thomas7263]

Thank you for your help Peter.

This appears to be exactly what I need. However, I am having issues. My files are .txt tab delimited files. I am using the Microsoft text driver. SQlyog is not recognizing the tab delimited format. When importing manually you tell it what the delimiters are. Here I don't see that option. As a result the first row on my 'Source' column shows all of the column headers from my .txt file. I hope this makes sense.

[Author]

Posts