homepage Welcome to WebmasterWorld Guest from 54.146.190.193
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Migrate asp site database to new php website
htdawg

10+ Year Member



 
Msg#: 4475292 posted 8:04 am on Jul 13, 2012 (gmt 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

 

Dijkgraaf

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4475292 posted 12:09 am on Jul 15, 2012 (gmt 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.

htdawg

10+ Year Member



 
Msg#: 4475292 posted 6:59 am on Jul 19, 2012 (gmt 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 & "" %>

Dijkgraaf

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4475292 posted 11:56 pm on Jul 19, 2012 (gmt 0)

That is a Microsoft Jet 4.0 database.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved