Database Refactoring

Last Post 09 Mar 2007 08:46 AM by GoldenGal. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
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.
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,

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

Kalman Toth
SQLUSA: htpp/
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.

Acceptable Use Policy