|
|
Posted by Dave Markle on 01/22/07 05:58
In a word, no. You should probably restore both databases to a single
machine, and write a script to combine the data.
There are tools to compare the data in the two databases (Like Red
Gate's SQL Data Compare), but AFAIK nothing to combine the data.
-Dave
Rodjk #613 wrote:
> Hello,
> I am working with a database that is in use in several locations.
> The structure of the databases are identical, but the data is
> different.
> I am tasked with combining the data into one large database.
> (It is SQL 2000)
>
> I have .bak files for each location.
> Is there any way to restore a backup into a database, combining the
> data?
>
> If not, what is the best way to accomplish this?
>
> Thanks,
> Rodjk #613
>
--
-Dave Markle
http://www.markleconsulting.com/blog
Navigation:
[Reply to this message]
|