{"id":2667,"date":"2020-12-25T15:58:29","date_gmt":"2020-12-25T07:58:29","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=2667"},"modified":"2026-07-11T23:15:11","modified_gmt":"2026-07-12T07:15:11","slug":"discover-sql-server-data-lineage-in-3-minutes","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/3%eb%b6%84-%ec%95%88%ec%97%90-sql-server-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4%eb%a5%bc-%eb%b0%9c%ea%b2%ac%ed%95%98%ec%84%b8%ec%9a%94\/","title":{"rendered":"3\ubd84 \uc548\uc5d0 SQL Server \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc54c\uc544\ubcf4\uc138\uc694"},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-7\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<p>\uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 Grabit \ub3c4\uad6c\uc640 SQLFlow\ub97c \ud568\uaed8 \uc0ac\uc6a9\ud558\uc5ec 3\ubd84 \uc548\uc5d0 SQL Server \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uac80\uc0c9\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p>SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ucea1\ucc98\ud558\ub294 \ub2e8\uacc4:<\/p>\n<ol>\n<li>SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870 \ub0b4\ubcf4\ub0b4\uae30; \ud3ec\ud568\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc2a4\ud0a4\ub9c8\ub97c \uc9c0\uc815\ud558\uac70\ub098 \uc81c\uc678\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc2a4\ud0a4\ub9c8\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ub0b4\ubcf4\ub0b8 \ub370\uc774\ud130\ub97c \ub2e4\uc74c\uc73c\ub85c \ubcf4\ub0c5\ub2c8\ub2e4.\u00a0<a href=\"https:\/\/sqlflow.gudusoft.com\/\" target=\"_blank\" rel=\"nofollow noreferrer noopener\">https:\/\/sqlflow.gudusoft.com<\/a>\u00a0\uc790\ub3d9 \ub370\uc774\ud130 \uacc4\ud1b5 \ubd84\uc11d\uc744 \uc704\ud574<\/li>\n<li>\ub370\uc774\ud130 \uacc4\ud1b5 \uacb0\uacfc\ub97c \ud655\uc778\ud558\uc138\uc694\u00a0<a href=\"https:\/\/sqlflow.gudusoft.com\/\" target=\"_blank\" rel=\"nofollow noreferrer noopener\">https:\/\/sqlflow.gudusoft.com<\/a>\u00a0\uadc0\ud558\uc758 \uacc4\uc815\uc73c\ub85c.<\/li>\n<li>\ub370\uc774\ud130 \uacc4\ud1b5 \uacb0\uacfc\ub97c CSV, JSON, Graphml\ub85c \ub0b4\ubcf4\ub0b4\uae30<\/li>\n<\/ol>\n<p>\uadf8\ub798\ube57\uc5d0\uc11c \uc81c\ucd9c\ub41c SQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubd84\uc11d\ud55c \ud6c4, SQLFlow\ub294 \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc2dc\uac01\ud654\ud558\uace0 \uae54\ub054\ud558\uace0 \uc2e4\ud589 \uac00\ub2a5\ud55c \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\uba74 SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub2e4\uc591\ud55c \ubcc0\uacbd \ubc0f \ud649\uc744 \ud1b5\ud574 \uc18c\uc2a4\uc5d0\uc11c \ub300\uc0c1\uc73c\ub85c \ub370\uc774\ud130 \ud750\ub984\/\uc774\ub3d9\uc744 \uc27d\uac8c \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"fusion-responsive-typography-calculated\" data-fontsize=\"28\" data-lineheight=\"36.4px\">SQLFlow\ub97c \uc0ac\uc6a9\ud558\ub294 \ub370 \uac00\uc7a5 \uc801\ud569\ud55c \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\ub824\uba74 \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/h3>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-4\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"wp-block-heading\">GUI \ubaa8\ub4dc<\/h3>\n\n\n\n<p>GUI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uacc4\ud1b5\uc744 \uac80\uc0c9\ud558\uc138\uc694<\/p>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 class=\"wp-block-heading\">\uba85\ub839\uc904 \ubaa8\ub4dc<\/h3>\n\n\n\n<p>\uba85\ub839\uc904\uc744 \uc0ac\uc6a9\ud55c \uc790\ub3d9\ud654\ub41c \ub370\uc774\ud130 \uacc4\ubcf4<\/p>\n\n\n\n<\/div>\n\n\n<\/div>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 style=\"text-align: center;\">SQL Server \ub370\uc774\ud130 \uacc4\ubcf4 \ube44\ub514\uc624<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-video\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/00Lgzy7ktpc\" frameborder=\"0\" allowfullscreen><\/iframe><\/div><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3>SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub97c \uc6d0\uaca9 SQLFlow \uc11c\ubc84\ub85c \uc804\uc1a1\ud558\uace0 \uc2f6\uc9c0 \uc54a\uc73c\uc2e0\uac00\uc694?<\/h3>\n<p>\ubb38\uc81c\uc5c6\uc5b4\uc694! \uc124\uc815\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4 <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">SQLFlow \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804<\/a> \uadc0\ud558\uc758 \uc870\uc9c1 \ub0b4\ubd80\uc5d0\uc11c \ubaa8\ub4e0 \uae30\ub2a5\uc744 \uc5bb\uc73c\uc2ed\uc2dc\uc624. <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-%ed%81%b4%eb%9d%bc%ec%9a%b0%eb%93%9c\/\">SQLFlow \ud074\ub77c\uc6b0\ub4dc \ubc84\uc804<\/a> \uc778\ud130\ub137\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uac00 \uc804\uc1a1\ub418\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uac80\uc0c9\ud574\uc57c \ud569\ub2c8\uae4c?<\/h3>\n<p>\ubb38\uc81c \uc5c6\uc2b5\ub2c8\ub2e4! SQLFlow\ub294 \ub2e4\uc74c\uc744 \ud3ec\ud568\ud55c \uc8fc\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4: bigquery, couchbase, dax, db2, greenplum, hana, hive, impala, informix, mdx, mysql, netezza, opensedge, oracle, postgresql, redshift, snowflake, sqlserver, sybase, teradata, vertica<\/p>\n<h3>\ubc84\uc804 \uc81c\uc5b4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \ud30c\uc545\ud574\uc57c \ud569\ub2c8\uae4c?<\/h3>\n<p>\ubb38\uc81c\uc5c6\uc2b5\ub2c8\ub2e4! Grabit\uc740 Github, Bitbucket\uacfc \uac19\uc740 \ubc84\uc804 \uc81c\uc5b4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ubaa8\ub4e0 SQL \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uac00\uc838\uc640 \ub370\uc774\ud130 \uacc4\ubcf4 \ubd84\uc11d\uc744 \uc704\ud574 SQLFlow\ub85c \ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 \ubaa8\ub4e0 \uac83\uc774 \uc790\ub3d9\uc73c\ub85c \uc218\ud589\ub418\ubbc0\ub85c Github, Bitbucket\uc758 \uc790\uaca9 \uc99d\uba85\ub9cc \uc785\ub825\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<\/div>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-13\">\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h2 style=\"text-align: center;\"><span style=\"font-size: 50px; color: #aa1829;\" data-fusion-font=\"true\">\ud504\ub9ac\ubbf8\uc5c4\uc73c\ub85c \uc804\ud658\ud558\uace0 \uc9c0\uae08 \ubc14\ub85c SQLFlow\ub97c \uc0ac\uc6a9\ud558\uc138\uc694<\/span><\/h2>\n<h3 style=\"text-align: center;\"><span style=\"font-size: 35px; color: #aa1829;\" data-fusion-font=\"true\">\ubaa8\ub4e0 \ud2b9\ubcc4\ud55c \uae30\ub2a5\uc744 \uc7a0\uae08 \ud574\uc81c\ud558\uc138\uc694<\/span><\/h3>\n\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:20%\">\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:60%\">\n\n<ul>\n<li>\ud504\ub9ac\ubbf8\uc5c4 \uacc4\uc815\uc740 3\ubd84 \uc774\ub0b4\uc5d0 \ud65c\uc131\ud654\ub429\ub2c8\ub2e4.<\/li>\n\n\n<li><p style=\"text-align: left;\">SQLFlow \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc5d0 \ub300\ud55c \ubb34\uc81c\ud55c \uc561\uc138\uc2a4<\/p><\/li>\n\n\n<li>\uc644\uc804\ud788 \ud3b8\uc548\ud55c API \uc561\uc138\uc2a4<\/li>\n\n\n<li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4 \uc790\ub3d9\ud654<\/li>\n\n\n<li>Github\/Bitbucket Repo\uc5d0\uc11c \ub370\uc774\ud130 \uacc4\ubcf4 \uc790\ub3d9\ud654<\/li>\n\n<\/ul>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:40%\">\n\n<a href=\"#\" class=\"myButton\" style=\"vertical-align:middle\" data-fsc-item-path-value='sqlflow-premium-account-monthly-subscription' data-fsc-action=\"Add, Checkout\">\uc9c0\uae08 \uad6c\ub9e4\ud558\uc138\uc694, \ud55c \ub2ec\uc5d0 $49.99\ub2ec\ub7ec<\/a>\n\n\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n\n<h3 style=\"text-align: center;\"><span style=\"font-size: 35px; color: #aa1829;\" data-fusion-font=\"true\">7\uc77c \uc774\ub0b4 \ud658\ubd88 \ubcf4\uc7a5, \uc9c8\ubb38 \uc5c6\uc74c!<\/span><\/h3>\n\n\n\n<\/div>\n\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This article illustrates how to discover SQL Server data lineage in 3 minutes by using the Grabit tool together with the SQLFlow. Steps to capture data lineage in the SQL Server database: Export SQL Server database structure;\u00a0 You can specify included database, schema or exclude database, schema Send the exported data to\u00a0https:\/\/sqlflow.gudusoft.com\u00a0for automatically data lineage analysis Check the data lineage result on\u00a0https:\/\/sqlflow.gudusoft.com\u00a0under your account. Export the data lineage result to CSV, JSON, Graphml After analyzing the SQL script submitted by the grabit, the SQLFlow will visualize the data lineage and provides a nice, clean, and actionable diagram. With this diagram\u2026<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[38,31,45],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/2667"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=2667"}],"version-history":[{"count":17,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/2667\/revisions"}],"predecessor-version":[{"id":6634,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/2667\/revisions\/6634"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=2667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=2667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=2667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}