Home > database >  Everyone a great god have what good method can make two same database import and export of a part of
Everyone a great god have what good method can make two same database import and export of a part of

Time:09-21

If have A database, and now want to put in A certain table A1 A few lines of data export,
No matter what format for export, the text also go,
Otherwise the database B, and the database table and its structure in A completely,
In database table B1 B receive front that several export data completely,
The only change is the only one from increase of CPID fields, (because the two libraries do not match the list only the column content)

CodePudding user response:

Can be added to the query conditions, import lead to a new table, then write in the insert statement in, is better

CodePudding user response:

Kettle, with 30 minutes and see tutorial can perfectly solve the problem that you want to

CodePudding user response:

Two databases in different places, not connected to the Internet,
Need to export, import data is also your choice of a few random,
This can be?
refer to the second floor qq_39850605 response:
kettle for 30 minutes and see tutorial can perfectly solve the problem that you want to

CodePudding user response:

After the source-sink export, object library imported, imported processing

CodePudding user response:

reference think18 reply: 3/f
two databases in different places, respectively, is not connected to the Internet,
Need to export, import data is also your choice of a few random,
This can be?
Quote: refer to the second floor qq_39850605 response:

Kettle, with 30 minutes and see tutorial can perfectly solve the problem that you want to

Can solve, want to take out the original library data to draw text (support most of the file format), then import (supports multiple format file data import), establish derived using a text, the text import

CodePudding user response:

RMAN backup and restore

http://www.verejava.com/? Id=17173804029058
  • Related