I need to do a little tool for the oracle data imported into SQL, now link two databases, the rest I don't know how to operate, great god door, please advice

CodePudding user response:

If only need tools to ready a lot of ah

CodePudding user response:

Navicat Premium 12, very good very strong

CodePudding user response:

Can own programming import:
1, through the set of controls on meat (such as ADO) respectively connecting two database;
2, and then copy two tables respectively, many methods,

CodePudding user response:

SQL server management studio itself to have the data import/export function, the, with the oracle odbc driver can be between two databases for data import/export.

CodePudding user response:

reference 1st floor liups response:

if just need tools, ready-made a lot o

With an example of this

CodePudding user response:

reference lyhoo163 reply: 3/f

can own programming import:
1, through the set of controls on meat (such as ADO) respectively connecting two database;
2, and then copy the two tables respectively, many methods,

Is there a way an SQL statement to connect two database

CodePudding user response:

Simple with BDE connections, direct a TBatchMove components specifically for this purpose,

CodePudding user response:

To build two TDataModule, a database connection,
Through the Table again, copying,

CodePudding user response:

reference 5 floor qq_36528860 reply:

Quote: refer to 1st floor liups response:

If just need tools, ready-made many

Are there any examples of this

Upstairs downstairs had a lot of examples, you can have a try, to see which one suits you best,
In addition, this tool is only for data migration, usually like what a stored procedure, the index that generally not

CodePudding user response:

SQL is referring to the Ms SQL Server?
If it is:
If the data does not need additional processing - "-" with MS SQL Server directly import function is most quick, safe,
, "no," suggested code, use the Query table each field individually to assign (this method is most effective for BLOB field, for the field type need type conversion also can control more flexible).

CodePudding user response:

If you are often need to oracle data synchronization to the SQL server, can build a link to in SQL server, oracle link server (to use oracle Provider for OLEDB), detailed setting method and the using method, online a lot, so you need to write a simple SQL scripts, and set a SQL homework regularly execute the SQL script is ok, don't need to use the Delphi program,

CodePudding user response:

If often replicate data operation, or in a program, set up a function is more convenient, even using SQL scripts, too,