Migrace - upgrade serveru

IP: https://10.199.1.143
PROXMOX: https://10.199.1.143:8006
IPMI: https://10.199.1.142

• Základní instalace, nastavení apt(update, upgrade)
• Vypnutí informace o předplatném
• Instalace sw pro Debian

https://pixelchrome.org/notes/docs/zfs/freebsd_dr_with_zfssnap_and_zxfer/

zxfer -deFPv -O bckralupy -R backup/props/tmpsrv/vspool02/VM vspool

zxfer -deFPv -O bckralupy -R backup/props/tmpsrv/db01pool/DB db01pool

• odebrat licenci Money
• přejmenovat server např. na Server1X
• změnit IP adresu na:

Produkční server:
hostname: server1

Xen: 192.168.15.125
Win 2008 r2: 192.168.15.124
IPMI: https://192.168.15.85

TMP server:
Proxmox: https://192.168.14.9:8006
Win 2019: 192.168.14.10
IPMI: http://192.168.14.8

https://old.money.cz/wp-content/uploads/instalujeme-money-s4.pdf

https://podpora.moneyerp.cz/
username: pavel.smetana@props-sro.cz

C:\Program Files (x86)\Solitea\Licence manager Money\CSWLicenceManagerWindowsService.exe"

TCP porty pro jednotlivé instance SQL:

CADET
port: 49180

MONEY
port: 1433

MEZPOHONY
port: 49221

Veřejná IP: 89.239.25.64

sql server 2019 evaluation to standard

https://www.google.com/search?q=sql+server+2019+evaluation+to+standard&sxsrf=ALiCzsYmK_HecKbmGgD57L-2qgLXvcvmiQ%3A1651660063701&ei=H1VyYuqqKojxsAf92IDAAQ&oq=sql+server+2019+evalution+version&gs_lcp=Cgdnd3Mtd2l6EAEYATIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQR0oECEEYAEoECEYYAFAAWABg2xZoAHACeACAAQCIAQCSAQCYAQDIAQjAAQE&sclient=gws-wiz

IPMI: http://10.199.1.123/index.html
PROXMOX: https://10.199.1.124:8006/

Upgrade se týká jak HW tak SW.
Nahrazení HDD za SSD, upgrade OS na W2019 a upgrade SQL serveru na 2019

ifconfig 

vmbr0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.199.1.124  netmask 255.255.255.0  broadcast 10.199.1.255
        inet6 fe80::8cc7:50ff:fec5:2364  prefixlen 64  scopeid 0x20<link>
        ether 00:1e:67:a6:e2:7e  txqueuelen 1000  (Ethernet)
        RX packets 18333432  bytes 48090705070 (44.7 GiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 15479824  bytes 1037154015 (989.1 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

root@prx01:/# zfs list -t all
NAME                                                USED  AVAIL     REFER  MOUNTPOINT
db01pool                                            258G   564G       24K  /db01pool
db01pool/DB                                         258G   564G       24K  /db01pool/DB
db01pool/DB/vm-100-disk-0                           258G   781G     41.2G  -
vspool01                                           81.9M   193G       28K  /vspool01
vspool01/DB                                          24K   193G       24K  /vspool01/DB
vspool01/VM                                          24K   193G       24K  /vspool01/VM
vspool02                                           62.4G   130G       25K  /vspool02
vspool02/VM                                        62.4G   130G       24K  /vspool02/VM
vspool02/VM/subvol-103-disk-0                      1.04G  6.96G     1.04G  /vspool02/VM/subvol-103-disk-0
vspool02/VM/vm-100-disk-0                          61.4G   182G     9.81G  -
### Cista instalace W2019 bez update - aktivovane
vspool02/VM/vm-100-disk-0@2022-05-04_12.36.55--1w   376K      -     9.81G  -
### Cista instalace W2019 vcetne update
vspool02/VM/vm-100-disk-0@2022-05-04_13.51.29--1w     0B      -     18.5G  -
### Dva disky pro DB
vspool02/VM/vm-100-disk-0@2022-05-05_11.09.14--1w  1.63M      -     18.5G  -
### Instalace SQL server instance MONEY, PROXIV a MP + management studio
vspool02/VM/vm-100-disk-0@2022-05-08_21.05.39--1w