copying an ASP database to a mySQL DB

[Anon]

i need to move the data store on a page that is running a database that works with ASP (not sure witch one is it now), to a mySQL database for working with PHP. Can this be done ?! how ?!

Its loots of data, its about an ecommerce book shop. So i dont want to type everything again, thanks.

[Anon]

Yes sure!, you can do it easily.

I will tell 2 ways it can be done!.

1.- Intall PHP in Windows.
a) Connect to your ASP database using ODBC functions from PHP.

b) Connect to your MySQL database using MySQL functions from PHP.

c) Query ASP database (select * from ASPTABLE )

d) Insert Data into MySQL Database.

2.- Install ODBC Drivers for MySQL in windows.
Use Borland Delphi to connect to mysql and your ASP database....

You can use TBatchMove component to copy all data.

3.- You can Also your the DAta Migration Wizard that comes with Delphi.

[Anon]

Most database programs allow you to dump the contents into a file, also. You can either dump SQL statements or just the data in a tab delimited file. Then the file can be imported into mysql...

For SQL statements:

(command line): mysql -uuser -p < your_file

For flat file:

(mysql command line):load data infile 'your_file' into your_table;

I don't know if this will be easier than writing a program to transfer the data or not...it's up to you.

---John Holmes...