Data Model Changes
-
Hi All,
I am working on Data base/Model for a project which is going into production soon. But, due to users requirement, there is a inevitable change to rename a table to user freindly name. For example, there are History, HistoryEquip, HistoryGroup, HistoryMember, HistoryFreight, etc tables which are to be renamed with Stats, StatsEquip, StatsGroup, StatsMember, StatsFreight etc.
Accordingly, the column names containing History will similarly replaced with Stats.
How do i analyze the Impact with respect to following cases:
1. Table dependecy (How do i know the table dependencies)
2. Stored Proc dependencies. I have Insert, Update, Delete and Get stored proc for each table. How do i analyze the impact for the change with respect to stored procedure for each table.
3. Is is a worth to change Table name at this stage, if no, why ?
Quote: Customers are not God. They are Kings !!!
Thnx and Regards,
Prasanta
-
And that are just the adjustments you need to rename the tables.
(You coud script your db and perform the rename textwize and recreate it...
you could also use tools like CA-ERwin, ...  
How about the affected applications/procs ? (are there any ?)
If you find your Kings to be fickly, just create views (1-1) to get over it for a while
. But then keep in mind you might have to bite into this apple later on. Plan that time/impact in your project !Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply