akohan
asked on
Database synchronization
Hello group,
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.
Regards,
Amit
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
so if it is only pulling data from db2 to sql server i would use SSIS to perform this movement. by using a job you can schedule the package to run almost continuously
ASKER
But one thing worries me is that you as a customer by placing an order online should be able to see a history of all orders, but this way since all taxing and shipping calculations will happening on IBM end (since it has its own system) then I only can issue and keep qty and price before tax and shipping.
and updating that again will burden the system.
Any idea?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Momi_Sabag,
Thank for your questions I will try to explain the scenario but please ask me questions if I have not covered something:
We have two ends:
1) Online (SQL Server)
2) IBM (DB2)
Online system has all the products info that will be sold online however, DB2 has the same information and also customer information (from 30 years ago!).
The scope of project was that people will register from online end and was assumed that people would then can find product/parts and add them to cart and place an order.
However, now in the last step the person (working with managers who have no technical knowledge) I'm work for has explained that they must have existing customer information in online (SQL Server) since existing customer can have their special pricing (base on a discount % parameter).
So as you see my input is changing from online registration page to data coming from DB2. Also, I need to find out what is the discount rate for each existing customer that comes from DB2 as well.
The way I see it, it is a one way sync (from DB2 to SQL Server). So when one of those customer places an order I will pass order details and customer information to DB2 using csv file so somebody on their team can suck it up into DB2.
As far as lag, I guess for now it would be OK 2 hours all they will do they will send an email to customer that order has been placed and ...
Let me know if you have further questions.
Thanks.