Re: Want to change only a few tables in a populated database via Workbench

--0016e68decab0391ec048187b013
Content-Type: text/plain; charset=ISO-8859-1

Mike,
thanks sooooo much.  I saw the option there many times and for some reason
never thought to use it.  I really feel silly now!

Jordan

Jordan R. Thompson
[email protected]
www.ThompCo.com



On Thu, Mar 11, 2010 at 9:49 AM, Mike Lischke <[email protected]> wrote:

> Hey Jordan,
>
> > I have a database that is populated via an application that parses binary
> > data.  It takes the better part of the day to run this application to
> > populate the database.
> > Unfortunately, I am developing another part of the database and every
> time I
> > want to make changes to it (via workbench) I find myself dropping the
> > database, loading the new one, then repopulating it.
> >
> > Is there any way to tell workbench to just forward engineer _some_ of the
> > tables (how about only the one that are different?)
>
> This is what Synchronization is for. Forward engineering just takes your
> model and creates the objects. Synchronization compares your model and your
> schemata and creates alter statements for any difference.
>
> Mike
> --
> Mike Lischke, Senior Software Engineer
> Database Group, Developer Tools
> Sun Microsystems Inc., www.sun.com
>
>

--0016e68decab0391ec048187b013--