How to create a Production Connection dynamically

Hi

If I know my database details, is there a way to create the SC connection dynamically from SC application itself? I don’t want to login to Production environment and create the connection manually as I would be crating lot of connections as per my design and wanted to automate this. Any help would be highly appreciated.

I usually just dump the new connection files into a folder, and copy the _lib/conf/config.php file from my existing production site. I typically redo it when I update my dev and production server though.

There are macro’s you can use to set connections dynamically. See docs.

aducom, thank you i have been using those macros. My question was not about setting the connection dynamically. Its about creating a new connection dynamically. May be deathcon62’s answer gives some clue to me.