Reverse Engineering

Export SQL DDL From MySQL Workbench for Importing Into Vertabelo

Tags:

MySQL
reverse engineering

Dominika is a Python software developer. She graduated from the Warsaw University of Technology with a degree in computer science. At Vertabelo, she creates content as a technical writer. In her free time, she runs, practices yoga, and learns foreign languages.

Do you have an existing database model you would like to work with in Vertabelo? If so, you've come to the right place! In this article, you learn how to export a DDL file from MySQL Workbench and import it into our modeling tool. We also take a look at other ways to import an existing database schema into Vertabelo and organize existing tables. How to Export a DDL File From MySQL Workbench First, let's see how to export an existing database.

How to Export an SQL DDL File From SQL Server Management Studio for Reverse Engineering

Tags:

reverse engineering
SQL Server

Martyna Sławińska

Martyna is a software developer with a passion for programming, automation, and innovation. Currently working for the global corporate IT consulting sector, she is a new-generation techie who hails from Warsaw University of Technology, Poland. She has certifications in both database administration and Java development. Her interests include creating small automation devices using embedded systems and various electronic components. In her free time, she practices yoga, which helps her to center her thoughts and come up with new ideas.

Keep your database secure and up to date by deconstructing your database to extract and update its design. In this article, we show you how to export an SQL DDL file from SQL Server Management Studio, that is, export your SQL Server database in the form of an SQL script, and import it into Vertabelo. Also, you'll learn about the Vertabelo Reverse Engineering tool to export your entire database into an XML file and import it into Vertabelo for further processing.

Reverse Engineering With Vertabelo

Tags:

Vertabelo Features
reverse engineering

Vertabelo Team

Learn how to import your database into Vertabelo and generate its data model with our improved reverse engineering feature. We’re excited to announce the release of a new version of our popular reverse engineering tool. You've been asking for a user-friendly interface, and we heard you. If working with Java is not your thing, our new graphical user interface lets you click through the process in no time. Download the upgraded reverse engineering tool here.

How to filter tables in the Vertabelo reverse engineering tool

Tags:

reverse engineering
Vertabelo Features

Agnieszka Kozubek

Agnieszka is a Chief Content Officer at Vertabelo. Before coming to Vertabelo, she worked as a Java programmer. She has a PhD in mathematics and over 10 years of experience in teaching mathematics and computer science at the University of Warsaw. In her free time, she enjoys reading a good book, going mountain hiking and practicing yoga.

Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy. Use the -regexp option and the tool will extract all tables and views with names matching the regular expression. The tool prints the regular expression it uses so you can verify that your shell parsed the expression correctly.

New Feature: Photo Reverse Engineering

Tags:

reverse engineering

Vertabelo Team

We're happy to announce that Vertabelo has a new feature we've been working on for some time: Photo Reverse Engineering. This is the quickest way to transfer your hand-written design sketches into Vertabelo. Draw your model on a piece of paper, a whiteboard, or a blackbord, take a photo, upload it into Vertabelo and you're done: your model is in Vertabelo. How it works Draw your model on a board, or a piece of paper.

WordPress Database Finally Unveiled!!!

Tags:

Rafał Strzaliński

Principal Engineer, Technical Team Leader at Vertabelo

Sorry for that tabloid title, but I couldn’t resist. I’m going to show you how to view the database design of other people’s systems. It will work for legacy systems as well. Of course, you may call show tables and describe table in the database console but that’s a very rudimentary way to examine the structure. You’ll miss a bird’s eye view of the design which is crucial to understanding a system as a whole.