If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Mapping between two different model/database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-07-05, 05:21
hollow_years hollow_years is offline
Registered User
 
Join Date: Dec 2005
Posts: 2
Mapping between two different model/database

Hi everybody,

I've searched through the forum and the internet but i am unable to find any answers to my problem.

I have two different models (so two different database) and actually one of them is the newer version of the other one. Because of this, although these are different models, nearly %60 of the tables and the attributes could be mapped from one of them to the other one.

Well i am searching a tool that can do such mapping or some useful information (books, web pages etc) about this subject. The only thing i can find is : http://www.dmst.com.au/products/dmt.html
But besides that one neither a tool nor an information i could find yet.

Do you have any suggestions or knowledge about this?

Thank you.
Reply With Quote
  #2 (permalink)  
Old 12-07-05, 09:07
urquel urquel is offline
Registered User
 
Join Date: Aug 2004
Posts: 330
Erwin (from CA) may be able to do what you are suggesting.
Reply With Quote
  #3 (permalink)  
Old 12-08-05, 14:06
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
In terms of widely available, general purpose tools I know of two choices. ErWin can definitely do that. The extreme high end (Enterprise Architect?) version of Microsoft's Visual Studio can do it. There may be other tools that can do it too.

There are many database-engine specific tools that will also help with this kind of problem. Some are provided by the engine vendor, others are third party, some are even public domain. You probably have many choices, but its practically impossible to pre-guess what those might be.

-PatP
Reply With Quote
  #4 (permalink)  
Old 12-09-05, 02:13
hollow_years hollow_years is offline
Registered User
 
Join Date: Dec 2005
Posts: 2
These replies are really important for me and thank - both of - you for your quick answers, i'll try ErWin and Microsoft's Visual Studio and ask here again if i have further questions.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On