What data mapping tool is good for mid size projects

Question

I need a data(and metadata) mapping tool for mapping one database metadata to other. Are there any cheap tools available for that purpose?

Answer 1

If you are talking about converting (or switching) from one database to another it really depends on the databases you are switching to and from. There are tools out there to do this, but many are specific to certain databases.

I am assuming that you want to take your existing schema and data, and import them into a different database. The best bet is to use a tool (mysql_dump for example) to export the schema and data to standard SQL then just run the script on the destination db.

If you are talking about syncing schemas between the same brand of database then there are other tools for that purpose (RedGate SQL Compare & Data Compare for instance).

If you want more specifics please include the type of databases and whether you want to convert on sync.

Cheers, V

Answer 2

for just defining the Maps I find Excel to be a great tool. You may also be interested in the Microsoft Open Source project for Meta-data Driven ETL (http://www.codeplex.com/SQLServerMDDEStudio)

Answer 3

I am essentially taking about database schema, however I don't want to switch from one database to other. Actually I want to map two different databases and store those mapping somewhere.

Answer 4

EDIT: I didn't see "cheap" in the OP. PD is not cheap, but I think it is worth it. You have a free 15 days to find out.

I highly recommend PowerDesigner. You can download a free, fully-functional trial from Sybase.

basically you'd reverse engineer each schema into their own models... then you could either map the two together using an integrated mapping tool or you could build a third model, perhaps a Conceptual Datamodel that describes what those things mean to the business and map each of the schemas to this conceptual model. Very effective at describing your existing databases.