attach – Attaching database to an existing connection


Is attaching the database supported only by SQLite and MS SQL Server?

And all other DBMSes can only have 1 DB per connection?


Let’s say there is a archived DB with some historical data and the application needs to compare with the current data for the same period.

The DB in use is not the 2 mentioned above.

How do people solve that?