Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: Transfering data from informix to sql server

    I need to transfer seven tables from Informix DB to SQL Server every night. Any suggestions for the best way of doing it? Is DTS the best way? How about through replication?

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    I found I got better performance by setting up alinked server, and copying the tables with a stored procedure, than I did with DTS.
    -bpd

Posting Permissions

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