I am not seeing any option to tell Ignition to use anything besdies the default schema for the database its connected to. Is there any way to point it to use any other schema besides dbo?
No. You could just make an additional DB connection in Ignition (to the same actual database server) with the different schema specified.
MSSQL calls what every other DB calls “schemas”, “databases”, from what I understand.
Are you sure? That is the name of our database, not schema
One thing that I’ll provide here is that Ignition will use whatever the Default Schema is configured for the defined user. See the example below where I modified the ignition
user I’m using to connect Ignition to my MSSQL DB to use a schema foo
(instead of the default dbo
):
I’m not sure offhand of what might be able to be done to specify a schema for MSSQL over the JDBC connection properties… I figured I’d mention the above though if that might be a good solution for you…
EDIT: it appears that this might actually be the way to go; doesn’t seem like you can specify the schema via the JDBC connection properties.
This is exactly what I’ve been doing; creating an ignition
login that owns and defaults to the ignition
schema. As well as being part of the dbo
group so it’s able to create tables unrestricted.