RE: [PHP] SQL Server DB to mySQL DB

2001-01-25 Thread Jason Bouwmeester
: Christopher Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 9:16 AM To: Jason Bouwmeester; [EMAIL PROTECTED] Subject: Re: [PHP] SQL Server DB to mySQL DB Just did this to a 65mb fixed width file. What I did was get it into a csv file via perl :) Then I created the db table. Then I

Re: [PHP] SQL Server DB to mySQL DB

2001-01-25 Thread Christopher Allen
Just did this to a 65mb fixed width file. What I did was get it into a csv file via perl :) Then I created the db table. Then I used: load data infile "/file.csv" into table blah fields terminated by ',' ; then go ahead and create any indexes etc... !works slick! > Is there an easy way to do th

Re: [PHP] SQL Server DB to mySQL DB

2001-01-25 Thread Pavel Kalian
1. Generate SQL script for your database in the MS SQL Server Enterprise Manager 2. Modify generated SQL to be compatible with MySQL 3. Run the script on your MySQL server Pretty easy if you aren't using any feature of MS SQL that MySQL doesn't support (for example stored procedures) Another way