1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
# MySQL
## Install drivers
```
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install msodbcsql17 mssql-tools
```
Check available:
```{r}
odbc::odbcListDrivers()
edit_file("/usr/local/etc/odbcinst.ini")
Sys.setenv("GITHUB_MSSQL" = "true")
```
## Start
```
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password12' -t -i -p 1433:1433 microsoft/mssql-server-linux
sqlcmd -U SA -P 'Password12' -Q 'CREATE DATABASE test;'
```
## Connect
```{r, eval = FALSE}
con <- DBI::dbConnect(odbc::odbc(),
driver = "ODBC Driver 17 for SQL Server",
database = "test",
uid = "SA",
pwd = "Password12",
server = "localhost",
port = 1433
)
```
|
