MSSql sql sentence to mySql sql sentence

------=_NextPart_000_0005_01C5D8E6.4EB59D50
Content-Type: text/plain;
charset="iso-8859-9"
Content-Transfer-Encoding: base64

aGksDQp3ZSBoYXZlIHNvbWUgc3FsIHNlbnRlbmNlcyBpbiBjcnlzdGFsIHJl cG9ydCAucnB0
IGZpbGVzIHRoYXQgd3JpdHRlbiBmb3IgTVNTcWwgZGF0YWJhc2UuIEJ1dCB3 ZSBjYW4ndCB1
c2UgdGhlbSBpbiBteXNxbCBkYXRhYmFzZSBlYXNseSwgYmVjYXVzZSBvZiBk aWZmZXJlbmNl
cyBiZXR3ZWVuIE1zU3FsIGFuZCBteVNxbCBzeW50YXguIEkgbmVlZCBhIHBy b2dyYW0gdGhh
dCBjb252ZXJ0cyBNU1NxbCBzcWwgc2VudGVuY2UgdG8gbXlTcWwgc3FsIHNl bnRlbmNlLiB3
aGVyZSBJIGNhbiBmaW5kIHRoaXMga2luZCBvZiBmcmVlIHByb2dyYW0gaW4g aW50ZXJuZXQg
SSB3aXNoIHlvdSBoZWxwIG1lDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoqKiogIEJ1 IG1haWwgQW50
aXZpcnVzIHRhcmFtYXNpbmRhbiBnZWNtaXN0aXIgKElTVEFOQlVMICBVTklW RVJTSVRFU0kp
DQoqKiogIFRoaXMgZS1tYWlsIHdhcyBzY2FubmVkIGJ5IEFudGl2aXJ1cy4g ICAgKElTVEFO
QlVMIFVOSVZFUlNJVFkpDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t

------=_NextPart_000_0005_01C5D8E6.4EB59D50--

Re: MSSql sql sentence to mySql sql sentence

--=_alternative 005D67AB852570A5_=
Content-Type: text/plain; charset="US-ASCII"

"mustafa tekin" wrote on 10/24/2005 03:00:12
PM:

> hi,
> we have some sql sentences in crystal report .rpt files that written
> for MSSql database. But we can't use them in mysql database easly,
> because of differences between MsSql and mySql syntax. I need a
> program that converts MSSql sql sentence to mySql sql sentence.
> where I can find this kind of free program in internet I wish you help
me
> ------------------------------------------------------------ ----------
> *** Bu mail Antivirus taramasindan gecmistir (ISTANBUL UNIVERSITESI)
> *** This e-mail was scanned by Antivirus. (ISTANBUL UNIVERSITY)
> ------------------------------------------------------------ ----------


If I remember correctly, Crystal Reports uses OLEDB to communicate with MS
SQL Server. Not only are you going to need to modify your SQL, you are
probably going to need to alter your connection method, too. I do not
think there is an OLEDB driver for MySQL so you will probably be using a
regular ODBC connector like MyODBC to communicate between Crystal Reports
and MySQL.

I am not aware of any program or utility to translate T-SQL (MS SQL Server
syntax) to MySQL SQL syntax. There may be, I am just not aware of any.
There are a few programs that will translate table and index definitions
from one platform to the other but I don't think they do any other SQL
statements.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 005D67AB852570A5_=--