In: Computer Science
Redesigning a database involves the process of reverse engineering a legacy database to create a data model. There are a host of software tools available to assist with this process. Identify 2 separate tools that will reverse engineer an existing database. What database management systems (Microsoft SQL, Oracle, MySQL, DB2…) will this system work with (list all that apply)? Briefly describe how the tools work for reverse engineering an existing database and the output that the tool provides.
ANSWER Reverse Engineering of Database-
Reverse database engineering is the process by which the logical and conceptual schemas of an old database or set of files are reconstructed from various sources of information, such as DDL code, data dictionary content, database content, or the source code of the application programs that use the database.
· Separate tools that will reverse engineer an existing database are given below –
1. DATAEDO
2. dbFORGE
· Dataedo works for the following Database Management Systems-
SQL, Oracle, Azure Database, Amazon Redshift
· dbFORGE works for following Database Management Systems-
SQL server, Oracle
Other reverse engineering tools are SchemaSpy, Adminer, Navicat Data Modeler. But dataedo and dbforge are most popular tools.
Dataedo working-
1)To reverse engineer database, go to the Database menu and choose the Reverse Engineer option ...
2) Provide the database connection details and click Next. Wait for the connection and click Next again.
3) When you have successfully logged in, the wizard will show you the list of schemes available on the server. Select the ones you want to reverse.
4) Wait for the diagrams to be read and continue with Next. On the next screen, you have an option to select object types and filter specific objects. Ignore it and import all the objects. Click Execute>.
5) Wait for the reverse technique to occur when you're done with Next. The final screen shows you a summary of the import. Close with Finish.
dbForge working- It uses drag and drop for the reverse engineering process.
Drag and drop is done with the help of visual database representation.
All existing objects and connections will be perfectly reflected in the MySQL database diagram to simplify further analysis.
please give a thumbs up if you are satisfied with my answer. Thank you.