Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Unanswered: Transferring data from AS400 to SQL Server

    Hi all,
    I am working at insurance company that using AS400 as it main server. All transaction data is already kept for about 10 years (or even more..). This data is growing larger from time to time, and after several upgrades (that cost a lot!), my supervisor has an idea to partly move the data from AS400 to SQL Server. (since the cost for upgrading sql server is cheaper than AS400).

    So.. let say, we only want to kept data in AS400 from 4 years before until now (2004 – 2007), and the rest of data is kept in SQL Server.

    So first, all transaction data from 1997 – 2003 is transferred to SQL and deleted in AS400.
    If user queried data and didn’t found the data in AS400, it will search the SQL, if data is found in SQL, then data is transferred back to AS400 and deleted in SQL.

    I’m using SQL Server 2000 DTS (use HiT OLEDB) to transfer the data from AS400 to SQL and vice versa.

    I wanna ask if anyone has done this before? What’s the difficulties by using this approach? (btw, I will implement the DTS using user control in vb.net)

    Or anyone has a better solution to overcome this problem?

    Thanks,
    [RU]

  2. #2
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    Are u using Linked servers whit OPENQUERY ?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by MencitPutih
    If user queried data and didn’t found the data in AS400, it will search the SQL...
    [RU]
    What do you mean it will?

    How?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •