August 18, 2004 at 8:52 am
I wasn’t sure in exactly which forum to post this so I have chosen this one. It is regarding devising a certain strategy and its implementation.
Scenario is, my client has an obsolete database design of an ecommerce site which has been redesigned by us and the new design has many improvements over the old one which also means that both schemas are different now. Customer front-end of the new the design has been developed and its running but admin side will still take some to become live. Until then my clients wants that the orders which arrive in new design get translated into old design so that they can use old admin front end for reporting purposes( again, reporting for the new design wont come live soon and will not for atleast a month).
My question is what should be the best strategy to transform data from one schema to another? Note they don’t want to use triggers or any time based job to transfer data. Is there any third party tool which we can use? Or any other trick? Maybe use old design’s procedures on front end with the new one? But that will create double network traffic.
Thanks in advance
Saad
August 19, 2004 at 8:18 am
Saad,
You can use DTS for transferring Data
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply