Post reply

Which SQL DB Interfacing to use

  • January 25, 2005 at 3:16 pm

    #102365

    Helo,
     
    At our company we have a lot of troubles with an in house developped datainterfacing framework.
    It is used for importing and exporting data to/from an sql database and
    SAP, MAIFRAME, AS400 and others. The data must be inserted or updated on the fly, this mean no database outages or table-locks for a long period.
     
    Any suggestions of product to replace ours?

  • January 27, 2005 at 1:00 am

    #539275

    DTS comes with SQL Server and is a very versatile program, able to move data to and from a wide variety of applications and file types.  (SQL doesn't even have to be one of them!)

    I don't know much about SAP or AS400, but I recommend starting with DTS before looking for an alternative.

    Good luck.

    Scott

  • January 27, 2005 at 5:36 am

    #539308

    Take a look at using a merge or transaction replication, as well.  It may be a good alternative to DTS.

    What may be troublesome are your external systems and having them work with SQL Server's replication. 

    Are your external sources registered as remote servers on your SQL Server?  How do you get "to and fro" between the disparate systems?

  • January 31, 2005 at 2:31 am

    #539693

    At this moment all data is delivered in XML files, the inhouse delivered interface has performance troubles with inserting or update this data in the database. Thats way we are looking for an alternative.
    A second problem is that these database server is behind a firewall thats the reason that all data is delivered in xml files.
     
     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply