Welcome to WebmasterWorld Guest from 54.224.230.193

Forum Moderators: open

Message Too Old, No Replies

Migrate asp site database to new php website

     
8:04 am on Jul 13, 2012 (gmt 0)

Full Member

10+ Year Member

joined:June 17, 2003
posts:208
votes: 0


Hi,

We have a site in asp and we wanted to redesign our site in php.
our website has a lot of listings (e.g yachts) and I was wondering if there is any way to transfer all the information from our asp database to the php mysql database without having to input all the information from the beginning so that we can pull all the information from the mdb database to the new mysql database.

can this be done?

thanks
12:09 am on July 15, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 31, 2005
posts:1108
votes: 0


What type of database does the asp site use? MS-SQL? What version?

You should either be able to get a connection established between the two databases and then use a data export tool to push data between them.

Or if that's too hard you can export to a file e.g. CSV and import those into your MySQL one.
6:59 am on July 19, 2012 (gmt 0)

Full Member

10+ Year Member

joined:June 17, 2003
posts:208
votes: 0


Thanks for the reply,
I am not sure what type of database we use, I am not an asp programmer, but I found this in the db connection file if it helps to find out what type and version it is.


'Set objConn = Server.CreateObject("ADODB.Connection")
'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & objDB & "" %>
11:56 pm on July 19, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 31, 2005
posts:1108
votes: 0


That is a Microsoft Jet 4.0 database.