Need to Export Records to Remote Terminal
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
Option 1: write a program to do it. Option 2-n: depends upon the database platform you are using. For example, SQL Server has very powerful data transfer mechanisms built in, such as DTS and RPC which can run on a scheduled basis. onwards and upwards...
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
These are the steps in script that u'll be needing- - BCP out the data into a text file. - FTP the file to the remote location. - Insert the file in remote database using remote stored procedure. - Delete the records from source database. Hope this helps. Gaurav
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
This is a fairly old thread, but I just stumbled across it looking for an answer to a distributed transaction question I have. Anyway, does your export procedure need to be transactional? i.e. Do you want to ONLY delete the source records once they are in the remote system? And do you want the destination records to ONLY be valid once they are deleted from the source? I have architected many systems like this where the data needs to be in one place OR the the other but not both, and not get lost, like in this example. while (there are more records to export) { begin transaction; try { export record to remote system; delete record from local system; commit; } catch () { rollback; } } These systems are hard to accomplish, sometimes you are better off assuming that the 2 systems are only going to communicate asychronously and then revisit the problem you are trying to solve. If that doesn't help you one iota I won't be too suprised. JBoy