如何用SqlPackage.exe對(duì)SQL Azure數(shù)據(jù)庫做備份
SqlPackage.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)建自注冊(cè)數(shù)據(jù)庫注冊(cè)以來已對(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ù)庫:
E:\backup>SqlPackage.exe /a:import /tcs:"Data Source=192.168.0.1,9880;Initatalog=GylPlatform;User Id=sa;Password=123456" /sf:E:test.bacpac
Importing to database 'GylPlatform' on server '192.168.0.1,9880'.
Creating deployment plan
Initializing deployment
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
Importing data
Processing Import.
Disabling indexes.
Processing Table '[dbo].[_admin_area]'.
Processing Table '[dbo].[_admin_area_test]'.
Processing Table '[dbo].[_distribution_dealers_acct]'.
Processing Table '[dbo].[_enterprise]'.
Processing Table '[dbo].[_SCTest_dealer_stock]'.
Processing Table '[dbo].[_SCTest_dealers]'.
Processing Table '[dbo].[_SCTest_dealers_devanning_packing_box]'.
Processing Table '[dbo].[_SCTest_dealers_dismantle_pile_stack]'.
Processing Table '[dbo].[_SCTest_dealers_in_storage]'.
Processing Table '[dbo].[_SCTest_dealers_in_storage_detail]'.
Processing Table '[dbo].[_SCTest_dealers_in_storage_terminal_user]'.
Processing Table '[dbo].[_SCTest_dealers_out_storage]'.
Processing Table '[dbo].[_SCTest_dealers_out_storage_detail]'.
Processing Table '[dbo].[_SCTest_dealers_out_storage_terminal_user]'.
Processing Table '[dbo].[_SCTest_dealers_stock]'.
Processing Table '[dbo].[_SCTest_dealers_stock_details]'.
Processing Table '[dbo].[_SCTest_dealers_warehouse]'.
Processing Table '[dbo].[_SCTest_devanning_packing_box]'.
Processing Table '[dbo].[_SCTest_dismantle_pile_stack]'.
Processing Table '[dbo].[_SCTest_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_SCTest_distribution_acct_role]'.
Processing Table '[dbo].[_SCTest_distribution_dealers]'.
Processing Table '[dbo].[_SCTest_distribution_rebate]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_activity]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_audit]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_condition]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_detail]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_SCTest_distribution_rebate_strategy]'.
Processing Table '[dbo].[_SCTest_distribution_role]'.
Processing Table '[dbo].[_SCTest_distribution_role_fields]'.
Processing Table '[dbo].[_SCTest_distribution_role_res]'.
Processing Table '[dbo].[_SCTest_distribution_sys_res]'.
Processing Table '[dbo].[_SCTest_distribution_terminal_shop]'.
Processing Table '[dbo].[_SCTest_factory]'.
Processing Table '[dbo].[_SCTest_in_storage]'.
Processing Table '[dbo].[_SCTest_in_storage_detail]'.
Processing Table '[dbo].[_SCTest_in_storage_terminal_user]'.
Processing Table '[dbo].[_SCTest_ipc]'.
Processing Table '[dbo].[_SCTest_ipc_user_info]'.
Processing Table '[dbo].[_SCTest_machine_halt_reason]'.
Processing Table '[dbo].[_SCTest_out_storage]'.
Processing Table '[dbo].[_SCTest_out_storage_detail]'.
Processing Table '[dbo].[_SCTest_out_storage_terminal_user]'.
Processing Table '[dbo].[_SCTest_pack_standard]'.
Processing Table '[dbo].[_SCTest_product]'.
Processing Table '[dbo].[_SCTest_product_category]'.
Processing Table '[dbo].[_SCTest_product_line]'.
Processing Table '[dbo].[_SCTest_product_tag]'.
Processing Table '[dbo].[_SCTest_product_tag_mapping]'.
Processing Table '[dbo].[_SCTest_product_team]'.
Processing Table '[dbo].[_SCTest_production_data_uploads]'.
Processing Table '[dbo].[_SCTest_production_plan]'.
Processing Table '[dbo].[_SCTest_production_task]'.
Processing Table '[dbo].[_SCTest_production_task_status]'.
Processing Table '[dbo].[_SCTest_qr_code_publish_record]'.
Processing Table '[dbo].[_SCTest_sales_area]'.
Processing Table '[dbo].[_SCTest_sys_config]'.
Processing Table '[dbo].[_SCTest_terminal]'.
Processing Table '[dbo].[_SCTest_terminal_user_info]'.
Processing Table '[dbo].[_SCTest_users]'.
Processing Table '[dbo].[_SCTest_warehouse]'.
Processing Table '[dbo].[_SCTest_warehouse_stock]'.
Processing Table '[dbo].[_SCTest_warehouse_stock_check_plan]'.
Processing Table '[dbo].[_SCTest_warehouse_stock_check_task]'.
Processing Table '[dbo].[_SCTest_warehouse_stock_details]'.
Processing Table '[dbo].[_SCTest_workshop]'.
Processing Table '[dbo].[_test]'.
Processing Table '[dbo].[_test_devanning_packing_box]'.
Processing Table '[dbo].[_test_dismantle_pile_stack]'.
Processing Table '[dbo].[_test_in_storage]'.
Processing Table '[dbo].[_test_in_storage_detail]'.
Processing Table '[dbo].[_test_in_storage_terminal_user]'.
Processing Table '[dbo].[_test_out_storage]'.
Processing Table '[dbo].[_test_out_storage_detail]'.
Processing Table '[dbo].[_test_out_storage_terminal_user]'.
Processing Table '[dbo].[_test_stock]'.
Processing Table '[dbo].[_test_stock_details]'.
Processing Table '[dbo].[_test_warehouse]'.
Processing Table '[dbo].[_XJYTL_devanning_packing_box]'.
Processing Table '[dbo].[_XJYTL_dismantle_pile_stack]'.
Processing Table '[dbo].[_XJYTL_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_XJYTL_distribution_acct_role]'.
Processing Table '[dbo].[_XJYTL_distribution_dealers]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_activity]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_audit]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_condition]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_detail]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_XJYTL_distribution_rebate_strategy]'.
Processing Table '[dbo].[_XJYTL_distribution_role]'.
Processing Table '[dbo].[_XJYTL_distribution_role_fields]'.
Processing Table '[dbo].[_XJYTL_distribution_role_res]'.
Processing Table '[dbo].[_XJYTL_distribution_sys_res]'.
Processing Table '[dbo].[_XJYTL_distribution_terminal_shop]'.
Processing Table '[dbo].[_XJYTL_factory]'.
Processing Table '[dbo].[_XJYTL_in_storage]'.
Processing Table '[dbo].[_XJYTL_in_storage_detail]'.
Processing Table '[dbo].[_XJYTL_in_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_inspection_records]'.
Processing Table '[dbo].[_XJYTL_inspection_records_detail]'.
Processing Table '[dbo].[_XJYTL_ipc]'.
Processing Table '[dbo].[_XJYTL_ipc_user_info]'.
Processing Table '[dbo].[_XJYTL_machine_halt_reason]'.
Processing Table '[dbo].[_XJYTL_out_storage]'.
Processing Table '[dbo].[_XJYTL_out_storage_detail]'.
Processing Table '[dbo].[_XJYTL_out_storage_terminal_user]'.
Processing Table '[dbo].[_XJYTL_pack_standard]'.
Processing Table '[dbo].[_XJYTL_product]'.
Processing Table '[dbo].[_XJYTL_product_category]'.
Processing Table '[dbo].[_XJYTL_workshop]'.
Processing Table '[dbo].[_test_dealer_product]'.
Processing Table '[dbo].[_test_dealer_stock]'.
Processing Table '[dbo].[_test_dealers]'.
Processing Table '[dbo].[_test_dealers_devanning_packing_box]'.
Processing Table '[dbo].[_test_dealers_dismantle_pile_stack]'.
Processing Table '[dbo].[_test_dealers_in_storage]'.
Processing Table '[dbo].[_test_dealers_in_storage_detail]'.
Processing Table '[dbo].[_test_dealers_in_storage_terminal_user]'.
Processing Table '[dbo].[_test_dealers_out_storage]'.
Processing Table '[dbo].[_test_dealers_out_storage_detail]'.
Processing Table '[dbo].[_test_dealers_out_storage_terminal_user]'.
Processing Table '[dbo].[_test_dealers_stock]'.
Processing Table '[dbo].[_test_dealers_stock_details]'.
Processing Table '[dbo].[_test_dealers_warehouse]'.
Processing Table '[dbo].[_test_devanning_packing_box]'.
Processing Table '[dbo].[_test_dismantle_pile_stack]'.
Processing Table '[dbo].[_test_distribution_acct_reg_audit]'.
Processing Table '[dbo].[_test_distribution_acct_role]'.
Processing Table '[dbo].[_test_distribution_dealers]'.
Processing Table '[dbo].[_test_distribution_rebate]'.
Processing Table '[dbo].[_test_distribution_rebate_activity]'.
Processing Table '[dbo].[_test_distribution_rebate_activity_detail]'.
Processing Table '[dbo].[_test_distribution_rebate_audit]'.
Processing Table '[dbo].[_test_distribution_rebate_condition]'.
Processing Table '[dbo].[_test_distribution_rebate_detail]'.
Processing Table '[dbo].[_test_distribution_rebate_scan_code]'.
Processing Table '[dbo].[_test_distribution_rebate_strategy]'.
Processing Table '[dbo].[_test_distribution_role]'.
Processing Table '[dbo].[_test_distribution_role_fields]'.
Processing Table '[dbo].[_test_distribution_role_res]'.
Processing Table '[dbo].[_test_distribution_sys_res]'.
Processing Table '[dbo].[_test_distribution_terminal_shop]'.
Processing Table '[dbo].[_test_factory]'.
Processing Table '[dbo].[_test_in_storage]'.
Processing Table '[dbo].[_test_in_storage_detail]'.
Processing Table '[dbo].[_test_in_storage_terminal_user]'.
Processing Table '[dbo].[_test_ipc]'.
Processing Table '[dbo].[_test_ipc_user_info]'.
Processing Table '[dbo].[_test_machine_halt_reason]'.
Processing Table '[dbo].[_test_out_storage]'.
Processing Table '[dbo].[_test_out_storage_detail]'.
Processing Table '[dbo].[_test_out_storage_terminal_user]'.
Processing Table '[dbo].[_test_pack_standard]'.
Processing Table '[dbo].[_test_product]'.
Processing Table '[dbo].[_test_product_category]'.
Processing Table '[dbo].[_test_product_line]'.
Processing Table '[dbo].[_test_product_tag]'.
Processing Table '[dbo].[_test_product_tag_mapping]'.
Processing Table '[dbo].[_test_product_team]'.
Processing Table '[dbo].[_test_production_data_uploads]'.
Processing Table '[dbo].[_test_production_plan]'.
Processing Table '[dbo].[_test_production_task]'.
Processing Table '[dbo].[_test_production_task_status]'.
Processing Table '[dbo].[_test_qr_code_publish_record]'.
Processing Table '[dbo].[_test_sales_area]'.
Processing Table '[dbo].[_test_sys_config]'.
Processing Table '[dbo].[_test_terminal]'.
Processing Table '[dbo].[_test_terminal_user_info]'.
Processing Table '[dbo].[_test_users]'.
Processing Table '[dbo].[_test_warehouse]'.
Processing Table '[dbo].[_test_warehouse_stock]'.
Processing Table '[dbo].[_test_warehouse_stock_check_plan]'.
Processing Table '[dbo].[_test_warehouse_stock_check_task]'.
Processing Table '[dbo].[_test_warehouse_stock_details]'.
Processing Table '[dbo].[_test_workshop]'.
Processing Table '[dbo].[gyl_test_table]'.
Enabling indexes.
Successfully imported database.