旧版数据导入新版数据方法.docVIP

旧版数据导入新版数据方法.txt21春暖花会开！如果你曾经历过冬天，那么你就会有春色！如果你有着信念，那么春天一定会遥远；如果你正在付出，那么总有一天你会拥有花开满圆。2010.01.17 龙岗数据转新版数据 旧数据库类型A 旧数据库类型B 先备份新旧数据库，然后升级 1. DEPART ---- tbDepartment 31 ------------- 0 其它不变 改表与DOCTORUSER关联，因此要修正DOCTORUSER.DEPARTID SQL 语句如下 旧数据库类型A: DELETE FROM MedImgMgrSysLG.dbo.tbDepartment; DELETE FROM EndoscopeLG.dbo.DEPART WHERE DEPARTID=-1; UPDATE EndoscopeLG.dbo.DEPART SET DEPARTID=0 WHERE DEPARTID=31; UPDATE EndoscopeLG.dbo.DOCTORUSER SET DEPARTID=0 WHERE DEPARTID=31; INSERT MedImgMgrSysLG.dbo.tbDepartment(DepartmentID, DepartmentName) SELECT DEPARTID, DEPARTDESC FROM EndoscopeLG.dbo.DEPART; 2. DOCTORUSER ---- tbDoctor (1)LEVELCODE ----- AuthCode 255 ------------- 1023 1 ------------- 1 2 ------------- 563 (2)LOGINPWD ----- LoginPasswd (3)WORKID ----- WorkID DOCTORUSER.WorkID = tbDoctor.WORKID + 1000 ??? (4) HIRESTATUS ----- HireStatus DOCTORUSER.Status = tbDoctor.HIRESTATUS - 1 (5) SEX ----- Sex 0 ------------- 1 1 ------------- 2 2 ------------- 0 (6) DUTYID ----- DutyID DOCTORUSER.DutyID = tbDoctor.DUTYID - 1 (7) CNNAME ----- LoginName, NameCN DOCTORUSER.LoginName = tbDoctor.CNNAME DOCTORUSER.NameCN = tbDoctor.CNNAME (8) DEPARTID ----- DepartmentID DOCTORUSER.DepartmentID = tbDoctor.DEPARTID SQL 语句如下 旧数据库类型A: 首先修改LEVELCODE类型由tinyint改为int，然后执行 UPDATE EndoscopeLG.dbo.DOCTORUSER SET LEVELCODE=1023 WHERE LEVELCODE=255; UPDATE EndoscopeLG.dbo.DOCTORUSER SET LEVELCODE=563 WHERE LEVELCODE=2; UPDATE EndoscopeLG.dbo.DOCTORUSER SET SEX=SEX+1; UPDATE EndoscopeLG.dbo.DOCTORUSER SET SEX=0 WHERE SEX=3; UPDATE EndoscopeLG.dbo.DOCTORUSER SET HIRESTATUS=HIRESTATUS; UPDATE EndoscopeLG.dbo.DOCTORUSER SET DUTYID=DUTYID-1; INSERT MedImgMgrSysLG.dbo.tbDoctor(WorkID, DepartmentID, LoginName, LoginPasswd, AuthCode, HireStatus, DutyID, Sex) SELECT WORKID, DEPARTID, CNNAME, ISNULL(LOGINPWD,), LEVELCODE, ISNULL(HIRESTATUS, 0), DUTYID, SEX FROM EndoscopeLG.dbo.DOCTORUSER; 3. tbPatientInformation ----- PATIENTE, PATIENTSELF (1) Me