Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
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?