Currently you cannot parameterize the Automator project file. In Automator v12.4+ you can create a connection definition. On the prod server create a connection definition. Import the QA project file to the prod. Open the project file in the project editor, and change the connection string using the connection definition option.
Hi Mo thanks for the feedback much appreciated yeah I have found this out the hard way, one way I have got around this is by setting up a global script so that any projects that need to can access this. So on both servers I will have the same public class but just change the connection string. I am hoping that by implementing this way at least I will not have to go into each project file to ensure that the connection is sitting at the correct one.
Though I have heard as well though Olly that in version 13 that monarch utility may facilitate this functionality.