Instead of providing database credentials, you can generate Data Definition Language (DDL) statements from the data models in BizWorks and execute them on your database. The platform can generate two types of database scripts: table structure creation statements and table structure modification statements.
Procedure
Log in to BizWorks, in the select Platform drop-down list selected modeling Platform.
Click the
icon or the text box in the upper-right corner of the page. From the drop-down list, click the name of the project that you want to view and click the Modeling tab. In the Modeling navigation bar, choose . On the Bounding Context page, click the name of the bounding context.
In the navigation pane for the target Bounded Context, click Data model. On the Data model page, click Generate database script.
In the Generate database script panel, configure the script.
From the Database type and version drop-down list, select the target database type. For the generation type, select Table structure creation statement, select a target data model version, and then click Generate script.
From the Database type and version drop-down list, select the target database type. For the generation type, select Table structure modification statement, select the target and initial data model versions for comparison, and then click Generate script.
Review the DDL statements in the code box. Copy and execute the statements on your database. When finished, click Close.