The Data Model Manager simplifies the way we deliver Data Model updates since the Gas Data Model v2.2.

Yes, the CLI installers are discontinued from the Data Model v5.2 release.

There are no new significant features or changes in how you use pdrDataModelManager v1.1.0, it is a maintenance release. There is a minor enhancement in the v1.1.0 release to support the ability to specify a different schema for the PDR_* management tables. This allows the tool to support a Data Interchange deployment configuration where the definition of the PDR management tables and the data model tables are hosted in different schemas, e.g. some Participant SQL Server installations choose to create one schema for the Electricity Data Model and another for the Gas Data Model, putting the PDR tables in either the default schema or somewhere else.

The upgrade fixes a number of issues with running Data Model Manager in Linux type environments:

• An issue with running the GUI installer as a console based application in a headless Linux server (e.g. within an SSH terminal session).
• The interpretation of the Data Model package zip file on Linux-like environments due to a Windows file-based qualifier (backslash). A workaround has been added to allow the Data Model Manager to interpret data model package files packaged with a windows format directory separator “\” to be correctly interpreted. We are not proposing to rebuild the historical deliverables in Gas v2.2 or MMS 5.1 which were packaged this way. The Data Model v5.2 release will be packaged with a directory qualifier matching the zip standard “/”

If you are running a Unix-like environment you must do the upgrade.

Prerequisite checks in the schema.xml file.

Once the change is applied there is no rollback. AEMO suggest backing up your database before doing the upgrade.

Yes, we release them at the same time.

No it assumes the connection is to the database where tables are created.

The Data Model deployment package zip file contains only SQL scripts.

Yes, except we cannot support UPGRADE scripts for mySQL and PostgreSQL platforms. The CREATE deployment package for both Electricity and Gas Data Models provide scripts for all platforms. These are the same Data Model artefacts we have supplied for many years.

No, the functionality of create_object_count.sql is not preserved. So there is a record, the Data Model Manager log contains all newly created tables.