hrsampleCreateSQLServer: Load hrsample to SQL Server

Description Usage Arguments Examples

View source: R/hrsampleCreateSQLServer.R

Description

This function loads the hrsample tables to a Microsoft SQL Server database that the user has access to. It utilizes the odbc package . The parameters are based on the odbc parameters.

Usage

1
2
3
hrsampleCreateSQLServer(driver = "ODBC Driver 13 for SQL Server",
  dbname = "master", server = NULL, user = NULL, password = NULL,
  port = 1433)

Arguments

driver

Driver that will be used to connect to SQL Server. Might be something like 'ODBC Driver 13 for SQL Server'.

dbname

The name of the database the tables will be stored to. Must be a preexisting database. Ideal name would be "hrsample". This function does not create a new database.

server

Name of the SQL server. If working with a remote database, may be something like "johnny.heliohost.org". If working with a database on your local machine it might be "localhost\\SQLEXPRESS".

user

Username to log into database

password

Password for user

port

port to be used

Examples

1

harryahlas/hrsample documentation built on July 22, 2019, 11:06 p.m.