存储过程实现数据库数据迁移 高分奉上...

Question

想利用SQL的存储过程写一个数据库数据转移的脚本（直接的从旧库导出对应到新库中） 以前从来没用过这个东西 不知道怎么下手 大哥们帮帮忙

Answer 1

dbo.gc_project(旧库中的数据)
project_id   int
project_name varchar(100)
project_active int
project_number varchar(100)
project_plan_start_date datetime
project_plan_end_date datetime
project_start_date datetime
project_end_date datetime
project_order_id int
project_comment varchar(6000)
project_whole_project_id int
project_email_from varchar(50)   dbo.Projcet(新库中的表)
Id int
ProjectNum nvarchar(50)
Name nvarchar(50)
PlanStartDate datetime 
PlanEndDate datetime
StartDate datetime
EndDate datetime
ProjectLeaderName nvarchar
ParentProjectId int
AttachmentId int
Description nvarchar(512)
Comment nvarchar(512)
Purpose nvarchar(512)
BudgetId nvarchar(512)
IsParentProject bit
ProjectState int
CreatorName nvarchar(50)
CreateTime datetime
ModelId int
OrganizationId int
CodeRuleStorageId int
CustomerDatumStorageId int
ProjectSumStorageId int
PersonalSumStorageId int
CurrentVerId int
ScmName nvarchar(50)
SqaName nvarchar(50)
CustomerId int
ProgramLanguage int
ProjectScale int
ProjectType int
InterfaceType int
ProjectStorageId int表名发生了改变 但内容没有发生变化 这样对应上 用存储过程 大哥帮帮我