"Generate scripts for initialization" only generates update scripts

[Former Member]

Using Hybris 6.7

I go to HAC > Platform > SQL Scripts > Schema initialization/update scripts

And select the radio button for "Generate scripts for initialization"

And click the button "Generate Scripts"

Two files are created:

Create Tables Script ....\temp\hybris\update_master_schema.sql

Initialize TypeSystem Script ....\temp\hybris\update_master_data.sql

These files only contain a few lines each with things like ALTER TABLE and UPDATE statements. These are clearly not the full schema initialization scripts.

Why is the option to "Generate scripts for initialization" only generating update scripts and how can I get the full schema initialization scripts?

[arvind-kumar_avinash · Accepted solution]

Please go to hAC > Platform > Initialization and click SQL Scripts. This will open a similar page as you have mentioned. Please select Generate scripts for initialization and click Generate scripts. It will generate the following 3 files and they will have the required material you are looking for:

• init_master_data.sql

• init_master_drop_schema.sql

• init_master_schema.sql

If you are looking for ImpEx script to export the data, please go to backoffice > System > Tools >Script Generator and click GENERATE. Copy the resulting script and use it in hAC > Console> ImpEx Export window to export the data.

[Former Member · Accepted solution]

Thanks Arvind! This worked!

[arvind-kumar_avinash · Accepted solution]

You are most welcome.