I have two servers. One is the testing server and one is the production server. They are NT servers on separate IPs. I do development directly on the testing server (meaning I define the local view as the testing server). I have built databases in a folder named data on each server and defined matching DSNs on each.

I have built apps that run on the testing server, but not on the production server. I think I may not have my LOCAL, TESTING, REMOTE settings right for this configuration. Should apps developed on the testing server work on the production server without special intervention on my part?

I want to develop and test on one server then upload to the production server when apps are working.

I do work similarly as what you are suggesting and have no problem developing my apps. I just keep my connection string the same as the one on the live server so when I upload the files to the live server nothing has to change. Works quite well.