250 lines
7.5 KiB
Transact-SQL
250 lines
7.5 KiB
Transact-SQL
--菜单、角色、权限
|
||
insert into SGGLDB_NEW.dbo.Sys_Menu select * from SGGLDB.dbo.Sys_Menu
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.ButtonToMenu select * from SGGLDB.dbo.ButtonToMenu
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.Sys_Role select * from SGGLDB.dbo.Sys_Role
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Sys_ButtonPower select * from SGGLDB.dbo.Sys_ButtonPower
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.Sys_ButtonPower select * from SGGLDB.dbo.Sys_ButtonPower
|
||
GO
|
||
|
||
--法律法规及标准规范
|
||
insert into SGGLDB_NEW.dbo.Common_LawRegulation select * from SGGLDB.dbo.Common_LawRegulation
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Common_ConstructionStandardList select * from SGGLDB.dbo.Common_ConstructionStandardList
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.Common_ConstructionStandardList select * from SGGLDB.dbo.Common_ConstructionStandardList
|
||
GO
|
||
|
||
--部门、岗位、职位、职称
|
||
|
||
insert into SGGLDB_NEW.dbo.Base_Depart select * from SGGLDB.dbo.Base_Depart
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Base_Post select * from SGGLDB.dbo.Base_Post
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Base_Position select * from SGGLDB.dbo.Base_Position
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Base_Title select * from SGGLDB.dbo.Base_Title
|
||
GO
|
||
|
||
|
||
--单位、用户
|
||
|
||
insert into SGGLDB_NEW.dbo.Base_ProjectType select * from SGGLDB.dbo.Base_ProjectType
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Base_Unit select * from SGGLDB.dbo.Base_Unit
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Sys_User select * from SGGLDB.dbo.Sys_User
|
||
GO
|
||
|
||
--HSSE危险源
|
||
insert into SGGLDB_NEW.dbo.HSSE_Hazard_HazardGrade select * from SGGLDB.dbo.HSSE_Hazard_HazardGrade
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HSSE_Hazard_HazardSortSet select * from SGGLDB.dbo.HSSE_Hazard_HazardSortSet
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HSSE_Hazard_HazardTemplate select * from SGGLDB.dbo.HSSE_Hazard_HazardTemplate
|
||
GO
|
||
-- 培训教材
|
||
insert into SGGLDB_NEW.dbo.HSSE_Train_EduTrainType select * from SGGLDB.dbo.HSSE_Train_EduTrainType
|
||
GO
|
||
|
||
-- 作业许可证
|
||
insert into SGGLDB_NEW.dbo.HSSE_License_LicenseType select * from SGGLDB.dbo.HSSE_License_LicenseType
|
||
GO
|
||
|
||
--HSSE专项检查
|
||
insert into SGGLDB_NEW.dbo.HSSE_Check_CheckItemSet select * from SGGLDB.dbo.HSSE_Check_CheckItemSet
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HSSE_Check_CheckItemDetail select * from SGGLDB.dbo.HSSE_Check_CheckItemDetail
|
||
GO
|
||
|
||
--违章
|
||
insert into SGGLDB_NEW.dbo.HSSE_ViolationRule select * from SGGLDB.dbo.HSSE_ViolationRule
|
||
GO
|
||
|
||
--违章种类
|
||
insert into SGGLDB_NEW.dbo.HSSE_ViolationSort select * from SGGLDB.dbo.HSSE_ViolationSort
|
||
GO
|
||
|
||
--应急类别
|
||
insert into SGGLDB_NEW.dbo.HSSE_Emergency_EmergencyType select * from SGGLDB.dbo.HSSE_Emergency_EmergencyType
|
||
GO
|
||
|
||
--方案类型
|
||
insert into SGGLDB_NEW.dbo.HSSE_Solution_SolutionSet select * from SGGLDB.dbo.HSSE_Solution_SolutionSet
|
||
GO
|
||
|
||
--天气
|
||
insert into SGGLDB_NEW.dbo.HSSE_Weather select * from SGGLDB.dbo.HSSE_Weather
|
||
GO
|
||
|
||
|
||
--HSSE行政管理类别
|
||
insert into SGGLDB_NEW.dbo.HSSE_Administrative_CheckTypeSet select * from SGGLDB.dbo.HSSE_Administrative_CheckTypeSet
|
||
GO
|
||
|
||
|
||
-- 管道焊接系统设置、报表
|
||
insert into SGGLDB_NEW.dbo.Project_Sys_Set select * from SGGLDB.dbo.Project_Sys_Set
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Common_ReportServer select * from SGGLDB.dbo.Common_ReportServer
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_Component select * from SGGLDB.dbo.HJGL_BS_Component
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_WeldMaterial select * from SGGLDB.dbo.HJGL_BS_WeldMaterial
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_SchTab select * from SGGLDB.dbo.HJGL_BS_SchTab
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_NDTRate select * from SGGLDB.dbo.HJGL_BS_NDTRate
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_SlopeType select * from SGGLDB.dbo.HJGL_BS_SlopeType
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_Steel select * from SGGLDB.dbo.HJGL_BS_Steel
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_Service select * from SGGLDB.dbo.HJGL_BS_Service
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_IsoClass select * from SGGLDB.dbo.HJGL_BS_IsoClass
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_PackageTestType select * from SGGLDB.dbo.HJGL_BS_PackageTestType
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_NDTType select * from SGGLDB.dbo.HJGL_BS_NDTType
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_JointType select * from SGGLDB.dbo.HJGL_BS_JointType
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_WeldMethod select * from SGGLDB.dbo.HJGL_BS_WeldMethod
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.HJGL_BS_MaterialCompare select * from SGGLDB.dbo.HJGL_BS_MaterialCompare
|
||
GO
|
||
|
||
|
||
--HSSE，质量：特岗证书，
|
||
insert into SGGLDB_NEW.dbo.CQMS_Base_Certificate select * from SGGLDB.dbo.CQMS_Base_Certificate
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.HSSE_Base_Certificate select * from SGGLDB.dbo.HSSE_Base_Certificate
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.CQMS_Base_FileType select * from SGGLDB.dbo.CQMS_Base_FileType
|
||
GO
|
||
|
||
--单位资质类别
|
||
insert into SGGLDB_NEW.dbo.CQMS_Quality_UnitQualitySort select * from SGGLDB.dbo.CQMS_Quality_UnitQualitySort
|
||
GO
|
||
|
||
insert into SGGLDB_NEW.dbo.CQMS_Base_Equipment select * from SGGLDB.dbo.CQMS_Base_Equipment
|
||
GO
|
||
|
||
|
||
--模板
|
||
insert into SGGLDB_NEW.dbo.Common_FileManageType select * from SGGLDB.dbo.Common_FileManageType
|
||
GO
|
||
insert into SGGLDB_NEW.dbo.Common_FileManage(FileCode,FileName,FileSize,FileType,FileContent,BigType,SmallType,FileCreate,FileDate)
|
||
select FileCode,FileName,FileSize,FileType,FileContent,BigType,SmallType,FileCreate,FileDate from SGGLDB.dbo.Common_FileManage
|
||
GO
|
||
|
||
--分包商
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Base_CompositeAppraise
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Base_CompositeAppraise
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_ManagerItem
|
||
SELECT * FROM SGGLDB.dbo.FBZY_ManagerItem
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Base_PeriodicReviewDate
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Base_PeriodicReviewDate
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Base_RedesignLevel
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Base_RedesignLevel
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Base_RedesignLevelConditions
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Base_RedesignLevelConditions
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Base_RewardPunish
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Base_RewardPunish
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_Regedit
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_Regedit
|
||
GO
|
||
--
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_AchievementsItem
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_AchievementsItem
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_AssessmentLevel
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_AssessmentLevel
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_CooperateWithLPEC
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_CooperateWithLPEC
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_ShortList
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_ShortList
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_Quality_UnitQualitySort
|
||
SELECT * FROM SGGLDB.dbo.FBZY_Quality_UnitQualitySort
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_WEB_SubUnitSort
|
||
SELECT * FROM SGGLDB.dbo.FBZY_WEB_SubUnitSort
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_QualityAudit_SubUnitQuality
|
||
SELECT * FROM SGGLDB.dbo.FBZY_QualityAudit_SubUnitQuality
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_QualityAudit_SubUnitQualityCopy
|
||
SELECT * FROM SGGLDB.dbo.FBZY_QualityAudit_SubUnitQualityCopy
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitGradeCertificate
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitGradeCertificate
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitRule
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitRule
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitRuleApprove
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitRuleApprove
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitRuleApproveBak
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitRuleApproveBak
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitRuleBak
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitRuleBak
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitShortList
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitShortList
|
||
GO
|
||
|
||
INSERT INTO SGGLDB_NEW.dbo.FBZY_UnitShortListItem
|
||
SELECT * FROM SGGLDB.dbo.FBZY_UnitShortListItem
|
||
GO
|
||
|
||
|
||
--新表执行：装置
|
||
insert into SGGLDB_NEW.dbo.Base_Installation select * from SGGLDB.dbo.Base_Installation
|
||
GO |