急两个不同数据库之间结构不同的表复制数据解决方案
急。。。两个不同数据库之间结构不同的表复制数据
数据库中Coustomer_Data 中有个表Coustomer_Info
CREATE TABLE [dbo].[Coustomer_Info] (
[Coustomer_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Coustomer_Hotels] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Coustomer_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Xj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Zw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Phone1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Dq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Sf] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Sx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Tyle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
里面是以前的数据 现在重新做了个系统 数据库为 HEJ 表为 T_CompanyInfo
CREATE TABLE [dbo].[T_CompanyInfo] (
[T_Cpy_Id] [int] IDENTITY (1, 1) NOT NULL ,
[T_Cpy_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Phone1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Dj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Fzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Zw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Dq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Sf] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Sx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
现在怎么把Coustomer_Info中的数据复制到 T_CpmpanyInfo中呀 。。这两个表结列名不相同呀。。。跪请大侠帮忙!!
------解决方案--------------------
2个数据建立连接后,用sql解决
------解决方案--------------------
sql server
数据库中Coustomer_Data 中有个表Coustomer_Info
CREATE TABLE [dbo].[Coustomer_Info] (
[Coustomer_Id] [int] IDENTITY (1, 1) NOT NULL ,
[Coustomer_Hotels] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Coustomer_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Xj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Zw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Phone1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Dq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Sf] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Sx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Tyle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Coustomer_Bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
里面是以前的数据 现在重新做了个系统 数据库为 HEJ 表为 T_CompanyInfo
CREATE TABLE [dbo].[T_CompanyInfo] (
[T_Cpy_Id] [int] IDENTITY (1, 1) NOT NULL ,
[T_Cpy_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Phone1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Dj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Fzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Zw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Dq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Sf] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Sx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[T_Cpy_Bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
现在怎么把Coustomer_Info中的数据复制到 T_CpmpanyInfo中呀 。。这两个表结列名不相同呀。。。跪请大侠帮忙!!
------解决方案--------------------
2个数据建立连接后,用sql解决
insert into tableB(colB1,colB2....)
select colA1,colA2... from table A
------解决方案--------------------
sql server
insert into HEJ.T_CpmpanyInfo(表里的字段) select (表里的字段) from Coustomer_Data.Coustomer_Info