Topic
  • 1 reply
  • Latest Post - ‏2012-11-27T18:38:32Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic is it possible to run DDL scripts to change a Physical Data Model?

‏2012-11-21T15:30:54Z |
Currently at Data Studio V3.1.1 and looking for a way to update Physical Data Model by running generated DDL scripts.

Found this from link http://publib.boulder.ibm.com/infocenter/dstudio/v1r1m0/index.jsp. Looks like a V1.1 feature, but can't find it in V3.1.1 manual or interface.
======================================================
Applying another deployment script to a model
You can change a model by applying the changes from another deployment script. The model must be a target model, and the associated deployment script for the target model must exist. Use this method of changing a model in the scenario where you want to make the same changes to a database that were made to another database.
Prerequisite: One or more deployment scripts for changes to other databases must exist.
For example, assume that two developers each have their own development database for an application. You want to move the changes that each developer made to the test database for the application. If you have the deployment scripts that the developers used to change their databases, you can apply those deployment scripts to a model of the test database, and then eventually deploy the consolidated changes to the test database.
==================================================

Thanks
Updated on 2012-11-27T18:38:32Z at 2012-11-27T18:38:32Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: is it possible to run DDL scripts to change a Physical Data Model?

    ‏2012-11-27T18:38:32Z  
    Unfortunately the feature for manipulating a model directly from DDL does not exist within Data Studio or IDA. You could do a reverse engineer from DDL to create a model and then do a compare and sync to merge up the changes.
    Michael