homepage Welcome to WebmasterWorld Guest from 54.145.183.126
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

    
Convert MSSQL Database to MYSQL in under 15minutes?
Help - Advice Needed! Might need to switch technologies!
TravelSite

10+ Year Member



 
Msg#: 3994011 posted 10:05 am on Sep 23, 2009 (gmt 0)

Hi,

Our main supplier has given us a daily updated 5GB MS SQL database (updated via a Windows download application that I currently run on my local pc).

I need to find a way to get the data contained in it into our (PHP/MySQL) website as quickly as I can, after its daily update. We're also about to start on a complete website redesign (including buying a new server) to capitalise on this data.

The two options that I can currently see are to:

1. Convert the MSSQL database into a MySQL database on my local machine each day and then ftp it to the server.

2. Buy a Windows server and design a new site in ASP/MSSQL. (Allowing the application to to run on the server and update the database).

Does anyone have any recommendations? Or know if its possible to convert a database that large into MSSQL quickly?

Thanks

 

vincevincevince

WebmasterWorld Senior Member vincevincevince us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3994011 posted 12:47 pm on Sep 23, 2009 (gmt 0)

PHP can access a MSSQL database. Stay in PHP, but use (e.g.) mssql_connect. If you use an OOP database model you should be able to switch in just one place. Get a VPS server to host the database, automatically scheduled to do the updates. Have you existing server and site connect via a tunnel to the database server.

TravelSite

10+ Year Member



 
Msg#: 3994011 posted 9:26 pm on Sep 23, 2009 (gmt 0)

Hi Vincevincevince,

- Thanks for the answer.

The database is fully normalized - would that make it an OOP database model (sorry if its a stupid question!)?

vincevincevince

WebmasterWorld Senior Member vincevincevince us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3994011 posted 11:21 pm on Sep 23, 2009 (gmt 0)

Sorry, I meant, if your existing code is using an OOP model to access the database; e.g. you do not write mysql_query() but $db->query; in which case you can swap out mysql for mssql through the object.

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