Changing platforms

[MUrick]

My company is currently running sugar off of a hosted Linux box. We are interested in moving it in house to a New Windows 2003 server very soon. I was hoping to get some input from anyone who has done this before. Specifically what needs to be done so as to both transfer the data as well as custom fields that were created.

Also, if there might be any issues that will arise when moving from Linux to a Windows? I am thinking things like filenames and pathnames.

Thanks in advance for your help

[y2chuck]

I should be as simple as:

1) make sure the MySQL and PHP versions on your new box are identical to the versions on the hosted Linux box
2) use SQLYog (or someother tool, even phpmyadmin will work) to generate a .sql file for your current installation (data and structure)
3) copy all the files over to your new box
4) run the .sql file generated in step 2 above on the new box
5) update anything required in the config.php file (like the new url, db name etc)

i've moved my Sugar install around a few times, on the same infrastructure mind you, but the above methodology should work fine.

The only issue I ran into was a difference in MySQL versions which I needed to correct to finish it.

[MUrick]

Thanks for the imput

[florenceit]

I also have moved my sugar install around a lot too, as i maintain it in house. I actually have migrated to new platforms with different versions of sql and php (I had problems but they were resolvable). Anyhow..

I am this time testing out a new Linux distro that has its web root in a different path. (normally my install was /srv/www/htdocs/sugar and on the new platform its /var/www/html/sugar. I put the sugar files and db in the same folder/db name as usual , all db login info is setup the same and it it all appears to work just fine. Is there a physical path in a config file that I haven't seen yet or is it all relative? I expected lots of issues but it just works. This is not the linux software configuration i love and hate (so far).
thanks!

update: i did have to update config.php but so far thats it.