select * into b.dbo.a1 from a.dbo.a1 select * into b.dbo.a2 from a.dbo.a2 select * into b.dbo.a3 from a.dbo.a3
如楼上所有数据和大大部分数据结构如需要完全一样 将a库中的表生成脚本,到b库创建,然后导数据 insert into b.dbo.a1 select * from a.dbo.a1 insert into b.dbo.a2 select * from a.dbo.a2 insert into b.dbo.a3 select * from a.dbo.a3
方法一: 如一楼: Select * Into b.dbo.a1 from a.dbo.a1 Select * into b.dbo.a2 from a.dbo.a2 select * into b.dbo.a3 from a.dbo.a3上述语句能保证完全的结构一致 但是如果有标识列和主键,您需要手动加上主键(在标识列上)。 方法二: 可以通过DTS,不过在DTS过程中,需要选择导入对象和数据,而不是单纯的数据。OK
Select * Into b.dbo.a1 from a.dbo.a1 Select * into b.dbo.a2 from a.dbo.a2 select * into b.dbo.a3 from a.dbo.a3 如果有主键、约束和索引都要自己手工在新表中创建
select * into b.dbo.a2 from a.dbo.a2
select * into b.dbo.a3 from a.dbo.a3
将a库中的表生成脚本,到b库创建,然后导数据
insert into b.dbo.a1 select * from a.dbo.a1
insert into b.dbo.a2 select * from a.dbo.a2
insert into b.dbo.a3 select * from a.dbo.a3
如一楼:
Select * Into b.dbo.a1 from a.dbo.a1
Select * into b.dbo.a2 from a.dbo.a2
select * into b.dbo.a3 from a.dbo.a3上述语句能保证完全的结构一致
但是如果有标识列和主键,您需要手动加上主键(在标识列上)。
方法二:
可以通过DTS,不过在DTS过程中,需要选择导入对象和数据,而不是单纯的数据。OK
Select * Into b.dbo.a1 from a.dbo.a1
Select * into b.dbo.a2 from a.dbo.a2
select * into b.dbo.a3 from a.dbo.a3 如果有主键、约束和索引都要自己手工在新表中创建