{"id":661,"date":"2024-01-15T10:03:23","date_gmt":"2024-01-15T10:03:23","guid":{"rendered":"https:\/\/virtualall.sk\/?p=661"},"modified":"2026-09-11T14:45:34","modified_gmt":"2026-09-11T14:45:34","slug":"azure-sql-server-export-databaz-do-bacpack-suboru","status":"publish","type":"post","link":"https:\/\/virtualall.sk\/en\/2024\/01\/azure-sql-server-export-databaz-do-bacpack-suboru\/","title":{"rendered":"Azure SQL Server Export BACPAC"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">sqlpackage je n\u00e1stroj poskytovan\u00fd spolo\u010dnos\u0165ou Microsoft, ktor\u00fd umo\u017e\u0148uje balenie a nasadzovanie datab\u00e1z SQL Server. Pomocou tohto n\u00e1stroja m\u00f4\u017eete vykon\u00e1va\u0165 z\u00e1lohovanie a obnovenie SQL Server datab\u00e1z. Tu je nieko\u013eko mo\u017enost\u00ed pre z\u00e1lohovanie datab\u00e1zy pomocou sqlpackage:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Z\u00e1lohovanie celej datab\u00e1zy<strong>:<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlpackage \/a:Extract \/ssn:&lt;server_name> \/sdn:&lt;database_name> \/tf:&lt;backup_file.bacpac><\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\/a:Extract<\/code> &#8211; \u0161pecifikuje akciu extrakcie, \u010do v tomto pr\u00edpade znamen\u00e1 z\u00e1lohovanie.<\/li>\n\n\n\n<li><code>\/ssn<\/code> &#8211; \u0161pecifikuje n\u00e1zov SQL Server in\u0161tancie.<\/li>\n\n\n\n<li><code>\/sdn<\/code> &#8211; \u0161pecifikuje n\u00e1zov datab\u00e1zy, ktor\u00fa chcete z\u00e1lohova\u0165.<\/li>\n\n\n\n<li><code>\/tf<\/code> &#8211; \u0161pecifikuje cie\u013eov\u00fd s\u00fabor pre ulo\u017eenie z\u00e1lohy.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Z\u00e1lohovanie ur\u010ditej sch\u00e9my alebo tabu\u013eky:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlpackage \/a:Extract \/ssn:&lt;server_name> \/sdn:&lt;database_name> \/tf:&lt;backup_file.bacpac> \/sf:&lt;source_schema><\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\/sf<\/code> &#8211; \u0161pecifikuje sch\u00e9mu alebo tabu\u013eku, ktor\u00fa chcete z\u00e1lohova\u0165.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Z\u00e1lohovanie pomocou skriptu T-SQL:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlpackage \/a:Script \/ssn:&lt;server_name> \/sdn:&lt;database_name> \/sf:&lt;source_schema> \/tf:&lt;backup_script.sql><\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\/a:Script<\/code> &#8211; specifikuje akci generov\u00e1n\u00ed skriptu.<\/li>\n\n\n\n<li><code>\/tf<\/code> &#8211; specifikuje c\u00edlov\u00fd soubor pro ulo\u017een\u00ed skriptu.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Dal\u0161ie mo\u017enosti:<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>\/su<\/code> &#8211; \u0161pecifikuje u\u017e\u00edvate\u013esk\u00e9 meno pre pripojenie k SQL Server.<\/li>\n\n\n\n<li><code>\/sp<\/code> &#8211; \u0161pecifikuje heslo pre pripojenie k SQL Server.<\/li>\n\n\n\n<li><code>\/tdn<\/code> &#8211; \u0161pecifikuje do\u010dasn\u00fd n\u00e1zov datab\u00e1zy.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Pri obnovovan\u00ed datab\u00e1zy m\u00f4\u017eete pou\u017ei\u0165 opa\u010dn\u00fa akciu Deploy. Je d\u00f4le\u017eit\u00e9 zabezpe\u010di\u0165, \u017ee m\u00e1te zodpovedaj\u00face opr\u00e1vnenie na vykon\u00e1vanie z\u00e1loh a obnovovanie datab\u00e1z na SQL Serveri.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pre export (z\u00e1lohu) SQL Server datab\u00e1zy pomocou sqlpackage, m\u00f4\u017eete pou\u017ei\u0165 akciu ExportData alebo Export. Ni\u017e\u0161ie s\u00fa pr\u00edklady pou\u017eitia oboch pr\u00edstupov:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Export pomocou akcie <code>ExportData<\/code>:<\/strong> Tato akcia sl\u00fa\u017ei na z\u00e1lohovanie d\u00e1t z datab\u00e1zy.<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlpackage \/a:ExportData \/ssn:&lt;server_name> \/sdn:&lt;database_name> \/tf:&lt;backup_file.bacpac><\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\/a:ExportData<\/code> &#8211; \u0161pecifikuje akciu exportu d\u00e1t.<\/li>\n\n\n\n<li><code>\/ssn<\/code> &#8211; \u0161pecifikuje n\u00e1zov SQL Server in\u0161tancie.<\/li>\n\n\n\n<li><code>\/sdn<\/code> &#8211; \u0161pecifikuje n\u00e1zov datab\u00e1zy, ktor\u00fa chcete exportova\u0165.<\/li>\n\n\n\n<li><code>\/tf<\/code> &#8211; \u0161pecifikuje cie\u013eov\u00fd s\u00fabor pre ulo\u017eenie exportovan\u00fdch d\u00e1t.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Export pomocou akcie Export:<\/strong> T\u00e1to akcia umo\u017e\u0148uje export celej datab\u00e1zy.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlpackage \/a:Export \/ssn:&lt;server_name> \/sdn:&lt;database_name> \/tf:&lt;backup_file.bacpac><\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\/a:Export<\/code> &#8211; \u0161pecifikuje akciu exportu celej datab\u00e1zy.<\/li>\n\n\n\n<li><code>\/ssn<\/code> &#8211; \u0161pecifikuje n\u00e1zov SQL Server in\u0161tancie.<\/li>\n\n\n\n<li><code>\/sdn<\/code> &#8211; \u0161pecifikuje n\u00e1zov datab\u00e1zy, ktor\u00fa chcete exportova\u0165.<\/li>\n\n\n\n<li><code>\/tf<\/code> &#8211; \u0161pecifikuje cie\u013eov\u00fd s\u00fabor na ulo\u017eenie exportovanej datab\u00e1zy.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Oba pr\u00edkazy vytvoria s\u00fabor s pr\u00edponou .bacpac, \u010do je form\u00e1t pre balenie a nasadzovanie aplik\u00e1ci\u00ed na platforme Azure. Tento s\u00fabor m\u00f4\u017eete n\u00e1sledne pou\u017ei\u0165 na obnovu alebo migr\u00e1ciu datab\u00e1zy. Uistite sa, \u017ee m\u00e1te dostato\u010dn\u00e9 opr\u00e1vnenia na vykon\u00e1vanie exportu d\u00e1t z datab\u00e1zy na SQL Serveri.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pr\u00edklad z\u00e1lohovania:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n# Nastavenie premenn\u00fdch\nserver=\"dev.database.windows.net\"database=\"Dev\"\nusername=\"backupuser\"\npassword=\"123\"\n# Set the output file path\noutput_file=\"\/root\/file.bacpac\"\n# Use sqlpackage to export data\nsqlpackage \/a:Export \/ssn:$server \/sdn:$database \/su:$username \/sp:$password \/tf:$output_file\necho \"Export to $output_file completed.\"<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">S\u00favisiace n\u00e1vody<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><a href=\"https:\/\/virtualall.sk\/2024\/06\/azure-sql-server-a-ako-ho-zabezpecit\/\">Azure SQL Server zabezpe\u010denie<\/a><\/li>\n\n\n<li><a href=\"https:\/\/virtualall.sk\/2025\/10\/overenie-pristupu-k-azure-sql\/\">Overenie pr\u00edstupu k Azure SQL &#8211; Kompletn\u00fd n\u00e1vod<\/a><\/li>\n\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Sqlpackage efekt\u00edvne z\u00e1lohuje SQL datab\u00e1zy a poskytuje met\u00f3dy, ako Export alebo ExportData, \u010do umo\u017e\u0148uje balenie a jednoduch\u00fa obnovu. Jeho automatiz\u00e1cia, flexibilita a optimaliz\u00e1cia pre SQL Server z neho rob\u00ed v\u00fdhodn\u00fd n\u00e1stroj na z\u00e1lohovanie.<\/p>\n","protected":false},"author":1,"featured_media":665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86],"tags":[144,87,146,145,147],"class_list":["post-661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","tag-ayure-sql","tag-azure","tag-azure-db","tag-azure-mssql","tag-azure-sqlpackage"],"_links":{"self":[{"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/posts\/661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/comments?post=661"}],"version-history":[{"count":8,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/posts\/661\/revisions"}],"predecessor-version":[{"id":2449,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/posts\/661\/revisions\/2449"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/media\/665"}],"wp:attachment":[{"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/media?parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/categories?post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/virtualall.sk\/en\/wp-json\/wp\/v2\/tags?post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}