What is best way to best way to migrate data from one product to another if both software companies refuse to reveal the database structure to one another?
views:
38answers:
4
+1
A:
morse code? smoke signals? braille?
really, it sounds like an untenable situation between two parties that have no confidence in once another and sounds poisonous.
Sky Sanders
2010-07-23 06:43:48
Maybe they won't have to work with one another again? (Right …) I'd imagine company A has been doing the data center for customer C so far and customer C wants to move to company B now. A and B being competitors, they don't really want to tell one another the details of how they work.
Christopher Creutzig
2010-07-23 06:50:53
+1
A:
dump the data to a csv and hand it to the other company. A good DBA can take the data and write a sufficient import script that maps them to the correct datatypes on the other end.
controlfreak123
2010-07-23 06:44:27
chances are unless the application the second company is using is totally different they should have a pretty good idea what data needs to go where.
controlfreak123
2010-07-23 06:47:16
+3
A:
Define some database structure capable of holding all the relevant information (it doesn't need to be optimized in any way), have the first company dump their data into that and the second one import it.
Christopher Creutzig
2010-07-23 06:48:46
A:
Holy smoke. Sounds like great fun of yours ;-).
Just some ideas:
If you have access to the database... for a good dba the migration should be no problem at all.
Another way would be that one company creates views to hide the underlaying datastructures and the other company can import those views.
Otherwise just let them dump the data into flat files and import those files.
Yves M.
2010-07-23 06:55:30