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
It may be possible. Posting the DDL of the seven tables would be helpful.
However, in an ETL sceario foriegn key constraints are usually not placed on
the destination. If it's vital that the relationships are exactly
maintained, create a validation process and run it after the ETL load.
"Bob" <Bob@.discussions.microsoft.com> wrote in message
news:5FC5BF41-F6D3-44D8-A3DF-B2022744D656@.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