In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
SqlPackage.exe is a command line utility that automates the following database development tasks:
Extract: create a database snapshot (.dacpac) file from the active SQL Server or Windows Azure SQL Database.
Export: export the active database (including database schema and user data) from SQL Server or Windows Azure SQL Database to the BACPAC package (.bacpac file).
Import: import schema and table data from the BACPAC package into the new user database in the instance of SQL Server or Windows Azure SQL Database.
Publish: incrementally update the database schema to match the schema of the source .dacpac file. If the database does not exist on the server, the publish operation creates the database. Otherwise, the existing database will be updated.
DeployReport: create a XML report of changes that will be completed by the publish operation.
DriftReport: create a XML report of changes that have been made to the registration database since it was registered.
Script: create an Transact-SQL incremental update script that updates the target's schema to match the source's schema.
Through the SqlPackage.exe command line, you can specify these operations as well as parameters and properties specific to the operation.
The command line format is as follows:
Sqlpackage.exe / Action:export / tsn:
< server_name >/ tdn:
< database_name >/ tu:
< user_name >/ tp:
< password >/ tf:
< target_file > < server_name >Target server name
< database_name >Target database name
< user_name >User name in the target server
< password >User's password
< target_file >The file name and location of the BACPAC file to be exported
Export sql database examples:
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.bacpacpacing.
E:\ backup >
Import database command:
Sqlpackage.exe / Action:Import / tsn:
< server_name >/ tdn:
< database_name >/ tu:
< user_name >/ tp:
< password >/ sf:
< source_file >Parameter description
< server_name >Target server name
< database_name >Target database name
< user_name >User name in the target server
< password >User's password
< source_file >The file name and location of the BACPAC file to be imported
Import to database example
Import to the local SQLServer database:
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.
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.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.