cds-dbm icon indicating copy to clipboard operation
cds-dbm copied to clipboard

Error Deploy in another Schema

Open YoshiakiToma opened this issue 2 years ago • 6 comments

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"
				}
			}
		}
     }
}

YoshiakiToma avatar Jun 20 '22 19:06 YoshiakiToma

Hi @YoshiakiToma,

can you please improve the formatting for better readability.

gregorwolf avatar Jun 20 '22 19:06 gregorwolf

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

image

YoshiakiToma avatar Jun 20 '22 19:06 YoshiakiToma

You can. Just use tripple backticks.

gregorwolf avatar Jun 20 '22 20:06 gregorwolf

@gregorwolf Sorry, I send image wrong.

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

YoshiakiToma avatar Jun 20 '22 20:06 YoshiakiToma

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

image

YoshiakiToma avatar Jun 20 '22 20:06 YoshiakiToma

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

alessandro-pavan avatar Mar 02 '23 14:03 alessandro-pavan