I'm having a situation which need to get some advice from experts who have imported data from an existing database (traditional system ) into a different/new database.
Long story short, there is an old IBM machine which is used and still in use of a company. Now, this company has decided to go online but after I've setup the online system has come up with different idea! meaning that they want the new database (MS SQL Server) be synchronized with their DB2.
Of course, as you have guessed both will be dealing with the same product but the layout, structure and tables are totally different.
What is the best approach base on your experience?
correct me if I'm wrong. I'm thinking of creating some tables the same as those on DB2 end and somehow maybe using trigger or ... feed them into new tables.
Assume there is a customer table on DB2 end (let's say db2_Customer) so I will import it into MS SQL Server 2008 and will extract necessary information from temp table into my customer table.
Currently I'm kind of jumping around since time is another issue but will appreciate it experts could give me some advice.