cfml

i wanted to run a project swaped by two different databases but using some kind of link

Most people just manage their datasource configuration separately for each server.

Or, if you need them to run on the same server, setup the name of the datasource to use as an application variable and swap it out to point to the actual datasource you want to use

Can use linked server approach depending on use case <https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-ver15|https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-ver15>