Daily data refresh problem

Hi
We are a relational datamodel with 123 tables of which we would like to
refresh data in 7 tables using sql scripts . The tables should be refreshed
with new rows or updated rows. But the problem is that these 7 tables have
many referential integrity constraints on them which makes the data refresh
difficult using sql statements.
Can you please suggest a way to refresh the data without using replication.
Thanks
Have a look at Red Gate's DataCompare. I believe this has the functionality
you are looking for.
Hilary Cotter
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
"Bob" <Bob@.discussions.microsoft.com> wrote in message
news:BFC768C3-7018-4D8D-9F14-06DCEAA7979B@.microsoft.com...
> Hi
> We are a relational datamodel with 123 tables of which we would like to
> refresh data in 7 tables using sql scripts . The tables should be
refreshed
> with new rows or updated rows. But the problem is that these 7 tables have
> many referential integrity constraints on them which makes the data
refresh
> difficult using sql statements.
> Can you please suggest a way to refresh the data without using
replication.
> Thanks