{"action":"closed","issue":{"url":"https://api.github.com/repos/jms-web/FMS/issues/112","repository_url":"https://api.github.com/repos/jms-web/FMS","labels_url":"https://api.github.com/repos/jms-web/FMS/issues/112/labels{/name}","comments_url":"https://api.github.com/repos/jms-web/FMS/issues/112/comments","events_url":"https://api.github.com/repos/jms-web/FMS/issues/112/events","html_url":"https://github.com/jms-web/FMS/issues/112","id":385578961,"node_id":"MDU6SXNzdWUzODU1Nzg5NjE=","number":112,"title":"サーバ移転","user":{"login":"jms-funato","id":20087685,"node_id":"MDQ6VXNlcjIwMDg3Njg1","avatar_url":"https://avatars1.githubusercontent.com/u/20087685?v=4","gravatar_id":"","url":"https://api.github.com/users/jms-funato","html_url":"https://github.com/jms-funato","followers_url":"https://api.github.com/users/jms-funato/followers","following_url":"https://api.github.com/users/jms-funato/following{/other_user}","gists_url":"https://api.github.com/users/jms-funato/gists{/gist_id}","starred_url":"https://api.github.com/users/jms-funato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jms-funato/subscriptions","organizations_url":"https://api.github.com/users/jms-funato/orgs","repos_url":"https://api.github.com/users/jms-funato/repos","events_url":"https://api.github.com/users/jms-funato/events{/privacy}","received_events_url":"https://api.github.com/users/jms-funato/received_events","type":"User","site_admin":false},"labels":[{"id":849734805,"node_id":"MDU6TGFiZWw4NDk3MzQ4MDU=","url":"https://api.github.com/repos/jms-web/FMS/labels/%E7%92%B0%E5%A2%83%E6%95%B4%E5%82%99%20-%20maintenance","name":"環境整備 - maintenance","color":"006B75","default":false}],"state":"closed","locked":false,"assignee":{"login":"jms-funato","id":20087685,"node_id":"MDQ6VXNlcjIwMDg3Njg1","avatar_url":"https://avatars1.githubusercontent.com/u/20087685?v=4","gravatar_id":"","url":"https://api.github.com/users/jms-funato","html_url":"https://github.com/jms-funato","followers_url":"https://api.github.com/users/jms-funato/followers","following_url":"https://api.github.com/users/jms-funato/following{/other_user}","gists_url":"https://api.github.com/users/jms-funato/gists{/gist_id}","starred_url":"https://api.github.com/users/jms-funato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jms-funato/subscriptions","organizations_url":"https://api.github.com/users/jms-funato/orgs","repos_url":"https://api.github.com/users/jms-funato/repos","events_url":"https://api.github.com/users/jms-funato/events{/privacy}","received_events_url":"https://api.github.com/users/jms-funato/received_events","type":"User","site_admin":false},"assignees":[{"login":"jms-funato","id":20087685,"node_id":"MDQ6VXNlcjIwMDg3Njg1","avatar_url":"https://avatars1.githubusercontent.com/u/20087685?v=4","gravatar_id":"","url":"https://api.github.com/users/jms-funato","html_url":"https://github.com/jms-funato","followers_url":"https://api.github.com/users/jms-funato/followers","following_url":"https://api.github.com/users/jms-funato/following{/other_user}","gists_url":"https://api.github.com/users/jms-funato/gists{/gist_id}","starred_url":"https://api.github.com/users/jms-funato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jms-funato/subscriptions","organizations_url":"https://api.github.com/users/jms-funato/orgs","repos_url":"https://api.github.com/users/jms-funato/repos","events_url":"https://api.github.com/users/jms-funato/events{/privacy}","received_events_url":"https://api.github.com/users/jms-funato/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-11-29T05:43:36Z","updated_at":"2018-12-06T01:42:53Z","closed_at":"2018-12-06T01:42:53Z","author_association":"CONTRIBUTOR","body":"- SV116→SV04へ\r\n\r\n### 事前準備\r\n- [x] SV04 IIS整備\r\n- [x] 共有ファイル保存パス(\\\\sv04\\data\\FMS\\不適合管理)とIIS配信パスを共有フォルダとして登録\r\n- [x] SV04 DBdmp仮インポート：FILESTREAMを適用のためSV04 SQLServerサービスの再起動が必要\r\n- [x] SV04 タスクスケジューラ移転：滞留通知裏処理、DBバックアップスクリプト\r\n※無効状態にしておく\r\n- [x] 裏処理移転\r\n\r\n### 当日\r\n- 最新のDBdmpをSV04にインポート\r\n\t- [x] SV116の`C:\\SQLServerBackup\\BAT\\SQLBACKUP.BAT`を実行\r\n\t- [x] SV04の`C:\\SQLServerBackup\\BAT\\FMS_RESTORE.sql`を実行\r\n- [x] 共有ファイル保存パスのファイルをSV04の共有ファイル保存パスに移動\r\n`E:\\system\\不適合管理` → `\\\\sv04\\data\\FMS\\不適合管理`\r\n- [x] コードマスタの共有ファイル保存パスを`\\\\sv04\\data\\FMS\\不適合管理`に変更\r\n- [x] 移転作業中に登録されないようにSV116のDBを停止 Windowsサービスを無効\r\n- [x] 滞留通知裏処理 メール本文中の配信アドレスをSV04に変更\r\n- [x] SV04のClickonceを更新：INIファイル接続先をSV04に変更すること\r\n- [x] SV116のClickonceを更新\r\n配信処理にて、最後のメニューEXE起動の変わりに、アンインストールの通知と新規サーバのシステムインストールアドレスのショートカットをデスクトップに作成\r\nINIファイルはSV116を見るようにしておく\r\n- [x] 承認依頼 メール本文中の配信アドレスをSV04に変更\r\n- [x] SV04のタスクスケジューラを有効に切り替え　SV116側を無効\r\n- [x] 以下のコマンドの既存のバックアップバッチファイルに追記\r\n```\r\nsqlcmd -S SV04 -U sa -P fujiwara -Q \"BACKUP DATABASE [FMS] TO DISK=N'C:\\共有フォルダ\\data_bak\\SQLServerBackup\\SV04\\FMS.dmp' WITH INIT\"\r\n```\r\n\r\n作業時間：30分弱"}}
{"actor":{"display_login":"jms-funato"}}