Table copy

[Ruslan Zasukhin]

On 12/3/09 2:48 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,

> I like to copy a table with all records to another database.
> I found this in sql:
> 
> dest_vdb.SqlExecute("INSERT INTO newtbl SELECT * FROM source_vdb.sourcetbl")
> 
> But in which syntax do I specify the source-databasefile in this sql?

To move records between dbs you should use

A) text export/import
B) Sql export/import
C) XML export/import

On your choice.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]