Changing Default Schema for SQL Store

[tcomben]

Hello,

Is there way to change the default schema from dbo to something else for the SQL store driver? For SQL Azure, it's common to separate your "databases" into different schemas. In our case, we do not want to use dbo as we reserve dbo for another dataset.

Thanks,

Tim

[jan_blaha]

Hi Tim,

I've just published this feature. Please update

npm i jsreport-mssql-store@1.4.0

and use schema config

{
	"store": {
		"provider": "mssql"
	},
	"extensions": {
		"mssql-store": {		
			"schema": "mycustomschema"			
		}
	}
}

[tcomben]

Excellent timing; thank you!