Database Refactoring

Last Post 09 Mar 2007 08:46 AM by GoldenGal. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
fmalchemist1983
New Member
New Member

--
08 Feb 2007 06:00 AM
I have been given two Data models, for the sake of simplicity let me call these models A and B. Now each of these models have a bunch of tables and preexisting relationships. Both of these models try to solve the same basic problem. Now my task is to refactor Data Model B into something closely resembling Data Model A. So in layman's terms, Data Model B should look like Data Model A while incorporating the additional tables that are essential to drive the application that uses Data Model A.
What would be the most effecient way of going through this process knowing the fact that Model B has close to 75 tables and Model A has 63 tables.

Any help will be appreciated.
SQLUSA
New Member
New Member

--
22 Feb 2007 08:30 PM
You should setup a new table:

create table MappingFromBToA (
Btable syname,
Bcolumn sysname,
Btype sysname,
Atable sysname,
Acolumn sysname,
Atype sysname,
NatureOfMappingID,
......
)

All you have to do populate this table and have developms/dbas come up with a data transit plan.

Kalman Toth
SQLUSA: htpp/www.sqlusa.com
GoldenGal
New Member
New Member

--
09 Mar 2007 08:46 AM

If you have a small budget to spend on this, look in to Red Gate SQL Compare -- it'll do the comparisons and give you a report of differences, db to db, in a fraction of the time that a manual process would take.
You are not authorized to post a reply.

Acceptable Use Policy