Can Directus support other schemas for MS SQL?

[calsch03]

Hello, I'm trying to implement Directus to an existing Microsoft SQL database server. I connected Directus with the database, but no collections are visible in Directus. I use multiple schemas in my current database. Can Directus work with multiple schemas or can it only use the default dbo schema?

Database example:

[rijkvanzanten]

Heya! There's currently no way to set the schema used for MS SQL unfortunately. Postgres' connection through pg allows you to configure the search path on a global level, but tedious (the connector for MS SQL) has no such thing.

We're looking into implementing a way to dynamically add the schema to every query made within Directus, but that's a little tricky cross-database, so that's TBD

[calsch03]

Tnx for your quick response. Directus looks to be a good fit for our problems. It might be possible to migrate the database to PostgreSQL in the future.

[aguldbrandsen]

Hi! Are there still no options to set another schema than the dbo schema on MS SQL? I have tried using a SQL user that has default schema set to directus, and the tables are created when deploying but the application doesnt start succesfully.