Show tables ? + 2 Feature requests -- CREATE TABLE

[Thorsten Hohage]

Hi,

On 2007-09-19, at 15:56, Ruslan Zasukhin wrote:

>> alter objptr.... constrain
>> for each objectptr and I verify if tables that are referenced exist
>> in the new db
>>
>> It would be handy to collect these statements with one click and then
>> paste the result in the sql editor where they can be edited and
>> modified where necessary


> This is not easy task, we need all think about it...
>
> As I see you need it to maintain two different Vservers. Yes?
>
> 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.
>
>
> 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.

While all this sounds great there would be a rather simple solutions  
I used with Sybase / Frontbase for several years. They logged all  
create / alter Statements to a log file. I know the date of the last  
changes of a specific server so I simply need to execute all logged- 
statements starting with this date.

But on the other hand, in many, many times changing a structure means  
changing data in this context, too. So I think a "database versioning  
tool" must handle some more serious aspects.

regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany