Stack Overflow
Stack Overflow

Questions tagged [forward-engineer]

Forward engineering refers to the process of taking a less-complex abstraction and using it to build a more complex implementation.

Forward engineering refers to taking a high-level model and using it to build a more complex lower-level implementation (as opposed to reverse engineering where you take a complex implementation and try and convert it into a higher level abstraction).

Some examples may clarify it. Forward engineering is taking an EER (Enhanced Entity Relationship Model) or Database Diagram and having software convert the diagram into physical database tables. Forward engineering is taking a UML (Unified Modeling Language) diagram, and converting it into concrete classes.

For reference, an example of reverse engineering is taking compiled machine code, and converting it into human-readable code, such as C++ or Java.

35 questions
7
votes
3 answers

Command line foward engineering using a .mwb file?

I need to be able to perform a forward engineering from a model located in a .mwb file. All of this from the command line as I would like to automate the process. Can anyone please let me know if this is possible and if so how?
balteo
  • 23,602
  • 63
  • 219
  • 412
5
votes
1 answer

How do I automatically execute a MySQL script or routine after forward engineering from model

I've built a EER Model in MySQL Workbench that I forward engineer to create the database. The forward engineering works perfectly, and the database is created from the diagram as expected. Apart from tables, there are also some Stored Procedures…
sparkyspider
  • 13,195
  • 10
  • 89
  • 133
4
votes
2 answers

Forward engineer a Workbench model but with my own name for the scheme

How can I forward engineer a Workbench model with my given name of the database scheme? Yes I can edit it in the editor window shown on the image, but what if I have 30 tables to export as SQL code? Yes I can use find/replace tool before executing…
Vlad
  • 2,739
  • 7
  • 49
  • 100
3
votes
0 answers

Export .MWB to working .SQL file using command line

We recently installed a server dedicated to unit tests, which deploys updates automatically via Jenkins when commits are done, and sends mails when a regression is noticed > This requires our database to always be up-to-date Since the…
Balmipour
  • 2,985
  • 1
  • 24
  • 28
2
votes
1 answer

Visio 2010 forward engineering to Oracle 10g xe

I've been googleing but maybe I'm not using the right words, so: I have a ER diagram made in Visio 2010, and I what to do a forward engineering to an Oracle database. I've found a forward engineering plugin for Visio 2010 but this generates a MS…
Daniel
  • 1,225
  • 2
  • 15
  • 31
2
votes
1 answer

How to recover architecture of a legacy system (PHP)

I am trying to recover architecture of a legacy system.This is something new to me.Up to now I have read many research papers where most of the researchers have proposed frameworks and automated tools for this.But I have no idea how to choose the…
sadisha nadiej
  • 324
  • 3
  • 12
2
votes
2 answers

Forward Engineering to SQL Server from MySQL workbench?

Is possible to forward engineer to SQL Server from MySQL workbench?
Matt
  • 7,022
  • 16
  • 53
  • 66
2
votes
3 answers

mysql workbench forward engineer not an option

I'm attempting to forward engineer from mySQL workbench. I know to do so I go to database --> forward engineer, but it is not currently an option. It does not appear when I search in help/ spotlight either. Any idea why?
user9199553
  • 37
  • 1
  • 4
2
votes
2 answers

MySQL Workbench - Forward Engineering - Error 1005: Can't create table (errno: 150)

I am on MacOSX using MySQL Workbench 5.2.45 I have designed a database using the EER Diagram functionality and then tried the forward engineering to generate my database to put on my local server. I get the error code: Error 1005: Can't create table…
FinanceGardener
  • 188
  • 2
  • 17
2
votes
1 answer

MySQL 150 error on table creation form mysql workbench (foreign key options conflict with not null in columns, FIXED)

So, i'm getting a pretty 150 error when I forward engineer a schema from mysql workbench. I have made sure all pk and fk have the same type. All tables are innodb engine. Maybe I'm missing something silly here (and apologies if I did), but your help…
cmptrwizard
  • 338
  • 4
  • 9
1
vote
2 answers

What is the difference between verification and validation?

General definitions On one hand, I've been working in embedded systems, specially in aeronautics (were DO178 applies to software) and i'm used to these definitions: validation: check with test, inspection, analysis, demonstration, that the final…
Guillaume D
  • 2,202
  • 2
  • 10
  • 37
1
vote
1 answer

Forward engineering EER diagram in MySQL Workbench

Using MySQL Workbench 5.2.33 with MySQL 5.1.41 I have created an EER diagram. But when I try to forward engineer it from MySQL Workbench, I get the following error: Executing SQL script in server ERROR: Error 1005: Can't create table…
oshirowanen
  • 15,297
  • 82
  • 198
  • 350
1
vote
0 answers

How do I solve this forward engineer problem on MySQL?

I'm trying to forward engineer my ERD that I made, but the Forward Engineer Process gives me as output an error. ERROR: Error 3734: Failed to add the foreign key constraint. Missing column 'straatid' for constraint 'verzinzelf3' in the referenced…
Liza Darwesh
  • 401
  • 1
  • 3
  • 20
1
vote
0 answers

How can I solve my foreign key constraint error when I know I created the relationships right?

-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE,…
Hicks
  • 11
  • 3
1
vote
2 answers

Synchronizing the model modifies UNSIGNED BIGINT to UNSIGNED BIGINT(19)

Environment: Ubuntu 14.04 MySql Workbench 6.2.4 MariaDB 10 When I try to synchronize the model with the database schema and I have en a table a defined type UNSIGNED BIGINT (that is UNSIGNED BIGINT(20)) then it becomes UNSIGNED BIGINT(19). The…
Joe
  • 7,749
  • 19
  • 60
  • 110
1
2 3