European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: Migrating from MSsql Server to MySQL
By: Hornox	Date: 20/03/2003 00:00:00	Points: 125	Status: Answered Quality : Excellent
Hi, We've got some Microsoft SQL Server databases on our server. We are currently trying to replace all our Microsoft servers with Linux software. How do we convert our SQL server databases to MySQL? Can this be done? Is Oracle for Linux an option? Help please... Thanx! Hornox
By: VGR	Date: 20/03/2003 23:24:00		Type : Answer
use the M$-$QL-$server's command tu dump database structure or dump the data in a CSV file Then import in MySql Best solution : if the m$ "database" could produce a .sql file to recreate the database ; you'll need to adapt it a bit because M$-$Sql$S takes "liberties" with the SQL92 standard (as does MySql, but to a lesser extent)

By: smatthesen	Date: 20/03/2003 23:41:00		Type : Assist
I use a freeware tool called DBTools. I use an older version (1.0.6), but if you have it try this: (1) Connect to your MySQL database (2) On the menu, goto Data --> Import Data Wizard (3) For source, select ODBC (4) Select your DSN (assuming you have one setup) to connect to the MSSQL database. (5) Follow the wizard to finish the import. Hope this helps!

By: monange	Date: 21/03/2003 06:50:00		Type : Assist
You can also work the other way round to transfer from MSSQL to MySQL, using MSSQL's DTS... Now, "is Oracle an option": This depends on WHY you replace M$SQL. If it's the price, Oracle has the same magnitude of prices, I think even that's its more expensive... If it's (lack of) stability, Oracle is for sure an good option. CHeers

By: mtrimpe	Date: 23/03/2003 11:12:00		Type : Comment
I don't want to be degrading to the Mdollar people. Depending on what you are doing with the database right now, Oracle is a very real option. Please consider that MySQL still has a very limited 'strict' SQL implementation, and those versions that come close are still somewhat in Beta. If you use more advanced SQL constructs and/or use a lot of SQL functions that aren't compatible with MySQL the cost of installing and maintaining an Oracle server is usually far lower than the cost of rewriting the entire application. The only variable in this equation is the cost of rewriting the application, so if it's cheap for you ... go ahead and switch to MySQL. If not, go with Oracle. And before I get flamed: I'm just as big a fan of Linux etc., but since i'm on a business major, I just look at this from the cost-angle. And at that, I am right.

By: VGR	Date: 24/03/2003 23:36:00		Type : Comment
yes, but I find MySql more SQL92-compliant than M$-Sql-Server, for instance (at least for basic syntax I use) and I also think that "advanced" features are a threat to portability and maintainability. I prefer to do things simple and cross-compatible ;-)

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 472.188950 milliseconds

Why Google AdSense ads ?

New Improved Search!