Multiple Schema Concept - SAP-archive/xsk GitHub Wiki
Multiple Schema Concept
When migrating project to XSK
When working with schemas there are 2 options:
- Import all artifacts into one schema
- Import all artifacts into multiple schema. In order for artifacts to be visible inside all schemas a public synonyms will be created. (one synonym for each table and view)
Currently the XSK support the second option.
For example:
If we import .hdbtable artifact that cntains schemaName
, the artifatc will be createad inside that schema and a public synonym will be created with the same name as the artifact.
table.schemaName = "MYSCHEMA";
table.tableType = COLUMNSTORE;
table.columns = [
{name = "ID"; sqlType = INTEGER; nullable = false;}];
table.primaryKey.pkcolumns = ["ID"];
This concept is supported for:
Operation | Artifact | First Option Supported | Second option Supported | Comment |
---|---|---|---|---|
Create/Delete/Update | Table | :x: | :heavy_check_mark: | |
Create/Delete/Update | View | :x: | :heavy_check_mark: | there is no update operation, the view is dropped and then recreated |
Create/Delete/Update | Procedure | :x: | :x: | |
Create/Delete/Update | Functions | :x: | :x: |