SqlP

創(chuàng)新互聯(lián)建站是一家集網(wǎng)站建設(shè),土默特左旗企業(yè)網(wǎng)站建設(shè),土默特左旗品牌網(wǎng)站建設(shè),網(wǎng)站定制,土默特左旗網(wǎng)站建設(shè)報(bào)價(jià),網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,土默特左旗網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強(qiáng)企業(yè)競爭力。可充分滿足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時(shí)我們時(shí)刻保持專業(yè)、時(shí)尚、前沿，時(shí)刻以成就客戶成長自我，堅(jiān)持不斷學(xué)習(xí)、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實(shí)用型網(wǎng)站。ackage.exe 是一個(gè)命令行實(shí)用工具，可自動(dòng)完成以下數(shù)據(jù)庫開發(fā)任務(wù)：
    提取：從活動(dòng)的 SQL Server 或 Windows Azure SQL Database 創(chuàng)建數(shù)據(jù)庫快照 (.dacpac) 文件。
    導(dǎo)出：將活動(dòng)數(shù)據(jù)庫（包括數(shù)據(jù)庫架構(gòu)和用戶數(shù)據(jù)）從 SQL Server 或 Windows Azure SQL Database 導(dǎo)出到 BACPAC 包（.bacpac 文件）。
    導(dǎo)入：將架構(gòu)和表數(shù)據(jù)從 BACPAC 包導(dǎo)入到 SQL Server 或 Windows Azure SQL Database 的實(shí)例中的新用戶數(shù)據(jù)庫中。
    發(fā)布：以增量方式更新數(shù)據(jù)庫架構(gòu)以匹配源 .dacpac 文件的架構(gòu)。如果數(shù)據(jù)庫不存在于服務(wù)器上，則發(fā)布操作將創(chuàng)建該數(shù)據(jù)庫。否則，將更新現(xiàn)有數(shù)據(jù)庫。
    DeployReport：創(chuàng)建將由發(fā)布操作完成的更改的 XML 報(bào)表。
    DriftReport：創(chuàng)建自注冊數(shù)據(jù)庫注冊以來已對(duì)其做出的更改的 XML 報(bào)表。
    腳本：創(chuàng)建 Transact-SQL 增量更新腳本，該腳本可更新目標(biāo)的架構(gòu)以匹配源的架構(gòu)。
通過 SqlPackage.exe 命令行，您可以指定這些操作以及特定于操作的參數(shù)和屬性。
命令行格式如下:
sqlpackage.exe /Action:export /tsn:< server_name > /tdn:< database_name > /tu:< user_name > /tp:< password > /tf:< target_file >
< server_name > 目標(biāo)服務(wù)器名稱
< database_name > 目標(biāo)數(shù)據(jù)庫名稱
< user_name > 目標(biāo)服務(wù)器中的用戶名
< password > 用戶的密碼
< target_file > 要導(dǎo)出的 BACPAC 文件的文件名和位置
 導(dǎo)出sql database例子:
E:\backup>"c:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /a:export /ssn:test.itpub.cn /sdn:chenfeng /su:sctest/sp:"st&xus7e6a2AC5u=atHa" /tf:e:\backup\sc-test\20171009.bacpac
Connecting to database 'chenfeng' on server 'test.itpub.cn'.
Extracting schema
Extracting schema from database
Resolving references in schema model
Validating schema model
Validating schema model for data package
Validating schema
Exporting data from database
Exporting data
Processing Export.
Processing Table '[dbo].[_XJYTL_dealers_in_storage]'.
Processing Table '[dbo].[_test01_users]'.
Processing Table '[dbo].[_TEST2017001_distribution_role]'.
Processing Table '[dbo].[_XJYTL_dealers_in_storage_detail]'.
Processing Table '[dbo].[_test01_warehouse]'.
Processing Table '[dbo].[_TEST2017001_distribution_role_fields]'.
Processing Table '[dbo].[_XJYTL_dealers_in_storage_terminal_user]'.
Processing Table '[dbo].[_test01_warehouse_stock]'.
Processing Table '[dbo].[_TEST2017001_distribution_role_res]'.
Processing Table '[dbo].[_XJYTL_dealers_out_storage]'.
Processing Table '[dbo].[_test01_warehouse_stock_check_plan]'.
Processing Table '[dbo].[_TEST2017001_distribution_sys_res]'.
Processing Table '[dbo].[_XJYTL_dealers_out_storage_detail]'.
Processing Table '[dbo].[_test01_warehouse_stock_check_task]'.
Processing Table '[dbo].[_TEST2017001_distribution_terminal_shop]'.
Processing Table '[dbo].[_XJYTL_dealers_out_storage_terminal_user]'.
Processing Table '[dbo].[_test01_warehouse_stock_details]'.
Processing Table '[dbo].[_XJYTL_dealers_stock]'.
Processing Table '[dbo].[_TEST2017001_factory]'.
Processing Table '[dbo].[_test01_workshop]'.
Processing Table '[dbo].[_XJYTL_dealers_warehouse]'.
Processing Table '[dbo].[_TEST2017001_in_storage]'.
Processing Table '[dbo].[gyl_test_table]'.
Processing Table '[dbo].[_XJYTL_devanning_packing_box]'.
Processing Table '[dbo].[_TEST2017001_in_storage_detail]'.
Processing Table '[dbo].[_XJYTL_dismantle_pile_stack]'.
Processing Table '[dbo].[_TEST2017001_in_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_TEST2017001_ipc]'.
Processing Table '[dbo].[_XJYTL_distribution_acct_role]'.
Processing Table '[dbo].[_TEST2017001_ipc_user_info]'.
Processing Table '[dbo].[_XJYTL_distribution_dealers]'.
Processing Table '[dbo].[_TEST2017001_machine_halt_reason]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate]'.
Processing Table '[dbo].[_TEST2017001_out_storage]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_activity]'.
Processing Table '[dbo].[_TEST2017001_out_storage_detail]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_TEST2017001_out_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_audit]'.
Processing Table '[dbo].[_TEST2017001_pack_standard]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_condition]'.
Processing Table '[dbo].[_TEST2017001_product]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_detail]'.
Processing Table '[dbo].[_TEST2017001_product_category]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_TEST2017001_product_line]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_strategy]'.
Processing Table '[dbo].[_TEST2017001_product_tag]'.
Processing Table '[dbo].[_XJYTL_distribution_role]'.
Processing Table '[dbo].[_TEST2017001_product_tag_mapping]'.
Processing Table '[dbo].[_test01_qr_code_publish_record]'.
Processing Table '[dbo].[_XJYTL_distribution_role_fields]'.
Processing Table '[dbo].[_TEST2017001_product_team]'.
Processing Table '[dbo].[_XJYTL_distribution_role_res]'.
Processing Table '[dbo].[_TEST2017001_production_data_uploads]'.
Processing Table '[dbo].[_XJYTL_distribution_sys_res]'.
Processing Table '[dbo].[_TEST2017001_production_plan]'.
Processing Table '[dbo].[_XJYTL_distribution_terminal_shop]'.
Processing Table '[dbo].[_TEST2017001_production_task]'.
Processing Table '[dbo].[_TEST2017001_production_task_status]'.
Processing Table '[dbo].[_XJYTL_factory]'.
Processing Table '[dbo].[_TEST2017001_qr_code_publish_record]'.
Processing Table '[dbo].[_admin_area]'.
Processing Table '[dbo].[_XJYTL_in_storage]'.
Processing Table '[dbo].[_TEST2017001_sales_area]'.
Processing Table '[dbo].[_admin_area_test]'.
Processing Table '[dbo].[_XJYTL_in_storage_detail]'.
Processing Table '[dbo].[_TEST2017001_sys_config]'.
Processing Table '[dbo].[_test01_dealer_product]'.
Processing Table '[dbo].[_XJYTL_in_storage_terminal_user]'.
Processing Table '[dbo].[_TEST2017001_terminal]'.
Processing Table '[dbo].[_test01_distribution_terminal_shop]'.
Processing Table '[dbo].[_test01_dealer_stock]'.
Processing Table '[dbo].[_XJYTL_ipc]'.
Processing Table '[dbo].[_TEST2017001_terminal_user_info]'.
Processing Table '[dbo].[_test01_dealers]'.
Processing Table '[dbo].[_XJYTL_ipc_user_info]'.
Processing Table '[dbo].[_TEST2017001_users]'.
Processing Table '[dbo].[_test01_dealers_in_storage]'.
Processing Table '[dbo].[_test01_devanning_packing_box]'.
Processing Table '[dbo].[_XJYTL_machine_halt_reason]'.
Processing Table '[dbo].[_TEST2017001_warehouse]'.
Processing Table '[dbo].[_test01_dealers_in_storage_detail]'.
Processing Table '[dbo].[_test01_dismantle_pile_stack]'.
Processing Table '[dbo].[_XJYTL_out_storage]'.
Processing Table '[dbo].[_TEST2017001_warehouse_stock]'.
Processing Table '[dbo].[_test01_dealers_warehouse]'.
Processing Table '[dbo].[_test01_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_XJYTL_out_storage_detail]'.
Processing Table '[dbo].[_TEST2017001_warehouse_stock_check_plan]'.
Processing Table '[dbo].[_test01_distribution_rebate]'.
Processing Table '[dbo].[_test01_distribution_acct_role]'.
Processing Table '[dbo].[_XJYTL_out_storage_terminal_user]'.
Processing Table '[dbo].[_TEST2017001_warehouse_stock_check_task]'.
Processing Table '[dbo].[_test01_distribution_rebate_activity]'.
Processing Table '[dbo].[_test01_distribution_dealers]'.
Processing Table '[dbo].[_XJYTL_pack_standard]'.
Processing Table '[dbo].[_TEST2017001_warehouse_stock_details]'.
Processing Table '[dbo].[_test01_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_distribution_dealers_acct]'.
Processing Table '[dbo].[_XJYTL_product]'.
Processing Table '[dbo].[_TEST2017001_workshop]'.
Processing Table '[dbo].[_test01_distribution_rebate_audit]'.
Processing Table '[dbo].[_test01_distribution_role]'.
Processing Table '[dbo].[_XJYTL_product_category]'.
Processing Table '[dbo].[_test01_dealers_devanning_packing_box]'.
Processing Table '[dbo].[_test01_distribution_rebate_condition]'.
Processing Table '[dbo].[_test01_distribution_role_fields]'.
Processing Table '[dbo].[_XJYTL_product_line]'.
Processing Table '[dbo].[_test01_dealers_dismantle_pile_stack]'.
Processing Table '[dbo].[_test01_distribution_rebate_detail]'.
Processing Table '[dbo].[_test01_distribution_role_res]'.
Processing Table '[dbo].[_XJYTL_product_tag]'.
Processing Table '[dbo].[_test01_dealers_in_storage_terminal_user]'.
Processing Table '[dbo].[_test01_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_test01_distribution_sys_res]'.
Processing Table '[dbo].[_XJYTL_product_tag_mapping]'.
Processing Table '[dbo].[_test01_distribution_rebate_strategy]'.
Processing Table '[dbo].[_enterprise]'.
Processing Table '[dbo].[_XJYTL_product_team]'.
Processing Table '[dbo].[_test01_dealers_out_storage_detail]'.
Processing Table '[dbo].[_TEST2017001_dealer_stock]'.
Processing Table '[dbo].[_test01_factory]'.
Processing Table '[dbo].[_XJYTL_production_data_uploads]'.
Processing Table '[dbo].[_test01_dealers_out_storage_terminal_user]'.
Processing Table '[dbo].[_TEST2017001_dealers]'.
Processing Table '[dbo].[_test01_in_storage]'.
Processing Table '[dbo].[_XJYTL_production_plan]'.
Processing Table '[dbo].[_test01_dealers_stock]'.
Processing Table '[dbo].[_TEST2017001_dealers_devanning_packing_box]'.
Processing Table '[dbo].[_test01_in_storage_detail]'.
Processing Table '[dbo].[_XJYTL_production_task]'.
Processing Table '[dbo].[_test01_ipc_user_info]'.
Processing Table '[dbo].[_TEST2017001_dealers_dismantle_pile_stack]'.
Processing Table '[dbo].[_test01_in_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_production_task_status]'.
Processing Table '[dbo].[_TEST2017001_dealers_in_storage]'.
Processing Table '[dbo].[_test01_ipc]'.
Processing Table '[dbo].[_XJYTL_qr_code_publish_record]'.
Processing Table '[dbo].[_TEST2017001_dealers_out_storage]'.
Processing Table '[dbo].[_TEST2017001_dealers_in_storage_detail]'.
Processing Table '[dbo].[_XJYTL_sales_area]'.
Processing Table '[dbo].[_TEST2017001_dealers_in_storage_terminal_user]'.
Processing Table '[dbo].[_test01_machine_halt_reason]'.
Processing Table '[dbo].[_XJYTL_sys_config]'.
Processing Table '[dbo].[_test01_dealers_out_storage]'.
Processing Table '[dbo].[_test01_out_storage]'.
Processing Table '[dbo].[_XJYTL_terminal]'.
Processing Table '[dbo].[_test01_dealers_stock_details]'.
Processing Table '[dbo].[_TEST2017001_dealers_out_storage_detail]'.
Processing Table '[dbo].[_test01_out_storage_detail]'.
Processing Table '[dbo].[_XJYTL_terminal_user_info]'.
Processing Table '[dbo].[_TEST2017001_dealers_stock_details]'.
Processing Table '[dbo].[_TEST2017001_dealers_out_storage_terminal_user]'.
Processing Table '[dbo].[_test01_out_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_users]'.
Processing Table '[dbo].[_TEST2017001_dealers_stock]'.
Processing Table '[dbo].[_test01_pack_standard]'.
Processing Table '[dbo].[_XJYTL_warehouse]'.
Processing Table '[dbo].[_TEST2017001_dealers_warehouse]'.
Processing Table '[dbo].[_test01_product]'.
Processing Table '[dbo].[_XJYTL_warehouse_stock]'.
Processing Table '[dbo].[_TEST2017001_devanning_packing_box]'.
Processing Table '[dbo].[_test01_product_category]'.
Processing Table '[dbo].[_XJYTL_warehouse_stock_check_plan]'.
Processing Table '[dbo].[_TEST2017001_dismantle_pile_stack]'.
Processing Table '[dbo].[_test01_product_line]'.
Processing Table '[dbo].[_XJYTL_warehouse_stock_check_task]'.
Processing Table '[dbo].[_TEST2017001_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_test01_product_tag]'.
Processing Table '[dbo].[_XJYTL_warehouse_stock_details]'.
Processing Table '[dbo].[_TEST2017001_distribution_acct_role]'.
Processing Table '[dbo].[_test01_product_tag_mapping]'.
Processing Table '[dbo].[_XJYTL_workshop]'.
Processing Table '[dbo].[_TEST2017001_distribution_dealers]'.
Processing Table '[dbo].[_test01_product_team]'.
Processing Table '[dbo].[_XJYTL_inspection_records]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate]'.
Processing Table '[dbo].[_test01_production_data_uploads]'.
Processing Table '[dbo].[_XJYTL_inspection_records_detail]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_activity]'.
Processing Table '[dbo].[_test01_production_plan]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_test01_production_task]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_audit]'.
Processing Table '[dbo].[_test01_production_task_status]'.
Processing Table '[dbo].[_XJYTL_dealers_stock_details]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_condition]'.
Processing Table '[dbo].[_test01_sales_area]'.
Processing Table '[dbo].[_XJYTL_dealers]'.
Processing Table '[dbo].[_test01_sys_config]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_detail]'.
Processing Table '[dbo].[_XJYTL_dealers_devanning_packing_box]'.
Processing Table '[dbo].[_test01_terminal]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_XJYTL_dealers_dismantle_pile_stack]'.
Processing Table '[dbo].[_test01_terminal_user_info]'.
Processing Table '[dbo].[_TEST2017001_distribution_rebate_strategy]'.
Successfully exported database and saved it to file 'e:\backup\sc-test\20171009.bacpac'.
E:\backup>
導(dǎo)入數(shù)據(jù)庫命令:
sqlpackage.exe /Action:Import /tsn:< server_name > /tdn:< database_name > /tu:< user_name > /tp:< password > /sf:< source_file >
參數(shù) 說明
< server_name > 目標(biāo)服務(wù)器名稱
< database_name > 目標(biāo)數(shù)據(jù)庫名稱
< user_name > 目標(biāo)服務(wù)器中的用戶名
< password > 用戶的密碼
< source_file > 要導(dǎo)入的 BACPAC 文件的文件名和位置
 導(dǎo)入到數(shù)據(jù)庫例子
導(dǎo)入到本地SQLServer數(shù)據(jù)庫:

網(wǎng)頁題目：如何用SqlPackage.exe對(duì)SQLAzure數(shù)據(jù)庫做備份-創(chuàng)新互聯(lián)
文章起源：http://m.newbst.com/article26/cepicg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供商城網(wǎng)站、外貿(mào)網(wǎng)站建設(shè)、定制開發(fā)、自適應(yīng)網(wǎng)站、全網(wǎng)營銷推廣、網(wǎng)頁設(shè)計(jì)公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)