>-----Original Message-----
>You could try with the SQL Compare tool - www.red-
gate.com.
>
>--
>Dejan Sarka, SQL Server MVP
>Please reply only to the newsgroups.
>
>"Carolyn Flamme" <anonymous@discussions.microsoft.com>
wrote in message
>news:09fd01c3d5b4$cc762430$a101280a@phx.gbl...
>> Hi!
>>
>> I have just completed a database consolidation which
>> combined the data of 2 databases same schema.
>>
>> I did it in such a way that the effort was quite
manual.
>>
>> Steps like:
>> 1. per table resequence the identity columns on the
>> database tables to be inserted.
>> 2. Then import the tables using DTS one by one until
>> complete.
>>
>> I would like to automate this procedure because I need
to
>> consolidate two more of the same databases into the now
>> existing consolidated database.
>>
>> What I'm doing seems to me a little basic. I'm not a
>> programmer, what I want to know is if there are any
tips
>> or tools that people use or can recommend whereby I
could
>> automated a job like this one?
>>
>> Maybe someone has some sample scripts that they have
used
>> for something similar.
>>
>> Thanks!!
>> Carolyn
>
>
>.