Help needed to merge a few database - same tables

Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.

The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.

I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.

Thanks
RG

I think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



wrote in message
news:

Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.

The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.

I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.

Thanks
RG

Hi, Hillary
How are your doing?

I was thinking about SNAPSHOT replication instead of transactional
,because the OP said he needs it on daily bases.
Well, I think it is easy to handle , however I'm not sure about ROLLBACK
in case of the failure.







"Hilary Cotter" wrote in message
news:%

I think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



wrote in message
news:

Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.

The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.

I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.

Thanks
RG