data_copy: Copy data from one database to another

In austl001/MOSLR: MOSL Reports and Utility Functions

Copy data from one database to another

Description

data_copy() is designed to copy data from one database to another. By default, it copies the OPS data from data-mgmt3 to data-mgmt. Can also save the table as .csv file

Usage

data_copy(
  my.dir = getwd(),
  conf.loc = NULL,
  conf.from = "datamgmt3",
  conf.to = "sandpit",
  query = NULL,
  saveDB = TRUE,
  output.table = "PERF_OPSData",
  overwrite = TRUE,
  append = FALSE,
  save.csv = FALSE,
  csv.file = "/data/inputs/OPS_data.csv"
)

Arguments

my.dir	working directory
query	SQL query that gets the source data
saveDB	should the data be saved to a new database
output.table	name of the output table in a database
overwrite	should the existing table be overwritten
append	should the existing table be appended to
save.csv	should a csv file be saved
csv.file	name of the csv file
server.from	server name for the source data
server.to	server name to where data is copied to
db.to	database name to where data is copied to

austl001/MOSLR documentation built on Aug. 17, 2022, 12:07 a.m.