Here is a quick overview of my situation. I have an established website that has been around for 10 years and gets great amounts of traffic. The only problem is that it used to get a lot more. I bought the site a few years ago from the person who originally programmed it. It's written in ASP and uses SQL SERVER 2000 for all its DB purposes. I think the site could do better if I were able to keep up on the site a little better. The site has hundreds of ASP functions and XML functions and I've been able to do minor changes to it, but I'd like to start with my own design in PHP. This way I can handle any and all changes or problems that occur with the site. Since I've built in from the ground up I'll be in total control. One thing I need to do is migrate the current site and DB to another dedicated server. When I do that I'd like to run my new PHP site and keep all the data currently in the site in tact. So that would mean I'd have to run PHP with SQL SERVER 2000 and I've never tried that. I'm pretty good with MYSQL, but that would mean I'd have to transfer data from SQL SERVER to MYSQL. Does anyone have an opinion on which would be more effecient? Transferring data from SQL SERVER to MYSQL or connecting PHP with my current SQL SERVER. Any help would be much appreciated. Thanks!
I would definately switch to PHP + MySQL. Id want to get clear of any proprietery software (eg Microsoft) especially when it comes to servers. Your going to find your server costs go down (you dont need to pay for the M$ crap) and you will free up more resources as a LAMP stack uses alot less resources than windows server.