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.
ThanksIt 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

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

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

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.
ThanksIt 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