[Richard J Lacroix]

peterlaursen wrote on Oct 19 2006, 02:41 AM:

Are your source data VARCHAR or TEXT?

The MS SQL source was TEXT I believe, because the size was 2147483647, a field used to hold user comments. I can't confirm at the moment because the database is now detached from my development environment and running on the production server.

[Richard J Lacroix]

Yes – still getting used to SQLyog, was longtime EMS MySQL Manager user. Hitting refresh with that tool refreshed everything, not just selected object. 😉

Thanks Peter.

[Richard J Lacroix]

No software updates

SQL yog 5.19 Enterprise

The job is actually being kicked off using a SQL statement, since using the wizard errors out because the tables all have auto_increment fields. The statement is simply “select * from bh_Client”, after successfully importing 5 more tables this morning, I am now looking into the table structures of the ones that the Job isn't importing to see if there is something unsual or different about them.

[Richard J Lacroix]

This may help:

Show Information_Schema

Then again, it may not, your post is a little difficult to understand…

😉

[Richard J Lacroix]

XiRoCCo wrote on Jul 28 2006, 02:54 PM:

thanks — i use UltraEdit32 – a brilliant text editor. i considered exporting and reimporting and now see that it's probably the easiest way to accomplish this.

thanks again

–kevin

😮

That's doing it the hard way, try this in SQLyog:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

[Author]

Posts