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.
Pinned topic is it possible to run DDL scripts to change a Physical Data Model?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-27T18:38:32Z at 2012-11-27T18:38:32Z by SystemAdmin
SystemAdmin 110000D4XK1632 Posts
Re: is it possible to run DDL scripts to change a Physical Data Model?2012-11-27T18:38:32ZThis is the accepted answer. This is the accepted answer.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.