pubwin2009合并数据库

1.确保local.dbo.leveltype和local1.dbo.leveltype两个表的levelid和levelname不一样。

2.确保local.dbo.mem_localmemberbaseinfo和local1.dbo.mem_localmemberbaseinfo中的id不重复。

update mem_localmemberbaseinfo set id=id+100000;

3.local.dbo.mem_localdisountaccount和local1.dbo.mem_localdiscountaccount同步骤2。

update mem_localdiscountaccount set id=id+100000;

4.合并三个表。

insert into local.dbo.mem_localmemberbaseinfo select * from local1.dbo.mem_localmemberbaseinfo;

insert into local.dbo.mem_localdiscountaccount select * from local1.dbo.mem_localdiscountaccount;

insert into local.dbo.leveltype select * from local1.dbo.leveltype.

5.检查unqueid重复值。

select count(uniqueid) from local.dbo.mem_localmemberbaseinfo group by uniqueid having count(uniqueid)>1

6.合并重复uniqueid的balance列。

update mem_localmemberbaseinfo set balance=(

                       select sumu from (select count(uniqueid) as count,sum(balance) as sumu

                                   group by uniqueid having count(uniqueid)>1) x) where ...

7.删除重复的不再需要的uniqueid.