Fix a (possibly noncommutative) ring R and consider the category $Rings_R$ of rings $S$ with a map $S \to R$. There is a extension of scalars functor to R-bimodules $Rings_R \to R-Mod-R$ which sends $S \mapsto R\otimes_S R$.
This functor turns out to preserve colimits. Does it have a right adjoint?
More specifically, I am interested in showing that its derived version $S \mapsto R \otimes^L_S R$ preserves homotopy colimits, where $S$ and $R$ are now dg categories. Does this functor have a derived right adjoint?