On Fri, 18 Jan 2002, Markus Lervik wrote: > > Hello all! > > We've requested a database from different companies, and specifically > said we wanted MySQL or PostgreSQL because of the open source angle > and we're a library. > One company offered MS SQL as the platform and said that they can later on > port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know > is, how easy is it to port a (fairly complicated) database from MS SQL to > MySQL? It can't be work worth 18 000 euro, now can it?
I'm not sure I'm understaidning your question completely, but I'll try to answer it anyway. 1) Porting from MS SQL to MySQL is not the easiest of things. There are several options, and they include connecting to both via MS Access and ODBC, or using the Sybase perl drivers with the FreeTDS library to get it to talk to MS SQL. They you can write a program in perl to port the data. 2) If you want MySQL or PostgreSQL, why exactly would you want to install MSSQL, and then "upgrade" later? Both PostgreSQL and MySQL will run on Windows (although again, I'm not sure why you would want to do that if you have a choice). All in all, it can be complicated and time consuming. You don't want to go there. Just get MySQL or PostgreSQL in the first place, and save yourself the trouble of porting the data later. If you are about to implement a system from scratch, it's is always easiest and cheapest to do it right in the first place, with the software you want. Regards. Gordan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
