Turn off schema creation for mssql store



  • Hello,

    Is there a way to skip creating the schema in a database? We would like to do the following:

    1. Allow the node jsreport package to create the schema on a dev database.
    2. Replicate the schema on higher level platforms (test, and prod).
    3. Tell the jsreport package to skip schema creation on higher level platforms.

    We do not want the application to run under a SQL login with the ability to modify schema, for obvious security reasons.

    nodejs jsreport
    mssql store

    Thanks,

    Tim



  • To add to this:

    It would also be helpful if we could change the default schema from dbo to something else. We're using SQL Azure and want to separate the jsreport schema into it's own schema.



  • Yes, this makes sense.

    You can subscribe here to be notified when this configuration value is ready. I believe it comes with jsreport 2.7.0 soon
    https://github.com/jsreport/jsreport/issues/674


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.