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
ECTED]> Sent: Thursday, January 25, 2001 4:44 PM Subject: [PHP] SQL Server DB to mySQL DB > Is there an easy way to do this? I know that SQL Server can export a comma > delimited file, can mySQL import this? I imagine the PHP will be easy to > modify as long as the field names are the same

[PHP] SQL Server DB to mySQL DB

2001-01-25 Thread Jason Bouwmeester
Is there an easy way to do this? I know that SQL Server can export a comma delimited file, can mySQL import this? I imagine the PHP will be easy to modify as long as the field names are the same. Thanks, jb Jason Bouwmeester New Media Consultant InterVisual Suite 200, 709 - 11th Ave SW Calgar