⬅ Back insert common.txt
USE tcomm
INSERT INTO COUNTRY_MASTER SELECT * FROM common.DBO.COUNTRY_MASTER
INSERT INTO STATE_MASTER SELECT * FROM common.DBO.STATE_MASTER
INSERT INTO CATALOG_MASTER SELECT * FROM common.DBO.CATALOG_MASTER
INSERT INTO CITY_MASTER SELECT * FROM common.DBO.CITY_MASTER
INSERT INTO BANK_MASTER SELECT * FROM common.DBO.BANK_MASTER
INSERT INTO SERIES_MASTER SELECT * FROM common.DBO.SERIES_MASTER
INSERT INTO MARKET_MASTER SELECT * FROM common.DBO.MARKET_MASTER
INSERT INTO THEME_SETTING SELECT * FROM common.DBO.THEME_SETTING
INSERT INTO VOUCHER_TYPE_MASTER SELECT * FROM common.DBO.VOUCHER_TYPE_MASTER
INSERT INTO GENERAL_ITEM_MASTER SELECT * FROM common.DBO.GENERAL_ITEM_MASTER
INSERT INTO GREY_ITEM_MASTER SELECT * FROM common.DBO.GREY_ITEM_MASTER
INSERT INTO ITEM_CATEGORIES_MASTER SELECT * FROM common.DBO.ITEM_CATEGORIES_MASTER
INSERT INTO ITEM_QUALITY_MASTER SELECT * FROM common.DBO.ITEM_QUALITY_MASTER
INSERT INTO FINISHED_ITEM_MASTER SELECT * FROM common.DBO.FINISHED_ITEM_MASTER
INSERT INTO SCREEN_ITEM_MASTER SELECT * FROM common.DBO.SCREEN_ITEM_MASTER
INSERT INTO SUB_SCREEN_ITEM_MASTER SELECT * FROM common.DBO.SUB_SCREEN_ITEM_MASTER
INSERT INTO RANGE_DESCRIPTION_MASTER SELECT * FROM common.DBO.RANGE_DESCRIPTION_MASTER
INSERT INTO COMPANY_YEAR SELECT * FROM common.DBO.COMPANY_YEAR
INSERT INTO ACCOUNT_TYPES SELECT * FROM common.DBO.ACCOUNT_TYPES
INSERT INTO COMPANY_DETAIL SELECT * FROM common.DBO.COMPANY_DETAIL
INSERT INTO AGENT_MASTER SELECT * FROM common.DBO.AGENT_MASTER
INSERT INTO GROUP_MASTER SELECT * FROM common.DBO.GROUP_MASTER
INSERT INTO ACCOUNT_MASTER SELECT * FROM common.DBO.ACCOUNT_MASTER
INSERT INTO LOGIN_DETAIL SELECT * FROM common.DBO.LOGIN_DETAIL
INSERT INTO TRANSPORT_MASTER SELECT * FROM common.DBO.TRANSPORT_MASTER
INSERT INTO TDS_TYPE_MASTER SELECT * FROM common.DBO.TDS_TYPE_MASTER
INSERT INTO USER_PERMISSION SELECT * FROM common.DBO.USER_PERMISSION
INSERT INTO LABEL_DETAIL SELECT * FROM common.DBO.LABEL_DETAIL
INSERT INTO HOLYDAYS_LIST SELECT * FROM common.DBO.HOLYDAYS_LIST
INSERT INTO HASTE_MASTER SELECT * FROM common.DBO.HASTE_MASTER
INSERT INTO REMARK_MASTER SELECT * FROM common.DBO.REMARK_MASTER
INSERT INTO REMARK_DETAIL SELECT * FROM common.DBO.REMARK_DETAIL
INSERT INTO REPORT_SETTING SELECT * FROM common.DBO.REPORT_SETTING
INSERT INTO UPDATE_DETAIL SELECT * FROM common.DBO.UPDATE_DETAIL
INSERT INTO PRINTING_MASTER SELECT * FROM common.DBO.PRINTING_MASTER
INSERT INTO JOB_CHALLAN_MASTER SELECT * FROM common.DBO.JOB_CHALLAN_MASTER
INSERT INTO USER_WORK_DETAIL SELECT * FROM common.DBO.USER_WORK_DETAIL
INSERT INTO ITEM_ON_MASTER SELECT * FROM common.DBO.ITEM_ON_MASTER
INSERT INTO LICENCE_DETAIL SELECT * FROM common.DBO.LICENCE_DETAIL