lyfz_repos/经典版源码/document/数据库维护脚本/转移数据.sql

use master
go
select * into [temp].[dbo].[area] from [db].[dbo].[area]
select * into [temp].[dbo].[bakstate] from [db].[dbo].[bakstate]
select * into [temp].[dbo].[baseexpendtype] from [db].[dbo].[baseexpendtype]
select * into [temp].[dbo].[bumen] from [db].[dbo].[bumen]
select * into temp.dbo.burncdreg from db.dbo.burncdreg
select * into temp.dbo.businessintention from db.dbo.businessintention
select * into temp.dbo.businesstype from db.dbo.businesstype
select * into temp.dbo.childmsg from db.dbo.childmsg
select * into temp.dbo.client from db.dbo.client
select * into temp.dbo.client2 from db.dbo.client2
select * into temp.dbo.client2phonerecord from db.dbo.client2phonerecord
select * into temp.dbo.client2phonerecordout from db.dbo.client2phonerecordout
select * into temp.dbo.client3 from db.dbo.client3
select * into temp.dbo.client3phonerecord from db.dbo.client3phonerecord
select * into temp.dbo.client3phonerecordout from db.dbo.client3phonerecordout
select * into temp.dbo.clientfrom from db.dbo.clientfrom
select * into temp.dbo.clientqequirement from db.dbo.clientqequirement
select * into temp.dbo.clientreason from db.dbo.clientreason
select * into temp.dbo.clienttype from db.dbo.clienttype
select * into temp.dbo.digitalwork from db.dbo.digitalwork
select * into temp.dbo.dindan from db.dbo.dindan
select * into temp.dbo.dindanbukuan from db.dbo.dindanbukuan
select * into temp.dbo.dindanbukuan2 from db.dbo.dindanbukuan2
select * into temp.dbo.dindanjd from db.dbo.dindanjd
select * into temp.dbo.dindansp from db.dbo.dindansp
select * into temp.dbo.dindansp2 from db.dbo.dindansp2
select * into temp.dbo.dindansp3 from db.dbo.dindansp3
select * into temp.dbo.dressarea from db.dbo.dressarea
select * into temp.dbo.dresshire from db.dbo.dresshire
select * into temp.dbo.dresshiredata from db.dbo.dresshiredata
select * into temp.dbo.dressinfo from db.dbo.dressinfo
select * into temp.dbo.dresstype from db.dbo.dresstype
select * into temp.dbo.employeephonerecord from db.dbo.employeephonerecord
select * into temp.dbo.employeephonerecordout from db.dbo.employeephonerecordout
select * into temp.dbo.expendtype from db.dbo.expendtype
select * into temp.dbo.files from db.dbo.files
select * into temp.dbo.fixedassets from db.dbo.fixedassets
select * into temp.dbo.framesize from db.dbo.framesize
select * into temp.dbo.gongyingshang from db.dbo.gongyingshang
select * into temp.dbo.growthtx from db.dbo.growthtx
select * into temp.dbo.gudingfeiyong from db.dbo.gudingfeiyong
select * into temp.dbo.gudingfeiyongxiangmu from db.dbo.gudingfeiyongxiangmu
select * into temp.dbo.historydb from db.dbo.historydb
select * into temp.dbo.hospital from db.dbo.hospital
select * into temp.dbo.hospitalclient from db.dbo.hospitalclient
select * into temp.dbo.hospitalclientcontactreg from db.dbo.hospitalclientcontactreg
select * into temp.dbo.insidemsg from db.dbo.insidemsg
select * into temp.dbo.jd from db.dbo.jd
select * into temp.dbo.jdd from db.dbo.jdd 
select * into temp.dbo.log from db.dbo.log
select * into temp.dbo.loginsign from db.dbo.loginsign
select * into temp.dbo.loninbanset from db.dbo.loninbanset
select * into temp.dbo.lonindata from db.dbo.lonindata
select * into temp.dbo.lonintimeset from db.dbo.lonintimeset
select * into temp.dbo.membercard2 from db.dbo.membercard2
select * into temp.dbo.membercard2blue from db.dbo.membercard2blue
select * into temp.dbo.membercard3 from db.dbo.membercard3
select * into temp.dbo.membercard3childusereg from db.dbo.membercard3childusereg
select * into temp.dbo.membercard3usereg from db.dbo.membercard3usereg
select * into temp.dbo.membermanage from db.dbo.membermanage
select * into temp.dbo.membermanageblue from db.dbo.membermanageblue
select * into temp.dbo.memberreg from db.dbo.memberreg
select * into temp.dbo.memberreg2 from db.dbo.memberreg2
select * into temp.dbo.memberreg2blue from db.dbo.memberreg2blue
select * into temp.dbo.memberreg3 from db.dbo.memberreg3
select * into temp.dbo.memberreg4 from db.dbo.memberreg4
select * into temp.dbo.memberregblue from db.dbo.memberregblue
select * into temp.dbo.misscallrecord from db.dbo.misscallrecord
select * into temp.dbo.msgcode from db.dbo.msgcode
select * into temp.dbo.msgtemp from db.dbo.msgtemp
select * into temp.dbo.msgtemp2 from db.dbo.msgtemp2
select * into temp.dbo.mywork from db.dbo.mywork
select * into temp.dbo.Part from db.dbo.Part
select * into temp.dbo.path from db.dbo.path
select * into temp.dbo.phonerecord from db.dbo.phonerecord
select * into temp.dbo.phonerecordout from db.dbo.phonerecordout
select * into temp.dbo.photoprint from db.dbo.photoprint
select * into temp.dbo.renyuan from db.dbo.renyuan
select * into temp.dbo.rewards from db.dbo.rewards
select * into temp.dbo.salary from db.dbo.salary
select * into temp.dbo.sale2type from db.dbo.sale2type
select * into temp.dbo.sendreg from db.dbo.sendreg
select * into temp.dbo.sendreg2 from db.dbo.sendreg2
select * into temp.dbo.sendregcard from db.dbo.sendregcard
select * into temp.dbo.sendregdelay from db.dbo.sendregdelay
select * into temp.dbo.sendregreceive from db.dbo.sendregreceive
select * into temp.dbo.shangpin from db.dbo.shangpin
select * into temp.dbo.shangpinlb from db.dbo.shangpinlb
select * into temp.dbo.singleincome from db.dbo.singleincome
select * into temp.dbo.singleincomemoney from db.dbo.singleincomemoney
select * into temp.dbo.storeinfo from db.dbo.storeinfo
select * into temp.dbo.storeinfo2 from db.dbo.storeinfo2
select * into temp.dbo.taoxi from db.dbo.taoxi
select * into temp.dbo.taoxifg from db.dbo.taoxifg
select * into temp.dbo.taoxishangpin1 from db.dbo.taoxishangpin1
select * into temp.dbo.taoxishangpin2 from db.dbo.taoxishangpin2
select * into temp.dbo.todaytake from db.dbo.todaytake
select * into temp.dbo.txlb from db.dbo.txlb
select * into temp.dbo.txlb2 from db.dbo.txlb2
select * into temp.dbo.unknownphonerecord from db.dbo.unknownphonerecord
select * into temp.dbo.unknownphonerecordout from db.dbo.unknownphonerecordout
select * into temp.dbo.[update] from db.dbo.[update]
select * into temp.dbo.[user] from db.dbo.[user]
select * into temp.dbo.version from db.dbo.version
select * into temp.dbo.workrate from db.dbo.workrate
select * into temp.dbo.worktype from db.dbo.worktype
select * into temp.dbo.xtcs from db.dbo.xtcs