February 13, 2006 at 10:16 am
Hi,
I have this issue, my SQL2k DB tables are not using SQL native
constrains and checks to implement tables relationship due to
the need to import legacy data.
In the meantime, I need to continue with my project. We need
a way to store all the table relationships between tables
in some table for my application to know the relationship.
In addition, we need to know when any of the columns value in the
tables changes, we need to know which tables will be affected
by these changes using the relationship design above. We need
some sort of impact analysis tools.
I though of implementing similar database design table like the SQL2k system
tables where it store all the table,columns and etc to implement my task.
Anyone got better way or know of any tool to do it. Please kindly
advise/guide me.
Thank you
February 13, 2006 at 10:40 am
You mentioned that the reason why you cannot use SQL Server's constraints to enforce referencial integrity because you need to import legacy data. How often is this legacy data being imported? Nightly, Weekly, hourly?
February 13, 2006 at 6:42 pm
Hi,
The main reason for not using SQL native referenical integrity is we need to help
user to import their data one stage at a time. We can't import all of them at one shot as user themselves are not sure of the data integrity issues too.
So, with most of them data in, we need to proceed to another phrase of our project.
Hence, we need to look at this issue as we also need to build a 'impact analysis' tool
for user use, hence we need the relationship fact table.
February 14, 2006 at 9:02 am
In that case, your suggestion of creating tables similar to the system tables will work. I can not think of a better way.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply