delete from wms.dbo.printer
delete from wms.dbo.worker WHERE id NOT IN (1, 2)
delete from wms.dbo.worker_document
delete from wms.dbo.document_setting
delete from wms.dbo.stock
delete from wms.dbo.picking_head_delivery
delete from wms.dbo.picking_position_detail
delete from wms.dbo.picking_position
delete from wms.dbo.picking_head
delete from wms.dbo.location_setting
delete from wms.dbo.location

INSERT INTO wms.dbo.setting_type SELECT * FROM setting_type WHERE ID NOT IN (SELECT id FROM wms.dbo.setting_type)

SET IDENTITY_INSERT wms.dbo.printer ON;
INSERT INTO wms.dbo.printer (id, is_default, name) SELECT id, is_default, name FROM printer;
SET IDENTITY_INSERT wms.dbo.printer OFF;

SET IDENTITY_INSERT wms.dbo.worker ON;
INSERT INTO wms.dbo.worker (id, pin, full_name, erp_id, id_worker_group, domain_name, id_printer, is_disabled, id_scale) SELECT id, pin, full_name, erp_id, id_worker_group, domain_name, id_printer, is_disabled, id_scale FROM worker WHERE id NOT IN (1, 2)
SET IDENTITY_INSERT wms.dbo.worker OFF;

SET IDENTITY_INSERT wms.dbo.print_template ON;
INSERT INTO wms.dbo.print_template (id, name, report_layout, is_default, insert_worker_id, insert_date_time, change_worker_id, change_date_time, print_template_type_id) SELECT id, name, report_layout, is_default, insert_worker_id, insert_date_time, change_worker_id, change_date_time, print_template_type_id FROM print_template
SET IDENTITY_INSERT wms.dbo.print_template OFF;

INSERT INTO wms.dbo.document_erp_setting (id, erp_document_type, id_document_type, title, wms_mask, last_used_wms_num, last_used_erp_num, id_status, idt) SELECT id, erp_document_type, id_document_type, title, wms_mask, 0, last_used_erp_num, id_status, idt FROM document_erp_setting;

SET IDENTITY_INSERT wms.dbo.worker_document ON;
INSERT INTO wms.dbo.worker_document (id, id_worker, id_document_erp_setting) SELECT id, id_worker, id_document_erp_setting FROM worker_document;
SET IDENTITY_INSERT wms.dbo.worker_document OFF;

SET IDENTITY_INSERT wms.dbo.document_setting ON;
INSERT INTO wms.dbo.document_setting (id, id_document_erp_setting, id_setting_type, int_value, string_value, decimal_value) SELECT id, id_document_erp_setting, id_setting_type, int_value, string_value, decimal_value FROM document_setting;
SET IDENTITY_INSERT wms.dbo.document_setting OFF;

INSERT INTO wms.dbo.picking_erp_setting_link (id_document_erp_setting, id_picking_erp_setting, output_id_document_erp_setting) SELECT id_document_erp_setting, id_picking_erp_setting, output_id_document_erp_setting FROM picking_erp_setting_link;

SET IDENTITY_INSERT wms.dbo.refund ON;
INSERT INTO wms.dbo.refund (id, id_document_erp_setting, id_document_erp_setting_document, id_document_erp_setting_order, is_selected) SELECT id, id_document_erp_setting, id_document_erp_setting_document, id_document_erp_setting_order, is_selected FROM refund;
SET IDENTITY_INSERT wms.dbo.refund OFF;

SET IDENTITY_INSERT wms.dbo.location_group ON;
INSERT INTO wms.dbo.location_group (id, name) SELECT id, name FROM location_group;
SET IDENTITY_INSERT wms.dbo.location_group OFF;

SET IDENTITY_INSERT wms.dbo.location ON;
INSERT INTO wms.dbo.location (id, hierarchy, weight, code, name, barcode, alternate_code, id_location_type, id_status, id_location_root, idt, blockade, id_location_group) SELECT id, hierarchy, weight, code, name, barcode, alternate_code, id_location_type, id_status, id_location_root, idt, blockade, id_location_group FROM location;
SET IDENTITY_INSERT wms.dbo.location OFF;

INSERT INTO wms.dbo.location_setting (id_location, sync_with_erp) SELECT id_location, sync_with_erp FROM location_setting;

UPDATE wms.dbo.unit_of_measure SET allow_decimal = 1 -- če vrne 0, je potrebno še enkrat pognati, ko se prvič uvozijo šifranti merskih enot.

UPDATE
WMS_Dev_Saop.dbo.gs1_parser_ai_setting
SET
WMS_Dev_Saop.dbo.gs1_parser_ai_setting.active = gs1_parser_ai_setting.active
FROM
gs1_parser_ai_setting
INNER JOIN WMS_Dev_Saop.dbo.gs1_parser_ai_setting AS WMS_gs1_parser_ai_setting
ON gs1_parser_ai_setting.ai = WMS_gs1_parser_ai_setting.ai

UPDATE
WMS_Dev_Saop.dbo.barcode_parser_setting
SET
WMS_Dev_Saop.dbo.barcode_parser_setting.enabled = barcode_parser_setting.enabled
FROM
barcode_parser_setting
INNER JOIN WMS_Dev_Saop.dbo.barcode_parser_setting AS WMS_barcode_parser_setting
ON barcode_parser_setting.id = WMS_barcode_parser_setting.id



-- DODATNO: prekopirati je potrebno tudi nastavitve tovornih listov

Ko je uvožen šifrant, lahko tudi te nastavitve kopiraš.

SET IDENTITY_INSERT wms.dbo.picking_import_setting ON;
INSERT INTO wms.dbo.picking_import_setting (id, name, id_document_erp_setting, id_location, id_customer, id_customer_department, import_file_type, start_with_row, delimiter, decimalDelimiter, fixed_field_mask, ignore_text, date_format, bind_column_list_json, idt,
xml_table, encoding, erp_document_number_in_format, erp_document_number_out_format, save_file_name_in_custom_field_1, save_file_name_in_custom_field_2) SELECT id, name, id_document_erp_setting, id_location, id_customer, id_customer_department, import_file_type, start_with_row, delimiter, decimalDelimiter, fixed_field_mask, ignore_text, date_format, bind_column_list_json, idt,
xml_table, encoding, erp_document_number_in_format, erp_document_number_out_format, save_file_name_in_custom_field_1, save_file_name_in_custom_field_2 FROM picking_import_setting;
SET IDENTITY_INSERT wms.dbo.picking_import_setting OFF;