Swapping Connectionstring between Prod and Development

Swapping Connectionstring between Prod and Development

Hello,

Using latest SDAC and Delphi 11.3:

Today I forgot to change the connection string in an application I sent to a customer. That made me think if there would not be a better, and simpler, method than to replace the connection string and recompile the program after test, before sending it to a customer.

So what is in your opinion the best approach to swap the connection string between the development version and the production version of the  application ?

Regards
Soren