# SQL Servers:

## Server One

### Create container

```bash
docker run \
    --hostname server_one \
    --name server_one \
    -e 'ACCEPT_EULA=Y' \
    -e 'SA_PASSWORD=123321...#!' \
    -p 1401:1433 \
    -d mcr.microsoft.com/mssql/server:2017-latest
sqlcmd -S 127.0.0.1,1401 -U SA -P '123321...#!'
```

### Create database

```sql
CREATE DATABASE database_one;
GO;
USE database_one;
GO;
```

### Create table

```sql
CREATE TABLE persons (id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, first_name VARCHAR(128), last_name VARCHAR(128));
GO;
```

### Manage Link

#### Create Link

```sql
EXEC sp_addlinkedserver @server=N'server_two', @srvproduct=N'', @provider=N'SQLNCLI', @provstr=N'Library=DMBSSOCN;ServerName=127.0.0.1,1402';
GO
```

#### Add server login

```sql
EXEC sp_addlinkedsrvlogin @rmtsrvname=N'server_two', @useself=N'FALSE', @locallogin=NULL, @rmtuser=N'sa', @rmtpassword=N'123321...#!';
GO;
```

#### Test Link

```sql
EXEC sp_testlinkedserver server_two;
GO;
```

#### Drop Link

```sql
EXEC sp_dropserver 'server_two', 'droplogins';
GO;
```

## Server Two

### Create container

```bash
docker run \
    --hostname server_two \
    --name server_two \
    -e 'ACCEPT_EULA=Y' \
    -e 'SA_PASSWORD=123321...#!' \
    -p 1402:1433 \
    -d mcr.microsoft.com/mssql/server:2017-latest
sqlcmd -S 127.0.0.1,1402 -U SA -P '123321...#!'
```

### Create database

```sql
CREATE DATABASE database_two;
GO;
USE database_two;
GO;
```

### Create table

```sql
CREATE TABLE persons (id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, source_id INT, source VARCHAR(128), first_name VARCHAR(128), last_name VARCHAR(128));
GO;
```