如何在Mysql Workbench 6.1中生成数据库脚本 [英] How Do I Generate Database Scripts In Mysql Workbench 6.1

问题描述

嗨朋友们。

我对MS SQL Server有很好的了解，但我是MySql的新手。

我们可以在sql server management studio中生成整个数据库的脚本，

现在我正在使用MySql Workbench 6.1，我想生成整个脚本（表，存储）托管数据库的过程，函数等）。我用谷歌搜索，我发现像我们可以通过正向工程这样做。但我在MySqlWorkbench 6.1中看不到正向工程选项。



请指导我。



在此先感谢

-Sameer

Hi friends.
I have good knowledge on MS SQL Server but i am new to MySql.
As we can generate scripts of entire database in sql server management studio,
and now I am using MySql Workbench 6.1 , and i want to generate entire scripts(tables,stored procedures,functions,etc) of a hosted database. I googled and i found something like we can do this through Forward engineering. But I can't see the Forward Engineering Option in MySqlWorkbench 6.1.

Please guide me.

Thanks in Advance
-Sameer

推荐答案

阅读： http://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html [< a href =http://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.htmltarget =_ blanktitle =New Window> ^ ]

对于MySql Developer，请按照以下步骤生成脚本。



1 =>工具>数据库导出>然后会显示一个弹出窗口。



2 => PopUp确实需要移动数据库的连接，然后浏览需要保存脚本.txt文件夹的路径。



3 =>然后按照'Next'>'Next'...选项..按照每个步骤选中所有选中的和

选中的选项（根据requiremnt，例如，表，程序，vies ......仅需要在脚本中生成。）



4 =>然后最后点击'Finsih'botton然后尝试chekc .txt脚本文件夹保存它。



注意： - 请通过选项你会根据requiremnt获取您需要遵循的步骤。

For MySql Developer, please follow following steps to generate the Script.

1=> Tools>Data Base Export> then will shown a popup.

2=> After PopUp do slelect the connection of databse where it needs to be moved, and
and Browse the Path where scripted .txt folder needs to be saved.

3=> then follow each steps with 'Next'>'Next'... option.. with all selected and
checked option( as per as requiremnt like, wether table,procedure,vies... only need to be generated in script).

4=> then at last click on 'Finsih' botton and then try to chekc the .txt script folder where it has been saved.

Note:- Please go through option you will get what steps you need to follow as per as requiremnt.

这篇关于如何在Mysql Workbench 6.1中生成数据库脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！