{"id":8853,"date":"2026-01-19T21:28:42","date_gmt":"2026-01-19T12:28:42","guid":{"rendered":"https:\/\/hasu0707.duckdns.org\/blog\/?p=8853"},"modified":"2026-01-19T21:29:55","modified_gmt":"2026-01-19T12:29:55","slug":"fortify-ssc-database-migration-microsoft-sql","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=8853","title":{"rendered":"[Fortify] SSC Database Migration (Microsoft SQL)"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"false\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">######################################################################\n#\n# Microsoft SQL Fortify SSC DB \ubcf5\uc6d0\n# db_ssc_2020 -> db_ssc_2540 \uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc608\uc81c\n#\n######################################################################\n\n1. DB \ubc31\uc5c5\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"BACKUP DATABASE [db_ssc_2020] TO DISK = 'C:\\db_backup\\db_ssc_2020_full.bak' WITH INIT, FORMAT;\"\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"BACKUP LOG [db_ssc_2020] TO DISK = 'C:\\db_backup\\db_ssc_2020_log.trn' WITH INIT;\"\n\n2. \uc0c8\ub85c \uc124\uce58\ud560 \ubc84\uc804\uc758 \uc2e0\uaddc Database \uc0dd\uc131 (db_ssc_2540)\nCREATE DATABASE [db_ssc_2540]\n CONTAINMENT = NONE\n COLLATE Korean_Wansung_CS_AS\nGO\nALTER DATABASE [db_ssc_2540] SET COMPATIBILITY_LEVEL = 120\nGO\nALTER DATABASE [db_ssc_2540] SET ANSI_NULL_DEFAULT OFF\nGO\nALTER DATABASE [db_ssc_2540] SET ANSI_NULLS OFF\nGO\nALTER DATABASE [db_ssc_2540] SET ANSI_PADDING OFF\nGO\nALTER DATABASE [db_ssc_2540] SET ANSI_WARNINGS OFF\nGO\nALTER DATABASE [db_ssc_2540] SET ARITHABORT OFF\nGO\nALTER DATABASE [db_ssc_2540] SET AUTO_CLOSE OFF\nGO\nALTER DATABASE [db_ssc_2540] SET AUTO_SHRINK OFF\nGO\nALTER DATABASE [db_ssc_2540] SET AUTO_CREATE_STATISTICS ON\nGO\nALTER DATABASE [db_ssc_2540] SET AUTO_UPDATE_STATISTICS ON\nGO\nALTER DATABASE [db_ssc_2540] SET CURSOR_CLOSE_ON_COMMIT OFF\nGO\nALTER DATABASE [db_ssc_2540] SET CURSOR_DEFAULT  GLOBAL\nGO\nALTER DATABASE [db_ssc_2540] SET CONCAT_NULL_YIELDS_NULL OFF\nGO\nALTER DATABASE [db_ssc_2540] SET NUMERIC_ROUNDABORT OFF\nGO\nALTER DATABASE [db_ssc_2540] SET QUOTED_IDENTIFIER OFF\nGO\nALTER DATABASE [db_ssc_2540] SET RECURSIVE_TRIGGERS OFF\nGO\nALTER DATABASE [db_ssc_2540] SET DISABLE_BROKER\nGO\nALTER DATABASE [db_ssc_2540] SET AUTO_UPDATE_STATISTICS_ASYNC OFF\nGO\nALTER DATABASE [db_ssc_2540] SET DATE_CORRELATION_OPTIMIZATION OFF\nGO\nALTER DATABASE [db_ssc_2540] SET PARAMETERIZATION SIMPLE\nGO\nALTER DATABASE [db_ssc_2540] SET READ_COMMITTED_SNAPSHOT ON\nGO\nALTER DATABASE [db_ssc_2540] SET READ_WRITE\nGO\nALTER DATABASE [db_ssc_2540] SET RECOVERY FULL\nGO\nALTER DATABASE [db_ssc_2540] SET MULTI_USER\nGO\nALTER DATABASE [db_ssc_2540] SET PAGE_VERIFY CHECKSUM\nGO\nALTER DATABASE [db_ssc_2540] SET TARGET_RECOVERY_TIME = 0 SECONDS\nGO\nALTER DATABASE [db_ssc_2540] SET DELAYED_DURABILITY = DISABLED\nGO\nALTER DATABASE [db_ssc_2540] SET ALLOW_SNAPSHOT_ISOLATION ON\nGO\nUSE [db_ssc_2540]\nGO\nIF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [db_ssc_2540] MODIFY FILEGROUP [PRIMARY] DEFAULT\nGO\nSET ANSI_NULL_DFLT_ON ON\nGO\n\n3. DB\ub97c \uc624\ud504\ub77c\uc778 \uc0c1\ud0dc\ub85c \uc804\ud658\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"ALTER DATABASE [db_ssc_2020] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE [db_ssc_2020] SET OFFLINE;\"\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"ALTER DATABASE [db_ssc_2540] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE [db_ssc_2540] SET OFFLINE;\"\n\n4. mdf.ldf \ub514\ub809\ud1a0\ub9ac \ud655\uc778\n\uc608) C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\db_ssc_2540.mdf\n\uc608) C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\db_ssc_2540_log.ldf\n\n5. mdf, ldf \ub514\ub809\ud1a0\ub9ac \uc218\uc815 \ud6c4 db_ssc_2020\u2192db_ssc_2540\uc73c\ub85c DB \ubcf5\uc0ac\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"RESTORE DATABASE [db_ssc_2540] FROM DISK = 'C:\\db_backup\\db_ssc_2020_full.bak' WITH MOVE 'db_ssc_2020' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\db_ssc_2540.mdf', MOVE 'db_ssc_2020_log' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\db_ssc_2540_log.ldf', REPLACE, RECOVERY;\"\n\n6. DB\ub97c \uc628\ub77c\uc778 \uc0c1\ud0dc\ub85c \uc804\ud658\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"ALTER DATABASE [db_ssc_2020] SET ONLINE; ALTER DATABASE [db_ssc_2020] SET MULTI_USER;\"\nsqlcmd -S TCP:127.0.0.1 -U SA -P &lt;PASSWORD> -Q \"ALTER DATABASE [db_ssc_2540] SET ONLINE; ALTER DATABASE [db_ssc_2540] SET MULTI_USER;\"\n\n7. SSC \uc124\uce58 \uc911 DB \uc124\uc815 \ud398\uc774\uc9c0 JDBC \uc8fc\uc18c \uc785\ub825\njdbc:sqlserver:\/\/127.0.0.1:1433;database=db_ssc_2540;connectionCollation=korean_wansung_cs_as;sendStringParametersAsUnicode=false;encrypt=true;trustServerCertificate=true\n\n8. \ub9c8\uc774\uadf8\ub808\uc774\uc158 SQL \uc2a4\ud06c\ub9bd\ud2b8 \ub2e4\uc6b4\ub85c\ub4dc \ud6c4 \uc801\uc6a9\n\n9. Process Seed \uc124\uce58\uae4c\uc9c0 \uc9c4\ud589 \ud6c4 \uc644\ub8cc<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[66],"tags":[],"class_list":["post-8853","post","type-post","status-publish","format-standard","hentry","category-computing_fortify"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8853"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8853\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}