copy_loop_to: copy_loop_to transfers table from one database to another

Description Usage Arguments Value Examples

Description

Transfers table from one database to the another without overloading R memory. Best used when databases don't have a connection to eachother.

Usage

1
copy_loop_to(conn1, conn2 = NULL, name, n = NULL, statement)

Arguments

conn1:

Connection to initial database where the table is coming from.

conn2:

Connection to the database where the table is transferring to. If conn2 is NULL then conn2 will default to initial database.

name:

Name of table on conn2 database

n:

Batch loader, amount of data to be transferred with each cycle.

statement:

SQL statement on initial database.

Value

Transfers table from intital database to another.

Examples

1
2
 #Sends table (created from sql statement) from post database to tera database with a batch load of 100.
   copy_loop_to(post, tera, "testdata", 100, "SELECT * FROM TESTTABLE")

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.