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

    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
    Andover, MA
    I found I got better performance by setting up alinked server, and copying the tables with a stored procedure, than I did with DTS.

Posting Permissions

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