Merging two dbs

29 Mar 2006 12:34 AM

John

Hi

I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?

Thanks

Regards

29 Mar 2006 2:00 AM

Andrew J. Kelly

The easiest way would be to add an instance of 2005 on that server and
simply copy them<g>. But assuming that is not an option and you have not
used any 2005 specific features or datatypes you can still do it. First
script all the objects using SSIS and then run those scripts in the other
db. Then export the data from the 2005 dbs and import them into the tables
in the 200 instance. Make sure to backup everything first.

--
Andrew J. Kelly SQL MVP

Show quote

"John" <John@nospam.infovis.co.uk> wrote in message
news:%23AinXisUGHA.4956@TK2MSFTNGP09.phx.gbl...
> Hi
>
> I have two sql server 2005 dbs on server A. I need to copy all items
> (tables, view, sps and so on) from the two dbs into a single db on server
> B. The added problem is that server B is SQL Server 2000 so direct copy is
> perhaps not possible. How can I achieve this?
>
> Thanks
>
> Regards
>
>
>