{"id":28815,"date":"2025-10-15T02:51:41","date_gmt":"2025-10-15T02:51:41","guid":{"rendered":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/?page_id=28815"},"modified":"2025-11-13T18:21:05","modified_gmt":"2025-11-13T09:21:05","slug":"cassandra-migration-to-ms-sql-server-for-windows","status":"publish","type":"page","link":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/server-guide\/cassandra-deprecation\/cassandra-migration-to-ms-sql-server-for-windows\/","title":{"rendered":"TestRail Server Cassandra \u304b\u3089MS SQL Server\u3078\u306e\u30c7\u30fc\u30bf\u79fb\u884c\uff08Windows\u7248)"},"content":{"rendered":"<p>TestRail Server 9.4 \u304b\u3089\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308b\u5834\u6240\u306f Cassandra \u304b\u3089 Microsoft SQL Server \u306b\u79fb\u884c\u3057\u307e\u3059\u30029.4 \u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3067\u306f\u3001\u65e2\u5b58\u306e\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092 Cassandra \u304b\u3089 MS SQL Server \u306b\u30b3\u30d4\u30fc\u3067\u304d\u308b\u79fb\u884c\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u5143\u306e Cassandra \u30c7\u30fc\u30bf\u306f\u305d\u306e\u307e\u307e\u6b8b\u308a\u307e\u3059\u3002<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>\u203b\u672c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u64cd\u4f5c\u306f TestRail 7.5 \u4ee5\u964d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089 TestRail 9.4 \u306b\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3057\u305f\u5834\u5408\u3060\u3051\u884c\u3044\u307e\u3059\u3002<\/strong><\/span><\/p>\n<p>\u79fb\u884c\u306f\u3044\u3064\u3067\u3082\u90fd\u5408\u306e\u3088\u3044\u3068\u304d\u306b\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6b21\u306e\u30ea\u30ea\u30fc\u30b9 (TestRail 9.5) \u304b\u3089\u306f\u3001\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u306e\u6761\u4ef6\u306b\u306a\u308a\u307e\u3059\u3002\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u3001\u79fb\u884c\u304c\u5b8c\u4e86\u3059\u308b\u307e\u3067\u3001TestRail 9.5 \u304a\u3088\u3073\u4ee5\u964d\u306e\u3059\u3079\u3066\u306e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<h2><span id=\"i\">\u6e96\u5099<\/span><\/h2>\n<h3>Composer \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p><a href=\"https:\/\/getcomposer.org\/\" target=\"_blank\" rel=\"noopener\">Composer<\/a><span>\u00a0<\/span>\u3092\u5229\u7528\u3057\u3066\u30c7\u30fc\u30bf\u79fb\u884c\u7528\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u306b\u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p>TestRail \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u74b0\u5883\u306b\u5408\u308f\u305b\u3066<span>\u00a0<\/span><a href=\"https:\/\/getcomposer.org\/doc\/00-intro.md#installation-windows\" target=\"_blank\" rel=\"noopener\">Composer \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/a>\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3 class=\"\">IIS \u30b5\u30fc\u30d0\u30fc\u3068\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u30bf\u30b9\u30af\u306e\u505c\u6b62<\/h3>\n<p>IIS \u30b5\u30fc\u30d0\u30fc\u304a\u3088\u3073<a href=\"\/server-guide\/installation\/activating-the-background-task\/\" target=\"_blank\" rel=\"noopener\">\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u30bf\u30b9\u30af<\/a>\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n<h3 class=\"ip-location-block-dropup ip-location-block-dropdown\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u53d6\u5f97<\/h3>\n<p><a href=\"\/server-guide\/server-administration\/creating-backup\/\" target=\"_blank\" rel=\"noopener\">TestRail \u306e\u30d5\u30a1\u30a4\u30eb\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u4f5c\u6210<\/a>\u3057\u307e\u3059\u3002<\/p>\n<p>\u203bv9.4.1 \u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u524d\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u5f97\u3057\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001v9.4.1\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u5f8c\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u518d\u53d6\u5f97\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2>\u30c7\u30fc\u30bf\u79fb\u884c<\/h2>\n<p>\u79fb\u884c\u306b\u9032\u3080\u5834\u5408\u3001\u624b\u9806\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<p><!-- START ordered list with colored numbers --><\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol class=\"list-colored\">\n<li>\u30b7\u30a7\u30eb (PowerShell\u306a\u3069) \u3092\u958b\u304d\u3001&lt;<span>TestRail\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea<\/span>&gt;\\deprecation_script \u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/li>\n<li>\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001Composer \u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3001\u6b63\u3057\u304f\u52d5\u4f5c\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">composer -V<\/pre>\n<p>Composer \u304c\u8d77\u52d5\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001 <a href=\"https:\/\/getcomposer.org\/doc\/00-intro.md#installation-windows\" target=\"_blank\" rel=\"noopener\">\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a> \u3092\u53c2\u7167\u3057\u3066\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u5fc5\u8981\u306a\u4f9d\u5b58\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">composer update<\/pre>\n<\/li>\n<li>MS SQL Server \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u78ba\u8a8d\u3057\u307e\u3059:\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">sqlcmd -S &lt;host&gt; -U username -P password<\/pre>\n<\/li>\n<li>Cassandra \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u78ba\u8a8d\u3057\u307e\u3059:\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">cqlsh &lt;host&gt; 9042 -u &lt;user&gt; -p &lt;password&gt;<\/pre>\n<\/li>\n<li>(\u30aa\u30d7\u30b7\u30e7\u30f3) \u30c9\u30e9\u30a4\u30e9\u30f3\u3092\u5b9f\u884c\u3057\u3066\u3001\u79fb\u884c\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u52d5\u4f5c\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\uff1a\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">php TestRailSqlToCassandraMigration.php -d2 -r -m\"driver=sqlsrv;host=&lt;host&gt;;port=&lt;port&gt;;database=&lt;database&gt;;user=&lt;user&gt;;password=&lt;password&gt;\" -s\"host=&lt;host&gt;;port=9042;keyspace=&lt;keyspace&gt;;user=&lt;user&gt;;password=&lt;password&gt;\" -v2 -b --attachments=\"&lt;attachments location&gt;\"<\/pre>\n<\/li>\n<li>config.ini \u30d5\u30a1\u30a4\u30eb\u306b\u5165\u529b\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u8a8d\u8a3c\u60c5\u5831\u3092\u5165\u529b\u3057\u307e\u3059 (\u30d1\u30b9\u30ef\u30fc\u30c9\u306b\u7279\u6b8a\u6587\u5b57\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u4e8c\u91cd\u5f15\u7528\u7b26\u3067\u56f2\u307f\u307e\u3059)\u3002\n<ul class=\"list-colored\">\n<li>config.ini \u30d5\u30a1\u30a4\u30eb\u306b `<strong>driver = sqlsrv<\/strong>` \u306e\u8a2d\u5b9a\u304c\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002(\u30c7\u30d5\u30a9\u30eb\u30c8\u3067 mysql \u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001sqlsrv \u306b\u5909\u66f4\u3057\u307e\u3059\u3002)<\/li>\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(SQLServer \u304a\u3088\u3073 cassandra) \u306e\u8a8d\u8a3c\u60c5\u5831\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u74b0\u5883\u306b\u5408\u308f\u305b\u3066\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n<\/li>\n<li>\u524d\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u3059\u3079\u3066\u6b63\u5e38\u306b\u5b8c\u4e86\u3057\u305f\u3089\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u5ec3\u6b62\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">php TestRailCassandraDeprecation.php<\/pre>\n<\/li>\n<li>\u30b3\u30de\u30f3\u30c9\u5b9f\u884c\u5f8c\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u51fa\u529b\u3055\u308c\u308b\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3066\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u3092\u9032\u3081\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Welcome! We are about to start the Cassandra deprecation process.\n\nPlease note that after deprecating Cassandra, our Team won't support downgrades to versions of TestRail with Cassandra.\nDo you still want to continue?\n\nPlease type YES or NO.\nyes\nPlease confirm the source and target databases:\nSOURCE:\n[Cassandra Information]\nHost: 127.0.0.1\nKeyspace: testrail\nUser: cassandra\nPort: 9042\n\nTARGET:\n[SQL Information]\nHost: 127.0.0.1\nDatabase Name: testrail\nUser: testrail\nPort: 49884\nDriver: sqlsrv\n\nDo you confirm? Please type YES or NO.\nyes\n\nThe migration process may take a long time. So that we can notify you once it is completed,\nWould you like to configure an SMTP server before proceeding?\nno\n\nAll ready to start Cassandra deprecation.\nThe first step will be to migrate to the target database.\nThis will be done in the background and may take a long time.\n\nDo you want to start? Please type YES or NO.\nyes<\/pre>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h2>Apache Cassandra \u306e\u505c\u6b62<\/h2>\n<p>Cassandra \u304b\u3089 Microsoft SQL Server \u3078\u306e\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u305f\u3089 Cassandra \u3092\u505c\u6b62\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u53e4\u3044\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/h2>\n<p>TestRailCassandraDeprecation.php\u00a0\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u5f8c\u3001\u53e4\u3044\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u8a73\u7d30\u306f\u00a0<a href=\"\/server-guide\/cassandra-deprecation\/cleaning-up-old-attachment-files\/\" target=\"_blank\" rel=\"noopener\">\u53e4\u3044\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/a>\u00a0\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><!-- END ordered list with colored numbers --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>TestRail Server 9.4 \u304b\u3089\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308b\u5834\u6240\u306f Cassandra \u304b\u3089 Microsoft SQL Server \u306b\u79fb\u884c\u3057\u307e\u3059\u30029.4 \u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3067\u306f\u3001\u65e2\u5b58\u306e\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092 Cassan [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":30914,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-28815","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/comments?post=28815"}],"version-history":[{"count":45,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28815\/revisions"}],"predecessor-version":[{"id":31736,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28815\/revisions\/31736"}],"up":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/30914"}],"wp:attachment":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/media?parent=28815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}