Home Forums SQL Server 2005 T-SQL (SS2K5) Best approach for Data transfer of large number of rows RE: Best approach for Data transfer of large number of rows

  • April 3, 2014 at 2:54 am

    #1702767

    Megha P (4/3/2014)

    Actually, we have tables with more than 150 columns and it's harder to manage it (insert) .

    so tables are denormalized now.

    source and destination databases are on different server.

    Thanks,

    megha

    If they databases are on different servers, I would go for SSIS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP