Re: Is MySQL compatible wh MS SQL 6.5

[Sasha Pachev]

Irwin wrote:
> 
> Tech: Please help me in my question.
> 
> I have a dbase on MS SQL 6.5 sp5. If I export this dbase to an ISP wh
> MySQL ver. ???, what type of compatibility issues will I have, if any?
> 

Depends on how you export it, and what types of fields you are using in
MS SQL. If they are ANSI 92 SQL compliant, you should not have any
problems - otherwise, you will probably have a problem on most
non-compiant fields, but this can be avoided altering the field type to
its MySQL equivalent.

Also the referential inegrity constraints will be parsed by MySQL, but
ignored.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)