>>Change connection string - done! No recompile or anything required. Like how simple can it get right ??? hahaha

Except that you've run into a problem. ;-) Plus you have a security issue with database connection settings stored in the clear in the dbc on disc. And you risk dbc contention issues. If you don't like USE ... ALIAS, the other option I mentioned was to use xCase to create a dbc with views for local tables and a dbc with views for remote tables. Once you have the correct dbc open there is no programmatic difference. You can put the RV connection string into an encrypted ini file on the server so the app can decrypt it and create the connection for sharing, before you open the RV dbc. No contentions. No connection settings stored insecurely in a dbc on disc. If you use xCase it'll be much easier to keep your local tables and SQL Server synchronized as well, including the views against them.