Forums Últimos mensajes - Powered by IBM
 
Tags Palabras claves

Help needed to merge a few database - same tables

04/07/2006 - 13:51 por ran_gl | Informe spam
Ayuda Hacer una pregunta
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
email Siga el debateRespuesta 3 respuestasRespuesta Tengo una respuesta
DRAGON AGE™: INQUISITION – Matadragones
 

Leer las respuestas

#1 Hilary Cotter
04/07/2006 - 14:00 | Informe spam
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

Preguntas similares

 

Busqueda sugerida :