Devart Forums

I can attach another database to connected SQLite database, with attach command.

I can perform queries on it.

But if I try to retrieve meta datas with TuniMetadata, it fetch only connected database.

This error happens with sqlserver too.

How can I fetch information from another database under the same SQLite connection?

The point is that the SQLite server does not provide information about attached databases.
We are investigating this problem. As soon as we solve this question we will let you know.

thanks!!!

Adoniram: under SQL Server how do you switch the default database for subsequent Selects to another database without reconnecting? Do you call "USE xxx" as a SQL statement to switch? I haven't tried that myself, maybe you could confirm that, thanks.

Tobias,
I decide to work with schemas on SQLServer. Instead of spread tables among many databases, i will keep it on one database and put them on different schemas.
It solve my problem.

Thanks!