I am using Linux Ubuntu 10.x Os
1.Open 'MySql Workbench 5.2.31'
2.Select your Default Database
3.Select 'Database' option In menu bar
4.Then Select 'Reverse Engineer' or press 'ctrl+R'
5.It Will Open A 'model' Window Dont Close it
6.Then select 'File' option in menu bar
7.Select 'Export' then Select 'Forward Engineer Sql Create Script ' option
/Ctrl+Shift+G it Will open a new Window
8.Click 'Browse' Window Save Your File As '.sql' Extension
9.Then Tick Wanted Options In that Window then Click 'Next' button
10.Then Tick wanted Options.This will import wanted tables into sql Script
You can Select Views as well as Triggers
11.Then Click 'Next' Button(you Can see Generated Sql Script)
12.Click 'Finish'...Its Done!!!
No comments:
Post a Comment