Show tables ? + 2 Feature requests -- CREATE TABLE

[Bart Pietercil]

Hi Ruslan,
On 19-sep-07, at 15:56, Ruslan Zasukhin wrote:

> On 19/9/07 4:06 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> <snipped>
>
> This is not easy task, we need all think about it...
>
> As I see you need it to maintain two different Vservers. Yes?

Not really, but I don't think it makes a difference. The solution we  
are building consist of 2 (or more) VServers + 3 or 4 local Valentina  
DB (these are subsets of the main VServer solution, and exist in  
order to make it possible to work offline + sync with a VServer later



>
> I remember few months ago, you have point some Postgre related  
> utility,
> which do diagrams and some scripts. Diagrams we have implement more  
> or less,
> so now Vstudio guys can try do second feature.
>

That was probably dbWrench (http://www.dbwrench.com)

>
> IMHO in ideal the task which you describe above should looks as  
> easy as
>
>     Drag and Drop of table T2 from db1 to db2 window.
>
> Agree?
>
>     and Valentina Studio then should show any helper dialogs to help
>     resolve complex issues with dependencies around this table.

Agree

To resolve links would be 1) create dependent table or 2) point link  
to another existing table
Of course 1) would lead to more links that need non existing tables.....


DBWrench solves this by generating an sqlscript to recreate a (part  
of) a schema in another connection (db)


Bart