从现有架构/模型使用MySQL Workbench创建数据库 [英] Creating a database with MySQL Workbench from existing schema/model

问题描述

我用MySQL Workbench建立了一个数据库模式(或模型?).我现在想将其放入一个实际的数据库中.

I built a database schema (or Model?) with MySQL Workbench. I'd like to now make it into an actual database.

我看过正向和反向工程师选项，找不到关于我是否需要的明确答案.

I've seen Forward and Reverse engineer options and can't find a clear answer on if either are what I need.

如何将其转换为实际的数据库?

How can I turn this into an actual database?

推荐答案

这用于mysql工作台6.0版和导出 schema .

This for mysql workbench version 6.0 and for exporting a schema.

Select tab MySQL Model
Select File->Export->Forward Engineer SQL Create

在输出SQL脚本文件中放置一个要导出的文件名，然后选择您的选项

Place a file name to be exported in the Output SQL Script File, choose your options, next

Export MySQL table Objects,  
filter tables 

然后创建一个文件，您可以将该文件导入数据库，如果不存在，它将创建模式；如果不存在，则创建表.

Then a file is created which you can import to your database and it creates schemas if not exists, creates tables if not exists.

对于模型，您需要为建立一个架构，表，索引，级联以及与现有数据模型相关联的所有事物的工具支付大量费用.

In the case of models, you need to pay, many bucks, for a tool that creates schemas, tables, indexes, cascading, and all stuff associated to an existing data model.

这篇关于从现有架构/模型使用MySQL Workbench创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！