Investigating moving an windows app with multiple MSSQL databases.
Currently the use selects a database on startup.

However there are some weekly processes that could be automated, so an app that can process each database is being proposed.

I am trying to get a handle on what issues could arise with a windows program using redirect connection as far as file buffers especially DDs

Is it required to managed clearing all buffers, dds etc before switching to the next database as windows app is different from a webapp which is synchronized to the client on each request