Error Deploy in another Schema

[YoshiakiToma]

In package.json is possible deploy in another schema at change de config, but when it is generate build mta, the archive generated schema "default".

{
    ...
    "cds": {
            "migrations": {
			"db": {
				"schema": {
					"default": "S4Q", // Here Change
					"clone": "_cdsdbm_clone",
					"reference": "_cdsdbm_ref"
				},
				"deploy": {
					"tmpFile": "tmp/_autodeploy.json",
					"undeployFile": "db/undeploy.json"
				}
			}
		}
     }
}

[gregorwolf]

Hi @YoshiakiToma,

can you please improve the formatting for better readability.

[YoshiakiToma]

This is my config JSON, sorry for I can't use block code of github. @gregorwolf

[gregorwolf]

You can. Just use tripple backticks.

[YoshiakiToma]

@gregorwolf Sorry, I send image wrong.

This is correct image, I tried change schema, but the tables were deploy in schema public.

[YoshiakiToma]

When you see in archive package.json in folder gen/db, the config schema is public.

[alessandro-pavan]

Hi,
I have the same issue. I need to deploy my database on a different schema from "public". How I can achieve that?