Live Connections

14 views
Skip to first unread message

Beza...@alfredstate.edu

unread,
Feb 4, 2012, 1:51:48 AM2/4/12
to risee...@googlegroups.com
Is there any way to connect Rise to a live server, and then automatically create a model from an existing database?

Why I ask is, I have MySql Community Edition, 5.5.1.9 running on this laptop, and I started putting together a set of databases. I already have 3 of them partially created, and there are 2 more I have to start from scratch soon. I am at the same time making a server application for a game client, and I haven't finished finalizing what-all I need to have in the 5 different databases this server will need to access. (I'm keeping the different kinds of information completely separate, with different usrnames and passwords on each database in case one of them gets hacked, so that hackers wouldn't get *all* the information in one rush.)

What I'd like to do is connect Rise to one of these five databases on the MySql server, grab the layout of table structures and produce a model from it so I can see visually what else I need to add. Then after modifying the structure, I'd generate a new SQL script with your MySql generator, hop into HeidiSql, import and run it.

What I can't figure out is, how to grab the existing structures and generate the model from them.

Cameron Rout

unread,
Feb 4, 2012, 7:37:14 PM2/4/12
to beza...@alfredstate.edu, risee...@googlegroups.com
Just set up schemaSpy with SchemaSpyGUI to reverse engineer the scheme
into images.

Had to install Graphviz first, but now I can reverse engineer into a
clean schema viewer and go from there into rise or anything else.

Cameron Rout, P. Eng.
Risk Engineer

Sent from my mobile device, please excuse typos and irregular
formatting for the sake of brevity.

Confidentiality Warning: This message and any attachments are intended
only for the use of the intended recipient(s), are confidential, and
may be privileged. If you are not the intended recipient, you are
hereby notified that any review, retransmission, conversion to hard
copy, copying, circulation, or other use of this message and any
attachments is strictly prohibited. If you are not the intended
recipient, please notify the sender immediately by return e-mail, an
delete this message an any attachments from your system. Thank You.

On 2012-02-03, at 11:52 PM, "Beza...@alfredstate.edu"
<Beza...@alfredstate.edu> wrote:

> --
> You received this message since you subscribe to the "RISE" Google Group.
> To add a message to the group, send an e-mail to risee...@googlegroups.com
> To end the subscription of this group, send an e-mail to
> riseeditor+...@googlegroups.com
> For more alternatives, visit this group at
> http://groups.google.com/group/riseeditor?hl=en

Reply all
Reply to author
Forward
0 new messages