You are not logged in.

#1 2006-06-28 12:21:10

zaozao
Member
Registered: 2006-05-12
Posts: 36

translating MSSQL to MySQL queries

Is it possible to migrate with existing database from MSSQL to MySQL?

I wander very much for application working in WIN32 environment (like wine) that translates queries for MSSQL to MySQL queries I mean the situation if some program would think it works with MSSQL but naturally it will work with MySQL carrying migration from MSSQL database with the same data.

Many WIN32 programs use MSSQL mostly like databank.

You guess I want to try to migrate with my production environment from Windows to Linux with some WIN32 application working. Is it possible?

And I wander if MySQL stable equally comparing to MSSQL and have the same undo features.

Does MySQL provide some WARRANTIES for production use?


Thank you!

Offline

#2 2006-06-28 16:26:34

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: translating MSSQL to MySQL queries

you mean...some application that acts like a mssql server, but which is just a wedge between your app and mysql, providing sql query translation?

I don't know of anything that does that. An interesting idea, albiet with limited usefulness. Many of the features of a real sql engine would have to be duplicated, and there are some things that mssql can do, that mysql simply cannot (or can..but the features are still new and not well tested).


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#3 2006-06-28 18:07:17

soloport
Member
Registered: 2005-03-01
Posts: 442

Re: translating MSSQL to MySQL queries

Use SQL92/99-compliant SQL and you can run your application on MSSQL, Postgres, Oracle, DB2 or any other SQL92/99-compliant RDBMS.

Postgres, Oracle and DB2 run on MS as well as Linux.

Use MySQL only if you have a reason to do so -- e.g. need a speedy flat-file like, nearly read-only DB -- but don't want to use a flat file as a DB.  Do not use where complexity or heavy inser/update is needed as performance degrades, rapidly.  MySQL still has a way to go with error checking, unfortunately.  Coming from MSSQL to MySQL: You will be disappointed.

(My two cents, of course... YMMV)

Pretty sure MySQL does not come with a warranty.  Does MSSQL?  ;-)

Offline

#4 2006-06-28 18:26:42

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: translating MSSQL to MySQL queries

I find myself using sqlite for instances where I used to use mysql.
For anything that I want to throw a real feature set at, I prefer postgres.
smile


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#5 2006-06-28 18:42:35

phrakture
Arch Overlord
From: behind you
Registered: 2003-10-29
Posts: 7,879
Website

Re: translating MSSQL to MySQL queries

cactus wrote:

I find myself using sqlite for instances where I used to use mysql.
For anything that I want to throw a real feature set at, I prefer postgres.
smile

Ack! Argh!
/me holds back ranting
sqlite doesn't count as it doesn't support SQL.  That's like saying "curl" is a good web browser.

Offline

#6 2006-06-28 20:27:55

soloport
Member
Registered: 2005-03-01
Posts: 442

Re: translating MSSQL to MySQL queries

phrakture wrote:
cactus wrote:

I find myself using sqlite for instances where I used to use mysql.
For anything that I want to throw a real feature set at, I prefer postgres.
smile

Ack! Argh!
/me holds back ranting
sqlite doesn't count as it doesn't support SQL.  That's like saying "curl" is a good web browser.

But this seems to be how things have progressed:

NEED==>SOLUTION

Flat file DB ==> Flat file DB

Flat file DB++ ==> MySQL? Too unwieldy! Better go with SQLite

SQL92 ==> MySQL? Poor upgrade path. Better go with Postgres

SQL99 ==> Postgres

Nails ==> Hammer

Offline

#7 2006-06-28 23:24:23

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: translating MSSQL to MySQL queries

Yeah. sqlite is a replacement for having lots of flat files. Flat files have performance issues (see pacman for a great example of that). sqlite is pretty fast, and reasonable to use. It has a great license too. tongue
I prefer it over one of the *dbm's, but maybe just barely.

I only use mysql for things on my webhost, and only then because my webhost doesn't have postgres support.. I really do hate mysql.

soloport..that is pretty much on the money, from my point of view. Nice.

EDIT:
I prefer wget to curl for my web browsing.
lol


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#8 2006-06-28 23:50:58

ralvez
Member
From: Canada
Registered: 2005-12-06
Posts: 1,694
Website

Re: translating MSSQL to MySQL queries

Is it possible to migrate with existing database from MSSQL to MySQL?

This is best answered by the MySQL people here:
http://dev.mysql.com/tech-resources/art … osoft.html
Notice that they have a discussion forum on the topic.

And I wander if MySQL stable equally comparing to MSSQL and have the same undo features.

In my experience MySQL is as good (and I think in fact better) but  that also depends on the intended use, server load, etc. so I'll live  it at that. You may want to have other opinions on the matter.

Does MySQL provide some WARRANTIES for production use?

Again let's MySQL speak by temselves:
http://www.mysql.com/support/enterprise_support.html

Hope this helps.

Rick

Offline

#9 2006-06-29 06:14:08

zaozao
Member
Registered: 2006-05-12
Posts: 36

Re: translating MSSQL to MySQL queries

cactus wrote:

some application that acts like a mssql server, but which is just a wedge between your app and mysql, providing sql query translation?

Yes, I need like this exactly!

I have WIN32 application using MSSQL like databank and no versions of it for Linux/UNIX (and will not as developers have some deal with Microsoft) no source code (it is a plenty of code …!) as commercial.

It does not matter which SQL type to use the main is possibility to work on Linux/UNIX.



Very interesting to try if some tool is exists!





Thank you!

Offline

#10 2006-06-29 16:17:03

soloport
Member
Registered: 2005-03-01
Posts: 442

Re: translating MSSQL to MySQL queries

This article http://techdocs.postgresql.org/techdocs … 2pgsql.php may be helpful.

(Migrating from SQL Server to MySQL would be much more painful, me thinks.)

Offline

Board footer

Powered by FluxBB