Re: Moving MS SQL 2000 to MySQL

2007-08-13 Thread Ben Doom
Are any of them dates? Datetimes? That sort of thing? Just a guess. --BenD SMR wrote: > Anyone move table information from MS Sql 2000 to MySQL 5 ? The table types > in MySQL are InnoDB, not MyISAM which is what we normally use. Someone tried > MS DTS services and gets errors on the blob data

Moving MS SQL 2000 to MySQL

2007-08-13 Thread SMR
Anyone move table information from MS Sql 2000 to MySQL 5 ? The table types in MySQL are InnoDB, not MyISAM which is what we normally use. Someone tried MS DTS services and gets errors on the blob data columns. They gave it to me to use CF to write loops/queries to extract and insert the informati