PB, please use SQL SERVER, how to from another SERVER SQL SERVER data, hope that the client is written in the program to solve, thank you for the first,

CodePudding user response:

To do an additional server connection

CodePudding user response:

To create a transaction object
The transaction object to connect to another SERVER SQL SERVER

When using the using the transaction object

CodePudding user response:

This know, it is connected, but how to copy the data to come over? To another database? Connected to the database, how to copy to another?

CodePudding user response:

Right - all the tasks, with import and export

CodePudding user response:

We hope in the client program written in solution

CodePudding user response:

Do the two data window, dw1 and dw2,
Dw1. Settransobject (db1)
Dw2. Settransobject (db2)

After dw1 to retrieve the data, using rowcopy into dw2,
Put dw2 update the useing db2

Move the db1 database data into db2.

CodePudding user response:

Using the data sharing, and then the update,

CodePudding user response:

Pb in the solution:

Transaction:
Server 1: trans_1
Server2: trans_2


Dw_1. Settrans (trans_1)
Dw_2. Settrans (trans_2)

Dw_1. Retrieve ()
Dw_1. Rowscopy (1... Dw_2)

Dw_2. The update ()

Dw_1, like dw_2 field must

CodePudding user response:

Using data pipeline

CodePudding user response:

The transaction sqlca_db2

Sqlca_zjk=create transaction

Sqlca_zjk. DBMS="MSS Microsoft SQL Server"
Sqlca_zjk. Database="Database"
Sqlca_zjk. ServerName="server"
Sqlca_zjk. LogId="sa"
Sqlca_zjk. The AutoCommit=False
Sqlca_zjk. DBParm=""

Connect using sqlca_db2;

Dw_1. Settrans (sqlca)
Dw_2. Settrans (sqlca_db2)

CodePudding user response:

I have the same method with the eighth floor

CodePudding user response:

Large amount of data is not big? If the data is most likely to consider the paging import, otherwise your memory resources will be depleted, the way I've done is, first to extract 200000 records from the source database, and then put the 200000 records strips inserted into a database, and then to the limit of the next 200000... Until the data extraction is complete

CodePudding user response:

With the method of the 8th floor is good
12th floor concern is reasonable, feel appreciated

CodePudding user response:

Personal recommendations or use data pipeline is better

CodePudding user response:

For the top

CodePudding user response:

Can use of pipeline, forming procedure, and support according to last from one database to another database, the example of pb, can see,

CodePudding user response:

Use links to the server, and then just like other database operations on the server as well as the data of operation.
Link to the server using please refer to the following posts:
http://topic.csdn.net/t/20061212/11/5224107.html

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~

CodePudding user response:

A little difficulty oh