Copy RecordSet

Databases
1

How i can insert all the Data from One Table to in Other Database with the same Table name

2

you can combine Insert and Select commands.

see
http://www.w3schools.com/sql/sql_insert_into_select.asp

3

Christian, I think he is speaking of tables in different databases, not tables.

Some options:

  • If you are using SQLite look at AttachDatabase.
  • Export to a file and import into the other database from that file.
  • Generate INSERT statement strings from db1 and apply them to db2.
4

i need to replicate or Clone Db1 with table1 to Db2 with table1 (i am using PostgreSQL)

5

dblink is a module which supports connections to other PostgreSQL databases from within a database session:
F.9. dblink